升到2017版发现服务器经常死机，请问该如何处理？
升到2017版发现服务器经常死机，请问该如何处理？现在两台服务器都是这样，一台8G内存 ，一台4G内存
您好，看下出现这种情况的是时候 在服务器的进程里CUP和内存占用情况是否都正常 通达曾圆圆 发表于 2018-4-27 19:08
您好，看下出现这种情况的是时候 在服务器的进程里CUP和内存占用情况是否都正常 ...
mysql的占用一直飙升，不会释放内存。 灰常牛掰滴锅锅 发表于 2018-5-2 14:27
mysql的占用一直飙升，不会释放内存。
？给个说法啊？ 您好，若您的服务器是64位的话可以尝试替换64位数据库服务文件（注意：替换之前原文件做好备份！！）
修改MYOA/mysql5/my.ini文件下的 wait_timeout=100，interactive_timeout=100，innodb_buffer_pool_size=2048，重启所有服务
myoa/nginx/conf/nginx.conf文件下可以修改keepalive_requests 100;增加静态文件并发性能
用#注释下面几项设置，避免文件句柄过高和内存泄漏
#open_file_cache max=10000 inactive=3600s;
#open_file_cache_valid 300s;
#open_file_cache_min_uses 1;
#open_file_cache_errors on;
通达曾圆圆 发表于 2018-5-2 18:27
您好，若您的服务器是64位的话可以尝试替换64位数据库服务文件（注意：替换之前原文件做好备份！！）
修改M ...
按这个试过，mysql的占用还是不会释放。 灰常牛掰滴锅锅 发表于 2018-5-3 10:36
按这个试过，mysql的占用还是不会释放。
应用中心连接的数据出错？ 灰常牛掰滴锅锅 发表于 2018-5-3 11:56
应用中心连接的数据出错？
17版的应用中心数据库正常应该是连接td_app吧，现在连接到td_oa了。
错误#1146: Table 'td_oa.app_code' doesn't exist
SQL语句: select id,label from TD_OA.app_code where find_in_set(label,'仓库分类,客户类型,省份,商品分类,科目分类')
文件：/general/reportshop/workshop/
错误#1146: Table 'td_oa.app_form' doesn't exist
SQL语句: select repid from TD_OA.app_form where find_in_set(id, '2,6,9,20,21,22,23,25,28,55,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,86,87,88,89,90,91,92,93,96,97,99,100,102,103,105,106,413,414,452,456,1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,58,59,60,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,96,97,99,100,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,132,133,134,135,136,137,138,147,148,149,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,193,194,198,201,202,203,204,205,206,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,436,437,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,677,678,679,680,681,682,683,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,890,891,892,893,894,895,896,897,') and isdeleted=0
文件：/portal/personal/count.php?OUTPUT=1&MODULE_ID_STR=info%2Cinfo%2Cworkflow%2Cnotify%2Cbook%2Cmeeting%2Cworkflow%2Cworkflow%2Cworkflow%2Cattendance%2Csms%2Cnews%2Cmytable%2Ckanban%2Csystem%2Cmenu_url%2Chttps%3A%2Chttps%3A%2Cmenu_url%2Cproject%2Cproject%2Cproject%2Creportshop%2Cmenu_url%2Cmenu_url%2Cmenu_url%2Ccrm%2Ccrm%2C
错误#1146: Table 'td_oa.app_code' doesn't exist
SQL语句: select id,label from TD_OA.app_code where find_in_set(label,'仓库分类,客户类型,省份,商品分类,科目分类')
文件：/general/reportshop/workshop/
错误#1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIX_TIMESTAMP(CURDATE()) order by writetime desc, organid, userid' at line 1
SQL语句: select distinct title, userid, writetime, memo from crscell.crs_tabledata4137 where UNIX_TIMESTAMP(if(crscell.crs_tabledata4137.col79676 is null, '', crscell.crs_tabledata4137.col79676))UNIX_TIMESTAMP(CURDATE()) order by writetime desc, organid, userid
文件：/general/management_center/cockpit/getdata.php?type=info&flag=0
错误#1146: Table 'td_oa.app_form' doesn't exist
SQL语句: select count(*) as sz from TD_OA.app_form where isdeleted=0 and excel=1 and query=0 and not find_in_set(repid, '599,600,601,602,603,604,605,606,607,608,609,610,611,612,616,617,618,619,620,621,622,623,624,625,626,627,630,644,645,771,772,773,774,775,779,780,781,782,785,787,797,798,799,800,801,802,803,804,805,806,807,808,814,')
文件：/general/appbuilder/web/appdesign/export/
错误#1146: Table 'td_app.notify' doesn't exist
SQL语句: SELECT count(NOTIFY_ID) FROM NOTIFY WHERE PUBLISH='1' AND BEGIN_DATE='1525319332' or END_DATE='0') AND NOT find_in_set('admin',READERS) AND (TO_ID='ALL_DEPT' OR find_in_set('1',TO_ID) OR find_in_set('1',PRIV_ID) OR find_in_set('admin',USER_ID))
文件：/portal/personal/count.php?OUTPUT=1&MODULE_ID_STR=info%2Cinfo%2Cworkflow%2Cnotify%2Cbook%2Cmeeting%2Cworkflow%2Cworkflow%2Cworkflow%2Cattendance%2Csms%2Cnews%2Cmytable%2Ckanban%2Csystem%2Cmenu_url%2Chttps%3A%2Chttps%3A%2Cmenu_url%2Cproject%2Cproject%2Cproject%2Creportshop%2Cmenu_url%2Cmenu_url%2Cmenu_url%2Ccrm%2Ccrm%2C
错误#1146: Table 'td_app.user_online' doesn't exist
SQL语句: select 1 from USER_ONLINE where SID='orgveh6trtoo77i2u2mf571307'
文件：/general/ipanel/user/user_count.php
错误#1146: Table 'td_app.module_priv' doesn't exist
SQL语句: SELECT UID,PRIV_ID,DEPT_ID from MODULE_PRIV where MODULE_ID='0' and UID!='1' and not find_in_set('1',PRIV_ID) and not find_in_set('admin',USER_ID) and not find_in_set('1',DEPT_ID)
文件：/inc/online.php?PARA_URL2=/general/ipanel/user/user_info.php&PARA_TARGET=_blank&PARA_ID=WINDOW&PARA_VALUE=1&SHOW_IP=1&PWD=&OP_SMS=1&_=1525319361472
错误#1146: Table 'jindie2.user_online' doesn't exist
SQL语句: select 1 from USER_ONLINE where SID='bisg98vsv4scjtjqiosqp6bmh7'
文件：/general/ipanel/user/user_count.php
错误#1146: Table 'jindie2.module_priv' doesn't exist
SQL语句: SELECT UID,PRIV_ID,DEPT_ID from MODULE_PRIV where MODULE_ID='0' and UID!='1' and not find_in_set('1',PRIV_ID) and not find_in_set('admin',USER_ID) and not find_in_set('1',DEPT_ID)
文件：/inc/online.php?PARA_URL2=/general/ipanel/user/user_info.php&PARA_TARGET=_blank&PARA_ID=WINDOW&PARA_VALUE=1&SHOW_IP=1&PWD=&OP_SMS=1&_=1525319370599
错误#1146: Table 'td_oa.app_code' doesn't exist
SQL语句: select id,label from TD_OA.app_code where find_in_set(label,'仓库分类,客户类型,省份,商品分类,科目分类')
文件：/general/reportshop/workshop/
错误#1146: Table 'td_oa.app_code' doesn't exist
SQL语句: select id,label from TD_OA.app_code where find_in_set(label,'仓库分类,客户类型,省份,商品分类,科目分类')
文件：/general/reportshop/workshop/
错误#1146: Table 'td_oa.app_form' doesn't exist
SQL语句: select count(*) as sz from TD_OA.app_form where isdeleted=0 and excel=1 and query=0 and not find_in_set(repid, '599,600,601,602,603,604,605,606,607,608,609,610,611,612,616,617,618,619,620,621,622,623,624,625,626,627,630,644,645,771,772,773,774,775,779,780,781,782,785,787,797,798,799,800,801,802,803,804,805,806,807,808,814,')
文件：/general/appbuilder/web/appdesign/export/
灰常牛掰滴锅锅 发表于 2018-5-3 11:58
17版的应用中心数据库正常应该是连接td_app吧，现在连接到td_oa了。
您好，请查看下TD_APP库下是否还存在app_code,app_form表？ 通达赵倩 发表于 2018-5-3 17:33
您好，请查看下TD_APP库下是否还存在app_code,app_form表？
存在啊！