HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


mysqld proccess over 99% on vps server

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#85443 (In Topic #17561)
Avatar

Well-settled

I've recently upgraded from 7.1.6 to 8.0.1. Even though the problem is not new, it seems like it's intensified a bit since the upgrade. My site isn't generally the fastest since it has around 6000 catalogue entries and I've been upgrading it ever since version 4, so maybe it has something to do with the actual database.

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 :lol:

(www.metal-temple.com)
Back to the top
 
Posted
Rating:
#85444
Avatar

Community saint

If opening any page is causing that problem, then the first thing that comes to mind is that maybe you are short on memory and the page file is being hammered all the time.

Do you have a Samsung Galaxy S / Galaxy S II ? If so, why not check out my ScreenFree FM Radio .
Back to the top
 
Posted
Rating:
#85445
Avatar

I would do a default install of v8, and look what indexes exist on the catalogue and translate tables. Then make sure you have those same indexes on your database. We haven't always propagated these through version upgrades.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85446
Avatar

Also, if you can catch it happened and log into MySQL as root, "SHOW FULL PROCESSLIST" shows what queries are running. Might be worth sharing here.

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.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85449
Avatar

Well-settled

Hey guys, here's a "show processlist;" from three commands that were done over 6 seconds in total.

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     
Back to the top
 
Posted
Rating:
#85450
Avatar

Ok so ocp4_seo_meta comes up a lot in a join. Joins need an index on the join fields to be efficient, so I'd check what that has against what a new v8 has.

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.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85451
Avatar

Well-settled

Thanks for your help Chris, I'll try to get a new ocportal installation up and running and do the cross-checking, will get back with the results and any further questions, since I have no clue about working with indexes (but I'm a very fast learner lol).

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. :)
Back to the top
 
Posted
Rating:
#85453
Avatar

Yeah I remember our PT. Quick summary about indexes…

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.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85460
Avatar

Well-settled

Thanks for the explanation Chris!

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:

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 12976 A    
alt_key BTREE No No meta_for_type 11 A    
meta_for_id 12976 A  
ftjoin_keywords BTREE No No meta_keywords 12976 A

Space usage
Type Usage
Data 439.1 KiB
Index 387.0 KiB
Total 826.1 KiB
Row Statistics
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 12,976
Row length ø 34
Row size ø 65 B
Next Autoindex 17,614
Creation Mar 03, 2011 at 12:38 AM
Last update May 14, 2012 at 08:09 PM
Last check Oct 06, 2011 at 10:36 PM


Last edit: by Palanthas
Back to the top
 
Posted
Rating:
#85773
Avatar

Well-settled

ok, back to my case :)

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\n

\n\n{| 48.5%:48.5% wide floats\n|

\n|

\n\n

"Recommend ocportal"

Know someone who needs a website? Recommend ocPortal and they\'ll be sent a link to your own site too.
\n\n|}\n', 'return unserialize("a:6:{i:0;a:16:{i:0;a:5:{i:0;s:20:\"tcpfunc_SCRE
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 \\\":ocp=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)
Back to the top
 
Posted
Rating:
#85774
Avatar

Well-settled

On the bright side, after running a full optimization, the server load has considerably gone down :)
Back to the top
 
Posted
Rating:
#85775
Avatar

If you don't care about Comcode page ownership, empty the cached_comcode_pages and comcode_pages tables. That should cause the pages to be reassigned to the next admin user.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85776
Avatar

Well-settled

Will do so Chris, thanks :)

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>
Back to the top
 
Posted
Rating:
#85777
Avatar

Well-settled

and another one:

| 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>
Back to the top
 
Posted
Rating:
#85779
Avatar

This doesn't actually make sense, so something else must be going on here…

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.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85781
Avatar

Well-settled

Hmmm… disk space is at 79% and memory used is usually around 60-70%.

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. :)
Back to the top
 
Posted
Rating:
#85784
Avatar

Well-settled

Running MySQLTuner I got this:

 >>  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)
Back to the top
 
Posted
Rating:
#85785
Avatar

Well-settled

Ok, did some changes and it seems like mysqld process is sleeping even with lots of users online, Chris was right as always :)

changed these and it seems like the server got some breathing room. MySQLTuner is a great tool. :D

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
Back to the top
 
Posted
Rating:
#85788
Avatar

Well-settled

Seems like the fix was temporary, back to 99.9%…  :(
Back to the top
 
Posted
Rating:
#85800
Avatar

Well-settled

Ok, so it seems like the search function is one of the major reasons for the site dying from time to time. Doing a search, even using -say- 60 days limit and title searching, is enough to boost the usage to 99.9%. If a second user does a search at the same time, that's enough to crash the site for several minutes. So I was forced to remove ocportal's search and everything's running very smooth.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand