mysqld proccess over 99% on vps server
|
Posted
#85443
(In Topic #17561)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Well-settled |
When I pid my vps server, it reports: 28465 mysql 15 0 302m 85m 5964 S 99.9 11.1 597:14.96 mysqld It's like that most of the time, mysqld is at 99.9% cpu usage. I've got all caching enabled, it just seems like every page that opens sends a huge load to mysql. Maybe there's something I can do? Reindex the tables? Any help would be great as opening each page seems like a task that makes the server literally sweat digits  (www.metal-temple.com) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Community saint |
Do you have a Samsung Galaxy S / Galaxy S II ? If so, why not check out my ScreenFree FM Radio .
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ocStaff (admin) |
If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ocStaff (admin) |
Back in v6 or v7 (I cannot remember!) we tested 100k's of records in ocPortal and ensured it performed (we made tonnes of changes so it did). So theoretically it should be fine. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
mysql> show processlist; +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 9057 | metaltem_templar | localhost | metaltem_metaltemple | Query | 53 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9079 | metaltem_templar | localhost | metaltem_metaltemple | Query | 51 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9084 | metaltem_templar | localhost | metaltem_metaltemple | Query | 49 | Locked | SELECT r.* FROM ocp4_images r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='image' AND m.meta_for_i | | 9089 | metaltem_templar | localhost | metaltem_metaltemple | Query | 49 | Locked | SELECT main.cv_value,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed FROM oc | | 9090 | metaltem_templar | localhost | metaltem_metaltemple | Query | 49 | Locked | UPDATE ocp4_translate SET source_user=203, broken=0, text_original='DEF LEPPARD: Quality Dublin Foot | | 9091 | metaltem_templar | localhost | metaltem_metaltemple | Query | 20 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin | | 9092 | root | localhost | NULL | Query | 0 | NULL | show processlist | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 7 rows in set (0.00 sec) mysql> show processlist; +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 9057 | metaltem_templar | localhost | metaltem_metaltemple | Query | 61 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9079 | metaltem_templar | localhost | metaltem_metaltemple | Query | 59 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9084 | metaltem_templar | localhost | metaltem_metaltemple | Query | 57 | Locked | SELECT r.* FROM ocp4_images r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='image' AND m.meta_for_i | | 9089 | metaltem_templar | localhost | metaltem_metaltemple | Query | 57 | Locked | SELECT main.cv_value,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed FROM oc | | 9090 | metaltem_templar | localhost | metaltem_metaltemple | Query | 57 | Locked | UPDATE ocp4_translate SET source_user=203, broken=0, text_original='DEF LEPPARD: Quality Dublin Foot | | 9091 | metaltem_templar | localhost | metaltem_metaltemple | Query | 28 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin | | 9092 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 9093 | metaltem_templar | localhost | metaltem_metaltemple | Query | 8 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin | | 9094 | metaltem_templar | localhost | metaltem_metaltemple | Query | 5 | Locked | SELECT f.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 9 rows in set (0.00 sec) mysql> show processlist; +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 9057 | metaltem_templar | localhost | metaltem_metaltemple | Query | 66 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9079 | metaltem_templar | localhost | metaltem_metaltemple | Query | 64 | Sending data | SELECT COUNT(DISTINCT r.id) FROM ocp4_news r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='news' AN | | 9084 | metaltem_templar | localhost | metaltem_metaltemple | Query | 62 | Locked | SELECT r.* FROM ocp4_images r LEFT JOIN ocp4_seo_meta m on (m.meta_for_type='image' AND m.meta_for_i | | 9089 | metaltem_templar | localhost | metaltem_metaltemple | Query | 62 | Locked | SELECT main.cv_value,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed FROM oc | | 9090 | metaltem_templar | localhost | metaltem_metaltemple | Query | 62 | Locked | UPDATE ocp4_translate SET source_user=203, broken=0, text_original='DEF LEPPARD: Quality Dublin Foot | | 9091 | metaltem_templar | localhost | metaltem_metaltemple | Query | 33 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin | | 9092 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 9093 | metaltem_templar | localhost | metaltem_metaltemple | Query | 13 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin | | 9094 | metaltem_templar | localhost | metaltem_metaltemple | Query | 10 | Locked | SELECT f.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original | +------+------------------+-----------+----------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 9 rows in set (0.00 sec) Also, I went into phpmyadmin and here are the indexes from: ocp4_catalogues: PRIMARY BTREE Yes No c_name 5 A ocp4_translate: Indexes: Keyname Type Unique Packed Column Cardinality Collation Null Comment PRIMARY BTREE Yes No id 78000 A language 78000 A equiv_lang BTREE No No text_original (4) 6500 A decache BTREE No No text_parsed (2) 2 A importance_level BTREE No No importance_level 4 A search FULLTEXT No No text_original 1 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ocStaff (admin) |
Regarding other slow queries, often they get blocked by the real slow-downs, so if it really is ocp4_seo_meta then the rest will fade away. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
Back in 4 to 6 migration you gave me some indices.php script that created some indexes but I guess even more things have changed since then. 
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ocStaff (admin) |
Let's imagine you have a million rows in one table, and you need to pull out a particular row. If you don't want to look through 0.5 million rows on average to find it, you need an index. A join (when two tables are combined for some result – in this case, a content table and the generic SEO table) - it needs to do those lookups for every single row in the first table in a query. So if you have 0.5 million rows in each table, you'll have 250 billion comparisons. Obviously most people don't have that much data, and you don't, but it illustrates the problem. Keys have tables created automatically, but I don't think the seo_meta table is being join'd with its keys. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
I'll try to setup a new ocportal installation tommorow but if anyone has a relatively fresh installation and can paste a comparison of ocp<version>_seo_meta … :) Here's my current ocp4_seo_meta Indexes and stats: Indexes:
Last edit: by Palanthas
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
did a fresh installation and compared seo and translate table indexes, they're all the same. ran an optimization on all tables and things seemed to go a bit better. Then I tried to log in as admin and decided to do a SHOW FULL PROCESSLIST; and I got the following huge thing and site crashed. | | 685 | metaltem_templar | localhost | metaltem_metaltemple | Query | 15 | Locked | INSERT INTO ocp4_translate (source_user, broken, importance_level, text_original, text_parsed, language) VALUES (2, 0, 1, ' Admin Zone\n\nSorry, Palanthas does not have access to use the 'block' Comcode tag (usage blocked). \n\n{| 48.5%:48.5% wide floats\n| Sorry, Palanthas does not have access to use the 'block' Comcode tag (usage blocked). \n| Sorry, Palanthas does not have access to use the 'block' Comcode tag (usage blocked). \n\n "Recommend ocportal"
Know someone who needs a website? Recommend ocPortal and they\'ll be sent a link to your own site too.
EN_TITLE\";i:1;a:5:{s:2:\"ID\";s:1:\"0\";s:5:\"TITLE\";O:12:\ "ocp_tempcode\":6:{s:18:\"code_to_preexecute\";s:76:\"\$TPL_F UNCS[\'string_attach_4fb784edc469a6.24399610\']=\"echo \\\"Admin Zone\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edc469a6.24399610\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{}s :11:\"last_attach\";s:0:\"\";s:9:\"pure_lang\";N;s:8:\"codena me\";s:7:\"(mixed)\";}s:8:\"HELP_URL\";s:0:\"\";s:9:\"HELP_TE RM\";s:0:\"\";s:5:\"_GUID\";s:41:\"comcode_text_to_tempcode/_ do_tags_comcode\";}i:2;i:1;i:3;s:0:\"\";i:4;N;}i:1;a:5:{i:0;s :34:\"do_runtime_4fb784edc4d305.53309684\";i:1;a:1:{i:0;s:26: \"block=main_staff_checklist\";}i:2;i:0;i:3;s:5:\"BLOCK\";i:4 ;s:12:\"SCREEN_TITLE\";}i:2;a:5:{i:0;s:37:\"string_attach_4fb 784edc4da20.94147150\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0 :\"\";}i:3;a:5:{i:0;s:37:\"string_attach_4fb784edc4dc00.16320 948\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}i:4;a:5:{i :0;s:37:\"tcpfunc_COMCODE_FAKE_TABLE_WRAP_START\";i:1;a:0:{}i :2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}i:5;a:5:{i:0;s:37:\"tcpfunc _COMCODE_FAKE_TABLE_WIDE_START\";i:1;a:5:{s:5:\"_GUID\";s:32: \"ced8c3a142f74296a464b085ba6891c9\";s:5:\"WIDTH\";s:5:\"48.5 %\";s:5:\"FLOAT\";s:4:\"left\";s:7:\"PADDING\";s:0:\"\";s:14: \"PADDING_AMOUNT\";s:4:\"3.00\";}i:2;i:1;i:3;s:0:\"\";i:4;s:2 9:\"COMCODE_FAKE_TABLE_WRAP_START\";}i:6;a:5:{i:0;s:34:\"do_r untime_4fb784edcc7263.38420849\";i:1;a:3:{i:0;s:81:\"param=ocPortal.com: News" ;i:1;s:19:\"title=ocPortal news\";i:2;s:14:\"block=side_rss\";}i:2;i:0;i:3;s:5:\"BLOCK\ ";i:4;s:29:\"COMCODE_FAKE_TABLE_WIDE_START\";}i:7;a:5:{i:0;s: 30:\"tcpfunc_COMCODE_FAKE_TABLE_END\";i:1;a:0:{}i:2;i:1;i:3;s :0:\"\";i:4;s:7:\"(mixed)\";}i:8;a:5:{i:0;s:38:\"tcpfunc_COMC ODE_FAKE_TABLE_WIDE2_START\";i:1;a:5:{s:5:\"_GUID\";s:32:\"9b ac42a1b62c5c9a2f758639fcb3bb2f\";s:5:\"WIDTH\";s:5:\"48.5%\"; s:14:\"PADDING_AMOUNT\";s:4:\"3.00\";s:5:\"FLOAT\";s:4:\"left \";s:7:\"PADDING\";s:5:\"-left\";}i:2;i:1;i:3;s:0:\"\";i:4;s: 22:\"COMCODE_FAKE_TABLE_END\";}i:9;a:5:{i:0;s:34:\"do_runtime _4fb784edd0d3d7.37010266\";i:1;a:1:{i:0;s:28:\"block=main_sta ff_new_version\";}i:2;i:0;i:3;s:5:\"BLOCK\";i:4;s:30:\"COMCOD E_FAKE_TABLE_WIDE2_START\";}i:10;a:5:{i:0;s:37:\"string_attac h_4fb784edd0dd35.30950777\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i: 4;s:30:\"COMCODE_FAKE_TABLE_WIDE2_START\";}i:11;a:5:{i:0;s:37 :\"string_attach_4fb784edd0dfe7.53387820\";i:1;a:0:{}i:2;i:1; i:3;s:0:\"\";i:4;s:30:\"COMCODE_FAKE_TABLE_WIDE2_START\";}i:1 2;a:5:{i:0;s:34:\"do_runtime_4fb784edd3d3a1.65148971\";i:1;a: 7:{i:0;O:12:\"ocp_tempcode\":6:{s:18:\"code_to_preexecute\";s :84:\"\$TPL_FUNCS[\'string_attach_4fb784edd3c4f1.98088327\']= \"echo \\\"Recommend ocPortal\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:3 7:\"string_attach_4fb784edd3c4f1.98088327\";i:1;a:0:{}i:2;i:1 ;i:3;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0 :{}s:11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\ ";s:10:\":container\";}i:1;O:12:\"ocp_tempcode\":6:{s:18:\"co de_to_preexecute\";s:70:\"\$TPL_FUNCS[\'string_attach_4fb784e dd3b201.43184751\']=\"echo \\\"100%\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:3 7:\"string_attach_4fb784edd3b201.43184751\";i:1;a:0:{}i:2;i:1 ;i:3;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0 :{}s:11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\ ";s:10:\":container\";}i:2;O:12:\"ocp_tempcode\":6:{s:18:\"co de_to_preexecute\";s:66:\"\$TPL_FUNCS[\'string_attach_4fb784e dd3c867.03299185\']=\"echo \\\"\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edd3c867.03299185\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{}s :11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s: 10:\":container\";}i:3;O:12:\"ocp_tempcode\":6:{s:18:\"code_t o_preexecute\";s:66:\"\$TPL_FUNCS[\'string_attach_4fb784edd3c b13.02429246\']=\"echo \\\"\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edd3cb13.02429246\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{}s :11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s: 10:\":container\";}i:4;O:12:\"ocp_tempcode\":6:{s:18:\"code_t o_preexecute\";s:66:\"\$TPL_FUNCS[\'string_attach_4fb784edd3c da9.31643893\']=\"echo \\\"\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edd3cda9.31643893\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{}s :11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s: 10:\":container\";}i:5;O:12:\"ocp_tempcode\":6:{s:18:\"code_t o_preexecute\";s:66:\"\$TPL_FUNCS[\'string_attach_4fb784edd3d 011.60086182\']=\"echo \\\"\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edd3d011.60086182\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{}s :11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s: 10:\":container\";}i:6;O:12:\"ocp_tempcode\":6:{s:18:\"code_t o_preexecute\";s:673:\"\$TPL_FUNCS[\'string_attach_4fb784edd1 bf02.36056639\']=\"echo \\\"Know someone who needs a website? \\\";\";\nif ((\$result=@include(\'/home/metaltem/public_html/themes/defa ult/templates_cached/EN/HYPERLINK.tpl.tcp\'))===false) { \$tmp=do_template(\'HYPERLINK\',NULL,\'EN\',false,\'\',\'.tp l\',\'templates\'); clearstatcache(); if (mt_rand(0,100)==1 || !is_file(\'/home/metaltem/public_html/themes/default/templat es_cached/EN/HYPERLINK.tpl.tcp\')) { \$GLOBALS[\'CACHE_TEMPLATES\']=false; } eval(\$tmp->code_to_preexecute); unset(\$tmp); }\n else { eval(\$result[5]); unset(\$result); }\$TPL_FUNCS[\'string_attach_4fb784edd3a836.35684231\']=\"ec ho \\\" and they'll be sent a link to your own site too.\\\";\";\n\";s:9:\"seq_parts\";a:3:{i:0;a:5:{i:0;s:37:\" string_attach_4fb784edd1bf02.36056639\";i:1;a:0:{}i:2;i:1;i:3 ;s:0:\"\";i:4;s:0:\"\";}i:1;a:5:{i:0;s:17:\"tcpfunc_HYPERLINK \";i:1;a:9:{s:7:\"OVERLAY\";N;s:3:\"REL\";N;s:9:\"POST_DATA\" ;N;s:9:\"ACCESSKEY\";N;s:10:\"NEW_WINDOW\";s:1:\"0\";s:5:\"TI TLE\";s:0:\"\";s:3:\"URL\";O:12:\"ocp_tempcode\":6:{s:18:\"co de_to_preexecute\";s:105:\"\$TPL_FUNCS[\'do_runtime_4fb784edd 22234.76419620\']=\"echo ecv(\\\$cl,array(),0,\\\"PAGE_LINK\\\",\\\$parameters);\";\n \";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:34:\"do_runtime_4fb7 84edd22234.76419620\";i:1;a:4:{i:0;O:12:\"ocp_tempcode\":6:{s :18:\"code_to_preexecute\";s:219:\"\$TPL_FUNCS[\'string_attac h_4fb784edd21739.31442672\']=\"echo \\\":recommend\\\";\";\n\$TPL_FUNCS[\'string_attach_4fb784ed d21b33.03722919\']=\"echo \\\":misc\\\";\";\n\$TPL_FUNCS[\'string_attach_4fb784edd21eb 0.81750573\']=\"echo \\\"  cp=1\\\";\";\n\";s:9:\"seq_parts\";a:3:{i:0;a:5:{i:0;s:37:\"string_attach_4fb784edd21739.31442672\";i:1;a:0:{}i:2;i: 1;i:3;s:0:\"\";i:4;s:0:\"\";}i:1;a:5:{i:0;s:37:\"string_attac h_4fb784edd21b33.03722919\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i: 4;s:0:\"\";}i:2;a:5:{i:0;s:37:\"string_attach_4fb784edd21eb0. 81750573\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}s:19 :\"preprocessable_bits\";a:0:{}s:11:\"last_attach\";s:0:\"\"; s:9:\"pure_lang\";N;s:8:\"codename\";s:7:\"(mixed)\";}i:1;s:1 :\"0\";i:2;s:1:\"0\";i:3;s:1:\"0\";}i:2;i:0;i:3;s:9:\"PAGE_LI NK\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:1:{i:0;a:4 :{i:0;a:0:{}i:1;i:0;i:2;s:9:\"PAGE_LINK\";i:3;a:4:{i:0;r:212; i:1;s:1:\"0\";i:2;s:1:\"0\";i:3;s:1:\"0\";}}}s:11:\"last_atta ch\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s:10:\":container \";}s:7:\"CAPTION\";O:12:\"ocp_tempcode\":6:{s:18:\"code_to_p reexecute\";s:84:\"\$TPL_FUNCS[\'string_attach_4fb784edd20942 .26387770\']=\"echo \\\"Recommend ocPortal\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:3 7:\"string_attach_4fb784edd20942.26387770\";i:1;a:0:{}i:2;i:1 ;i:3;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0 :{}s:11:\"last_attach\";s:0:\"\";s:9:\"pure_lang\";N;s:8:\"co dename\";s:7:\"(mixed)\";}s:5:\"_GUID\";s:26:\"_do_tags_comco de/hyperlink\";}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}i:2;a:5:{i :0;s:37:\"string_attach_4fb784edd3a836.35684231\";i:1;a:0:{}i :2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits \";a:2:{i:0;a:4:{i:0;a:0:{}i:1;i:0;i:2;s:3:\"SET\";i:3;a:2:{i :0;O:12:\"ocp_tempcode\":6:{s:18:\"code_to_preexecute\";s:69: \"\$TPL_FUNCS[\'tcpfunc_4fb78286cfbdf0.28076276\']=\" echo \\\"lightbox\\\";\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0 ;s:31:\"tcpfunc_4fb78286cfbdf0.28076276\";i:1;a:0:{}i:2;i:1;i :3;s:0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:0:{ }s:11:\"last_attach\";N;s:9:\"pure_lang\";N;s:8:\"codename\"; s:10:\":container\";}i:1;O:12:\"ocp_tempcode\":6:{s:18:\"code _to_preexecute\";s:318:\"\$TPL_FUNCS[\'tcpfunc_4fb78286cfc404 .10479758\']=\"eval(\\\$RESET_VAR_CODE); echo ecv(\\\$cl,array(),0,\\\"EQ\\\",array(ecv(\\\$cl,array(),0,\ \\"LCASE\\\",array(ecv(\\\$cl,array(),0,\\\"SUBSTR\\\",array( output_tempcode_parameter( isset (\\\$bound_URL)?\\\$bound_URL:NULL,\\\"URL\\\",\\\"HYPERLINK \\\"),\\\"-4\\\")))),\\\"jpeg\\\",\\\".jpg\\\",\\\".gif\\\",\ \\".png\\\"));\";\n\";s:9:\"seq_parts\";a:1:{i:0;a:5:{i:0;s:3 1:\"tcpfunc_4fb78286cfc404.10479758\";i:1;R:199;i:2;i:1;i:3;s :0:\"\";i:4;s:0:\"\";}}s:19:\"preprocessable_bits\";a:1:{i:0; a:4:{i:0;a:0:{}i:1;i:0;i:2;s:9:\"PAGE_LINK\";i:3;a:4:{i:0;r:2 12;i:1;s:1:\"0\";i:2;s:1:\"0\";i:3;s:1:\"0\";}}}s:11:\"last_a ttach\";N;s:9:\"pure_lang\";N;s:8:\"codename\";s:0:\"\";}}}i: 1;a:4:{i:0;a:0:{}i:1;i:0;i:2;s:9:\"PAGE_LINK\";i:3;a:4:{i:0;r :212;i:1;s:1:\"0\";i:2;s:1:\"0\";i:3;s:1:\"0\";}}}s:11:\"last _attach\";s:0:\"\";s:9:\"pure_lang\";N;s:8:\"codename\";s:7:\ "(mixed)\";}}i:2;i:4;i:3;s:3:\"BOX\";i:4;s:30:\"COMCODE_FAKE_ TABLE_WIDE2_START\";}i:13;a:5:{i:0;s:30:\"tcpfunc_COMCODE_FAK E_TABLE_END\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:7:\"(mixed )\";}i:14;a:5:{i:0;s:35:\"tcpfunc_COMCODE_FAKE_TABLE_WRAP_END \";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:22:\"COMCODE_FAKE_TAB LE_END\";}i:15;a:5:{i:0;s:37:\"string_attach_4fb784edd5e8f5.3 2625702\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a :3:{i:0;a:4:{i:0;a:0:{}i:1;i:0;i:2;s:5:\"BLOCK\";i:3;a:1:{i:0 ;s:26:\"block=main_staff_checklist\";}}i:1;a:4:{i:0;a:0:{}i:1 ;i:0;i:2;s:5:\"BLOCK\";i:3;a:3:{i:0;s:81:\"param=ocPortal.com: News";i:1;s:19: \"title=ocPortal news\";i:2;s:14:\"block=side_rss\";}}i:2;a:4:{i:0;a:0:{}i:1; i:0;i:2;s:5:\"BLOCK\";i:3;a:1:{i:0;s:28:\"block=main_staff_ne w_version\";}}}i:2;s:7:\"(mixed)\";i:3;s:0:\"\";i:4;N;i:5;s:7 637:\"if ((\$result=@include(\'/home/metaltem/public_html/themes/defa ult/templates_cached/EN/SCREEN_TITLE.tpl.tcp\'))===false) { \$tmp=do_template(\'SCREEN_TITLE\',NULL,\'EN\',false,\'\',\' .tpl\',\'templates\'); clearstatcache(); if (mt_rand(0,100)==1 || !is_file(\'/home/metaltem/public_html/themes/default/templat es_cached/EN/SCREEN_TITLE.tpl.tcp\')) { \$GLOBALS[\'CACHE_TEMPLATES\']=false; } eval(\$tmp->code_to_preexecute); unset(\$tmp); }\n else { eval(\$result[5]); unset(\$result); }\$TPL_FUNCS[\'do_runtime_4fb784edc4d305.53309684\']=\"echo ecv(\\\$cl,array(),0,\\\"BLOCK\\\",\\\$parameters);\";\n\$TP L_FUNCS[\'string_attach_4fb784edc4da20.94147150\']=\"echo \\\"\\\\n\\\";\";\n\$TPL_FUNCS[\'string_attach_4fb784edc4dc0 0.16320948\']=\"echo \\\"<br />\\\";\";\n\$TPL_FUNCS[\'tcpfunc_COMCODE_FAKE_TABLE_WRAP_ST ART\']=\" echo \\\"<div class=\\\\\\\"float_surrounder comcode_fake_table\\\\\\\">\\\";\";\n\$TPL_FUNCS[\'tcpfunc_C OMCODE_FAKE_TABLE_WIDE_START\']=\"eval(\\\$FULL_RESET_VAR_COD E); echo \\\"<div\\\",\\n (isset(\\\$bound_CLASS)?(\\\" class=\\\\\\\"\\\".( isset (\\\$bound_CLASS)?(((isset(\\\$bound_CLASS->preprocessable_b its)) && (\\\$bound_CLASS->pure_lang))?output_tempcode_parameter( isset (\\\$bound_CLASS)?\\\$bound_CLASS:NULL,\\\"CLASS\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\"):str_replace(\\\$GLOBALS[\'HTM L_ESCAPE_1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],output_te mpcode_parameter( isset (\\\$bound_CLASS)?\\\$bound_CLASS:NULL,\\\"CLASS\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\"))):attach_message(do_lang_temp code(\'MISSING_TEMPLATE_PARAMETER\',\\\"CLASS\\\",\\\"COMCODE _FAKE_TABLE_WIDE_START\\\"),\\\"warn\\\")).\\\"\\\\\\\"\\\"): \'\'),\\n (isset(\\\$bound_ID)?(\\\" id=\\\\\\\"\\\".( isset (\\\$bound_ID)?(((isset(\\\$bound_ID->preprocessable_bits)) && (\\\$bound_ID->pure_lang))?output_tempcode_parameter( isset (\\\$bound_ID)?\\\$bound_ID:NULL,\\\"ID\\\",\\\"COMCODE_FAKE _TABLE_WIDE_START\\\"):str_replace(\\\$GLOBALS[\'HTML_ESCAPE_ 1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],output_tempcode_pa rameter( isset (\\\$bound_ID)?\\\$bound_ID:NULL,\\\"ID\\\",\\\"COMCODE_FAKE _TABLE_WIDE_START\\\"))):attach_message(do_lang_tempcode(\'MI SSING_TEMPLATE_PARAMETER\',\\\"ID\\\",\\\"COMCODE_FAKE_TABLE_ WIDE_START\\\"),\\\"warn\\\")).\\\"\\\\\\\"\\\"):\'\'),\\n ((ecv(\\\$cl,array(),0,\\\"NOT\\\",array(ecv(\\\$cl,arra y(),0,\\\"MOBILE\\\",array()))).\\\"\\\"==\\\"1\\\")?(\\\" style=\\\\\\\"\\\".((output_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE_START\\\").\\\"\\\"!=\'\')?(\\\"ma rgin\\\".( isset (\\\$bound_PADDING)?(((isset(\\\$bound_PADDING->preprocessab le_bits)) && (\\\$bound_PADDING->pure_lang))?output_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE_START\\\"):str_replace(\\\$GLOBALS [\'HTML_ESCAPE_1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],out put_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE_START\\\"))):attach_message(do_lan g_tempcode(\'MISSING_TEMPLATE_PARAMETER\',\\\"PADDING\\\",\\\ "COMCODE_FAKE_TABLE_WIDE_START\\\"),\\\"warn\\\")).\\\": \\\".( isset (\\\$bound_PADDING_AMOUNT)?(((isset(\\\$bound_PADDING_AMOUNT ->preprocessable_bits)) && (\\\$bound_PADDING_AMOUNT->pure_lang))?output_tempcode_param eter( isset (\\\$bound_PADDING_AMOUNT)?\\\$bound_PADDING_AMOUNT:NULL,\\\ "PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE_START\\\"):st r_replace(\\\$GLOBALS[\'HTML_ESCAPE_1_STRREP\'],\\\$GLOBALS[\ 'HTML_ESCAPE_2\'],output_tempcode_parameter( isset (\\\$bound_PADDING_AMOUNT)?\\\$bound_PADDING_AMOUNT:NULL,\\\ "PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE_START\\\"))): attach_message(do_lang_tempcode(\'MISSING_TEMPLATE_PARAMETER\ ',\\\"PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE_START\\\ "),\\\"warn\\\")).\\\"%; \\\"):\'\').\\\"float: \\\".( isset (\\\$bound_FLOAT)?(((isset(\\\$bound_FLOAT->preprocessable_b its)) && (\\\$bound_FLOAT->pure_lang))?output_tempcode_parameter( isset (\\\$bound_FLOAT)?\\\$bound_FLOAT:NULL,\\\"FLOAT\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\"):str_replace(\\\$GLOBALS[\'HTM L_ESCAPE_1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],output_te mpcode_parameter( isset (\\\$bound_FLOAT)?\\\$bound_FLOAT:NULL,\\\"FLOAT\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\"))):attach_message(do_lang_temp code(\'MISSING_TEMPLATE_PARAMETER\',\\\"FLOAT\\\",\\\"COMCODE _FAKE_TABLE_WIDE_START\\\"),\\\"warn\\\")).((output_tempcode_ parameter( isset (\\\$bound_WIDTH)?\\\$bound_WIDTH:NULL,\\\"WIDTH\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\").\\\"\\\"!=\'\')?(\\\"; width: \\\".( isset (\\\$bound_WIDTH)?apply_tempcode_escaping_inline(array(1,13) ,output_tempcode_parameter( isset (\\\$bound_WIDTH)?\\\$bound_WIDTH:NULL,\\\"WIDTH\\\",\\\"COM CODE_FAKE_TABLE_WIDE_START\\\")):attach_message(do_lang_tempc ode(\'MISSING_TEMPLATE_PARAMETER\',\\\"WIDTH\\\",\\\"COMCODE_ FAKE_TABLE_WIDE_START\\\"),\\\"warn\\\"))):\'\').\\\"\\\\\\\" \\\"):\'\'),\\n \\\">\\\";\";\n\$TPL_FUNCS[\'do_runtime_4fb784edcc726 3.38420849\']=\"echo ecv(\\\$cl,array(),0,\\\"BLOCK\\\",\\\$parameters);\";\n\$TP L_FUNCS[\'tcpfunc_COMCODE_FAKE_TABLE_END\']=\" echo \\\"</div>\\\";\";\n\$TPL_FUNCS[\'tcpfunc_COMCODE_FAKE_TABLE _WIDE2_START\']=\"eval(\\\$FULL_RESET_VAR_CODE); echo \\\"<div\\\",\\n ((ecv(\\\$cl,array(),0,\\\"NOT\\\",array(ecv(\\\$cl,ar ray(),0,\\\"MOBILE\\\",array()))).\\\"\\\"==\\\"1\\\")?(\\\" style=\\\\\\\"\\\".((output_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE2_START\\\").\\\"\\\"!=\'\')?(\\\"m argin\\\".( isset (\\\$bound_PADDING)?(((isset(\\\$bound_PADDING->preprocessab le_bits)) && (\\\$bound_PADDING->pure_lang))?output_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE2_START\\\"):str_replace(\\\$GLOBAL S[\'HTML_ESCAPE_1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],ou tput_tempcode_parameter( isset (\\\$bound_PADDING)?\\\$bound_PADDING:NULL,\\\"PADDING\\\",\ \\"COMCODE_FAKE_TABLE_WIDE2_START\\\"))):attach_message(do_la ng_tempcode(\'MISSING_TEMPLATE_PARAMETER\',\\\"PADDING\\\",\\ \"COMCODE_FAKE_TABLE_WIDE2_START\\\"),\\\"warn\\\")).\\\": \\\".( isset (\\\$bound_PADDING_AMOUNT)?(((isset(\\\$bound_PADDING_AMOUNT ->preprocessable_bits)) && (\\\$bound_PADDING_AMOUNT->pure_lang))?output_tempcode_param eter( isset (\\\$bound_PADDING_AMOUNT)?\\\$bound_PADDING_AMOUNT:NULL,\\\ "PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE2_START\\\"):s tr_replace(\\\$GLOBALS[\'HTML_ESCAPE_1_STRREP\'],\\\$GLOBALS[ \'HTML_ESCAPE_2\'],output_tempcode_parameter( isset (\\\$bound_PADDING_AMOUNT)?\\\$bound_PADDING_AMOUNT:NULL,\\\ "PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE2_START\\\"))) :attach_message(do_lang_tempcode(\'MISSING_TEMPLATE_PARAMETER \',\\\"PADDING_AMOUNT\\\",\\\"COMCODE_FAKE_TABLE_WIDE2_START\ \\"),\\\"warn\\\")).\\\"%; \\\"):\'\').\\\"float: \\\".( isset (\\\$bound_FLOAT)?(((isset(\\\$bound_FLOAT->preprocessable_b its)) && (\\\$bound_FLOAT->pure_lang))?output_tempcode_parameter( isset (\\\$bound_FLOAT)?\\\$bound_FLOAT:NULL,\\\"FLOAT\\\",\\\"COM CODE_FAKE_TABLE_WIDE2_START\\\"):str_replace(\\\$GLOBALS[\'HT ML_ESCAPE_1_STRREP\'],\\\$GLOBALS[\'HTML_ESCAPE_2\'],output_t empcode_parameter( isset (\\\$bound_FLOAT)?\\\$bound_FLOAT:NULL,\\\"FLOAT\\\",\\\"COM CODE_FAKE_TABLE_WIDE2_START\\\"))):attach_message(do_lang_tem pcode(\'MISSING_TEMPLATE_PARAMETER\',\\\"FLOAT\\\",\\\"COMCOD E_FAKE_TABLE_WIDE2_START\\\"),\\\"warn\\\")).((output_tempcod e_parameter( isset (\\\$bound_WIDTH)?\\\$bound_WIDTH:NULL,\\\"WIDTH\\\",\\\"COM CODE_FAKE_TABLE_WIDE2_START\\\").\\\"\\\"!=\'\')?(\\\"; width: \\\".( isset (\\\$bound_WIDTH)?apply_tempcode_escaping_inline(array(1,13) ,output_tempcode_parameter( isset (\\\$bound_WIDTH)?\\\$bound_WIDTH:NULL,\\\"WIDTH\\\",\\\"COM CODE_FAKE_TABLE_WIDE2_START\\\")):attach_message(do_lang_temp code(\'MISSING_TEMPLATE_PARAMETER\',\\\"WIDTH\\\",\\\"COMCODE _FAKE_TABLE_WIDE2_START\\\"),\\\"warn\\\"))):\'\').\\\"\\\\\\ \"\\\"):\'\'),\\n \\\">\\\";\";\n\$TPL_FUNCS[\'do_runtime_4fb784edd0d3d7.370 10266\']=\"echo ecv(\\\$cl,array(),0,\\\"BLOCK\\\",\\\$parameters);\";\n\$TP L_FUNCS[\'string_attach_4fb784edd0dd35.30950777\']=\"echo \\\"\\\\n\\\";\";\n\$TPL_FUNCS[\'string_attach_4fb784edd0dfe 7.53387820\']=\"echo \\\"<br />\\\";\";\n\$TPL_FUNCS[\'do_runtime_4fb784edd3d3a1.65148971 \']=\"echo ecv(\\\$cl,array(),4,\\\"BOX\\\",\\\$parameters);\";\n\$TPL_ FUNCS[\'tcpfunc_COMCODE_FAKE_TABLE_WRAP_END\']=\" echo \\\"</div>\\\";\";\n\$TPL_FUNCS[\'string_attach_4fb784edd5e8 f5.32625702\']=\"echo \\\"<br />\\\";\";\n\";}");\n', 'EN') | | 691 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | +—–+——————+———–+———————-+———+——+————– +—————————————————————————————————– <around 50 rows of dashes> ——————————————————————————————————-+ 3 rows in set (0.00 sec) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ocStaff (admin) |
If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
mysqld is slowly getting back its 99%, another show processlist follows. | | 1786 | metaltem_templar | localhost | metaltem_metaltemple | Query | 456 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone _title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_heade r_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1788 | metaltem_templar | localhost | metaltem_metaltemple | Query | 432 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__t ext_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_orig inal,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_trans late t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t 1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0 ,50 | | 1789 | metaltem_templar | localhost | metaltem_metaltemple | Query | 421 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__t ext_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_orig inal,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_trans late t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t 1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0 ,50 | | 1792 | metaltem_templar | localhost | metaltem_metaltemple | Query | 414 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone _title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_heade r_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1793 | metaltem_templar | localhost | metaltem_metaltemple | Query | 397 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1 .id=main.cc_title AND t1.language='EN' WHERE (main.id=40) LIMIT 1 | | 1794 | metaltem_templar | localhost | metaltem_metaltemple | Query | 381 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__t ext_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_orig inal,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_trans late t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t 1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0 ,50 | | 1795 | metaltem_templar | localhost | metaltem_metaltemple | Query | 377 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1 .id=main.cc_title AND t1.language='EN' WHERE (main.id=49) LIMIT 1 | | 1796 | metaltem_templar | localhost | metaltem_metaltemple | Query | 373 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone _title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_heade r_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1797 | metaltem_templar | localhost | metaltem_metaltemple | Query | 368 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1 .id=main.cc_title AND t1.language='EN' WHERE (main.id=38) LIMIT 1 | | 1799 | metaltem_templar | localhost | metaltem_metaltemple | Query | 357 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1 .id=main.cc_title AND t1.language='EN' WHERE (main.id=44) LIMIT 1 | | 1800 | metaltem_templar | localhost | metaltem_metaltemple | Query | 345 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1 .id=main.cc_title AND t1.language='EN' WHERE (main.id=35) LIMIT 1 | | 1801 | metaltem_templar | localhost | metaltem_metaltemple | Query | 343 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_pa rsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.l anguage='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.langu age='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WH ERE (main.id=1868) LIMIT 1 | | 1802 | metaltem_templar | localhost | metaltem_metaltemple | Query | 332 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone _title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_heade r_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1803 | metaltem_templar | localhost | metaltem_metaltemple | Query | 330 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_f_members main LEFT JOIN ocp4_translate t0 ON t0.id=main. m_signature AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.m_pt_ rules_text AND t1.language='EN' WHERE (main.id=600) LIMIT 1 | | 1804 | metaltem_templar | localhost | metaltem_metaltemple | Query | 305 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__t ext_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_orig inal,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_trans late t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t 1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0 ,50 | | 1805 | metaltem_templar | localhost | metaltem_metaltemple | Query | 290 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone _title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_heade r_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1806 | metaltem_templar | localhost | metaltem_metaltemple | Query | 279 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parse d AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1_ _text_parsed FROM ocp4_f_members main LEFT JOIN ocp4_translate t0 ON t0.id=main. m_signature AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.m_pt_ rules_text AND t1.language='EN' WHERE (main.id=561) LIMIT 1 | | 1807 | metaltem_templar | localhost | metaltem_metaltemple | Query | 266 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__t ext_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_orig inal,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_trans late t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t 1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0 ,50 | | 1908 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | +——+——————+———–+———————-+———+——+- ————-+—————————————————————— ——————————————————————————– ——————————————————————————– ——————————————————————————– ——————————————————————————– ——————————————————————————– ——————————————————————————– ——————————————————————————– ——————————————————————————– ———————————————————————+ 101 rows in set (0.00 sec) mysql> |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
| 1733 | metaltem_templar | localhost | metaltem_metaltemple | Query | 1004 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1734 | metaltem_templar | localhost | metaltem_metaltemple | Query | 993 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1735 | metaltem_templar | localhost | metaltem_metaltemple | Query | 984 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1736 | metaltem_templar | localhost | metaltem_metaltemple | Query | 980 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=695) LIMIT 1 | | 1737 | metaltem_templar | localhost | metaltem_metaltemple | Query | 980 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1738 | metaltem_templar | localhost | metaltem_metaltemple | Query | 971 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1739 | metaltem_templar | localhost | metaltem_metaltemple | Query | 964 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1740 | metaltem_templar | localhost | metaltem_metaltemple | Query | 964 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1741 | metaltem_templar | localhost | metaltem_metaltemple | Query | 959 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1742 | metaltem_templar | localhost | metaltem_metaltemple | Query | 955 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1743 | metaltem_templar | localhost | metaltem_metaltemple | Query | 954 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1744 | metaltem_templar | localhost | metaltem_metaltemple | Query | 953 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1745 | metaltem_templar | localhost | metaltem_metaltemple | Query | 944 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=3815) LIMIT 1 | | 1746 | metaltem_templar | localhost | metaltem_metaltemple | Query | 943 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1748 | metaltem_templar | localhost | metaltem_metaltemple | Query | 940 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1749 | metaltem_templar | localhost | metaltem_metaltemple | Query | 932 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=54) LIMIT 1 | | 1750 | metaltem_templar | localhost | metaltem_metaltemple | Query | 929 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=4867) LIMIT 1 | | 1753 | metaltem_templar | localhost | metaltem_metaltemple | Query | 909 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=34) LIMIT 1 | | 1754 | metaltem_templar | localhost | metaltem_metaltemple | Query | 901 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1755 | metaltem_templar | localhost | metaltem_metaltemple | Query | 899 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1756 | metaltem_templar | localhost | metaltem_metaltemple | Query | 888 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=2547) LIMIT 1 | | 1757 | metaltem_templar | localhost | metaltem_metaltemple | Query | 879 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1758 | metaltem_templar | localhost | metaltem_metaltemple | Query | 878 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_f_members main LEFT JOIN ocp4_translate t0 ON t0.id=main.m_signature AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.m_pt_rules_text AND t1.language='EN' WHERE (main.id=575) LIMIT 1 | | 1760 | metaltem_templar | localhost | metaltem_metaltemple | Query | 865 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1761 | metaltem_templar | localhost | metaltem_metaltemple | Query | 864 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1762 | metaltem_templar | localhost | metaltem_metaltemple | Query | 860 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1763 | metaltem_templar | localhost | metaltem_metaltemple | Query | 855 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1764 | metaltem_templar | localhost | metaltem_metaltemple | Query | 851 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1765 | metaltem_templar | localhost | metaltem_metaltemple | Query | 832 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1766 | metaltem_templar | localhost | metaltem_metaltemple | Query | 827 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=2399) LIMIT 1 | | 1767 | metaltem_templar | localhost | metaltem_metaltemple | Query | 818 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1768 | metaltem_templar | localhost | metaltem_metaltemple | Query | 814 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1769 | metaltem_templar | localhost | metaltem_metaltemple | Query | 811 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1770 | metaltem_templar | localhost | metaltem_metaltemple | Query | 788 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1771 | metaltem_templar | localhost | metaltem_metaltemple | Query | 777 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1772 | metaltem_templar | localhost | metaltem_metaltemple | Query | 773 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1774 | metaltem_templar | localhost | metaltem_metaltemple | Query | 758 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=46) LIMIT 1 | | 1775 | metaltem_templar | localhost | metaltem_metaltemple | Query | 740 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1776 | metaltem_templar | localhost | metaltem_metaltemple | Query | 736 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1777 | metaltem_templar | localhost | metaltem_metaltemple | Query | 731 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1781 | metaltem_templar | localhost | metaltem_metaltemple | Query | 695 | Locked | SELECT text_original,text_parsed FROM ocp4_translate WHERE (id=1 AND language='EN') LIMIT 1 | | 1782 | metaltem_templar | localhost | metaltem_metaltemple | Query | 682 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1783 | metaltem_templar | localhost | metaltem_metaltemple | Query | 671 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=14) LIMIT 1 | | 1784 | metaltem_templar | localhost | metaltem_metaltemple | Query | 660 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1785 | metaltem_templar | localhost | metaltem_metaltemple | Query | 656 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1786 | metaltem_templar | localhost | metaltem_metaltemple | Query | 654 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1788 | metaltem_templar | localhost | metaltem_metaltemple | Query | 630 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1789 | metaltem_templar | localhost | metaltem_metaltemple | Query | 619 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1792 | metaltem_templar | localhost | metaltem_metaltemple | Query | 612 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1793 | metaltem_templar | localhost | metaltem_metaltemple | Query | 595 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=40) LIMIT 1 | | 1794 | metaltem_templar | localhost | metaltem_metaltemple | Query | 579 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1795 | metaltem_templar | localhost | metaltem_metaltemple | Query | 575 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=49) LIMIT 1 | | 1796 | metaltem_templar | localhost | metaltem_metaltemple | Query | 571 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1797 | metaltem_templar | localhost | metaltem_metaltemple | Query | 566 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=38) LIMIT 1 | | 1799 | metaltem_templar | localhost | metaltem_metaltemple | Query | 555 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=44) LIMIT 1 | | 1800 | metaltem_templar | localhost | metaltem_metaltemple | Query | 543 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_catalogue_categories main LEFT JOIN ocp4_translate t0 ON t0.id=main.cc_description AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.cc_title AND t1.language='EN' WHERE (main.id=35) LIMIT 1 | | 1801 | metaltem_templar | localhost | metaltem_metaltemple | Query | 541 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM ocp4_news main LEFT JOIN ocp4_translate t0 ON t0.id=main.news AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.news_article AND t1.language='EN' LEFT JOIN ocp4_translate t2 ON t2.id=main.title AND t2.language='EN' WHERE (main.id=1868) LIMIT 1 | | 1802 | metaltem_templar | localhost | metaltem_metaltemple | Query | 530 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1803 | metaltem_templar | localhost | metaltem_metaltemple | Query | 528 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_f_members main LEFT JOIN ocp4_translate t0 ON t0.id=main.m_signature AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.m_pt_rules_text AND t1.language='EN' WHERE (main.id=600) LIMIT 1 | | 1804 | metaltem_templar | localhost | metaltem_metaltemple | Query | 503 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1805 | metaltem_templar | localhost | metaltem_metaltemple | Query | 488 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' WHERE (main.zone_name='') LIMIT 1 | | 1806 | metaltem_templar | localhost | metaltem_metaltemple | Query | 477 | Locked | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_f_members main LEFT JOIN ocp4_translate t0 ON t0.id=main.m_signature AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.m_pt_rules_text AND t1.language='EN' WHERE (main.id=561) LIMIT 1 | | 1807 | metaltem_templar | localhost | metaltem_metaltemple | Query | 464 | Locked | SELECT main.*,zone_title AS _zone_title,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed FROM ocp4_zones main LEFT JOIN ocp4_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp4_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50 | | 1952 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | +——+——————+———–+———————-+———+——+————–+—————————————————————— ————————————————————————————————————————————————————————————— ————————————————————————————————————————————————————————————— ————————————————————————————————————————————————————————————— —————————————————————————————————————————————————————-+ 101 rows in set (0.00 sec) mysql> |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ocStaff (admin) |
Every query here is locked, which is why they're stuck. Yet every query is a SELECT query, so there are no writes going on to lock anything. I would check disk space, and other processes running on the server. If I answered something that you think should be in the documentation, please take the initiative and add it to the community documentation. We really need people to help out here and build a well-organised large support resource. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
So I'm guessing there's something wrong with my my.cnf settings? I turned use_mem_cache from 1 to 0 and db_type to mysql from mysqli. I'm checking my mysql settings now. It's a VPS server with 1 CPU and 768MB of ram. These are my current settings for my.cnf: collation_server=utf8_unicode_ci character_set_server=utf8 delayed_insert_timeout=40 interactive_timeout=10 wait_timeout=30 connect_timeout=20 thread_cache_size=64 key_buffer=16M ## 32MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=8M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=2 ## Number of CPUs x 2 myisam_sort_buffer_size=16M and the [MySQL] section from my php.ini: [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = ; Default password for mysql_connect() (doesn't apply in safe mode). ; Note that this is generally a *bad* idea to store passwords in this file. ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password") ; and reveal this password! And of course, any users with read access to this ; file will be able to reveal the password as well. mysql.default_password = ; Maximum time (in seconds) for connect timeout. -1 means no limit mysql.connect_timeout = 60 ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and ; SQL-Errors will be displayed. mysql.trace_mode = Off Since I'm not a mysql wizard, any suggestions on what to tweak would be greatly appreciated.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '–help' for additional options and output filtering ——– General Statistics ————————————————– [–] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.62-cll [OK] Operating on 64-bit architecture ——– Storage Engine Statistics ——————————————- [–] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [–] Data in MyISAM tables: 496M (Tables: 354) [–] Data in InnoDB tables: 208K (Tables: 13) [!!] Total fragmented tables: 33 ——– Security Recommendations ——————————————- [OK] All database users have passwords assigned ——– Performance Metrics ————————————————- [–] Up for: 6s (14 q [2.333 qps], 7 conn, TX: 8K, RX: 740) [–] Reads / Writes: 100% / 0% [–] Total buffers: 90.0M global + 4.2M per thread (100 max threads) [OK] Maximum possible memory usage: 515.0M (67% of installed RAM) [OK] Slow queries: 0% (0/14) [OK] Highest usage of available connections: 1% (1/100) [!!] Key buffer size / total MyISAM indexes: 24.0M/78.1M [!!] Query cache efficiency: 0.0% (0 cached / 6 selects) [OK] Query cache prunes per day: 0 [OK] Temporary tables created on disk: 0% (0 on disk / 2 total) [OK] Thread cache hit rate: 85% (1 created / 7 connections) [OK] Table cache hit rate: 53% (8 open / 15 opened) [OK] Open file limit used: 0% (16/2K) [OK] Table locks acquired immediately: 100% (18 immediate / 18 locks) [OK] InnoDB data size / buffer pool: 208.0K/8.0M ——– Recommendations —————————————————– General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Variables to adjust: key_buffer_size (> 78.1M) query_cache_limit (> 4M, or use smaller result sets) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
changed these and it seems like the server got some breathing room. MySQLTuner is a great tool.  query_cache_limit=4M thread_cache_size=128 key_buffer=24M ## 32MB for every 1GB of RAM max_allowed_packet=32M This is my current my.cnf. If anyone still has suggestions for further optimization on it and my php.ini that I posted earlier, I'm open for suggestions: [mysqld] safe-show-database tmp_table_size = 32M max_heap_table_size = 32M query_cache_limit=4M query_cache_size=16M ## 32MB for every 1GB of RAM query_cache_type=1 max_connections=100 collation_server=utf8_unicode_ci character_set_server=utf8 delayed_insert_timeout=40 interactive_timeout=10 wait_timeout=30 connect_timeout=20 thread_cache_size=128 key_buffer=24M ## 32MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=32M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=2 ## Number of CPUs x 2 myisam_sort_buffer_size=16M |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Posted
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Well-settled |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 guests and 0 members have just viewed this: None
Control functions: