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.


Bailing Out - max_user_connections exceeded

Login / Search

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

Community saint

Hi,

We have been live with vwgolfmk1.org.uk on OCP for a week now and have been experiencing a recurring problem.

The first you know about it is when OCP reports a bailing out message saying that max_user_connections have been exceeded. I know that this is a mysql setting.

I then went to look at the max_used_connections reported by mysql and it reports 27. My settings allow up to 500 connections (this is with the memory limit of the server).

The symptoms are that the mysql process hogs around 100% of the CPU (shown in top, it is Quad core so still plenty of CPU left). This went on for about 5 minutes and then everything returned to normal. mysql fully recovered and did not restart as shown by its up time.

I have been on to our host (HostGator) and they optimised our mysql settings last night, saying that it was inefficiently configured (it was the same configuration that we had used for RavenNuke for years though).

Before their optimisations instead of the CPU rising to 100% during the problem it would barely get above 0.3% but the disk i/o would shoot through the roof - so I think they have made the dealing with the problem more efficient but it still exists. Also before they did anything it was less likely to recover, requiring mysql to be restarted.

When OCP reports the bailout, not long after cron emails me an error that contains the global css file - is that expected behaviour?

Code

<!DOCTYPE html><html lang="EN">
<head>
   <title>Critical error</title>
   <style type="text/css"><![CDATA[/*

Copyright (c) ocProducts, 2004-2012
*/

/*
This is ocPortal's main CSS file. It defines colours, re-used styles, and core styles for core functionality.

The CSS is written to CSS3/HTML5 standards. Parts that are still considered experimental on some browsers are surrounded using the Tempcode 'BETA_CSS_PROPERTY' symbol, which automatically injects .....

Any idea what is going on?

I am confused because mysql is not seeing the number of connections that OCP is reporting have been exceeded.

Cheers
Ade

Back to the top
 
Posted
Rating:
#94472
Avatar

If it happens, log into MySQL as the root account, and type "SHOW PROCESSLIST". Then look at / send me the results.


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:
#94473
Avatar

Community saint

ok will do Chris.

Host Gator have also suggested that I turn off persistent database connections (it is a dedicated server) as they have had problems in the past with tables remaining locked and a script trying to use the same connection is unable to and blocks until something blows up.

I have turned the persistent data connections off - I take it I do not have to restart Apache or mysql for it to take effect - OCP will just start using non-persistent ones ?

Cheers
Ade
Back to the top
 
Posted
Rating:
#94474
Avatar

no reset needed


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:
#94478
Avatar

Community saint

Hi Chris,
It happened again and recovered quite quickly.
Load went up to about 3.8 and I got one email from cron as before, this is the output from the process list:

Code

mysql> show full processlist;
+-------+-------------+-----------+------------------+----------------+------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id    | User        | Host      | db               | Command        | Time | State                | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-------+-------------+-----------+------------------+----------------+------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 93636 | DELAYED     | localhost | eximstats        | Delayed insert |   18 | Waiting for INSERT   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 94901 | DELAYED     | localhost | eximstats        | Delayed insert |   40 | Waiting for INSERT   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 94946 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=149928  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94948 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | Locked               | SELECT ((SELECT COUNT(DISTINCT r.id) FROM ocp_images r JOIN ocp_translate t1 ON t1.id=r.comments AND t1.language='EN' WHERE MATCH (t1.text_original) AGAINST ('universal joints' IN BOOLEAN MODE) AND (t1.text_original IS NOT NULL) AND add_date>1326047920 AND validated=1)+(SELECT COUNT(DISTINCT r.id) FROM ocp_images r JOIN ocp_translate t2 ON t2.id=r.title AND t2.language='EN' WHERE MATCH (t2.text_original) AGAINST ('universal joints' IN BOOLEAN MODE) AND (t2.text_original IS NOT NULL) AND add_date>1326047920 AND validated=1)) LIMIT 1                                                                                  |
| 94949 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=149928  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94950 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=149928  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94951 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=149928  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94958 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   41 | Copying to tmp table | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=138107  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94960 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   41 | Copying to tmp table | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=138107  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94962 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | UPDATE ocp_translate SET source_user=2, broken=0, text_original='', text_parsed='return unserialize(\"a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\\\"string_attach_50eb16540ec0a1.58160736\\\";i:1;a:0:{}i:2;i:1;i:3;s:0:\\\"\\\";i:4;s:0:\\\"\\\";}}i:1;a:0:{}i:2;s:10:\\\":container\\\";i:3;N;i:4;N;i:5;s:66:\\\"\\$TPL_FUNCS[\'string_attach_50eb16540ec0a1.58160736\']=\\\"echo \\\\\\\"\\\\\\\";\\\";\\n\\\";}\");\n' WHERE (id=17446 AND language='EN')  LIMIT 1                                                                                                                                                                               |
| 94963 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT m.*,text_parsed AS signature FROM ocp_f_members m LEFT JOIN ocp_translate t ON language='EN' AND m.m_signature=t.id WHERE m.id=21401 OR m.id=19008 OR m.id=15089 OR m.id=4088 OR m.id=1178                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| 94964 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT f.*,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 ocp_f_forums f LEFT JOIN ocp_translate t0 ON t0.id=f_description AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=f_intro_question AND t1.language='EN' ORDER BY f_parent_forum,f_position                                                                                                                                                                                                                                                                         |
| 94965 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT g.*,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 ocp_f_groups g LEFT JOIN ocp_translate t0 ON t0.id=g_name AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=g_title AND t1.language='EN' WHERE g.id=8                                                                                                                                                                                                                                                                                                               |
| 94966 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT g.*,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 ocp_f_groups g LEFT JOIN ocp_translate t0 ON t0.id=g_name AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=g_title AND t1.language='EN' WHERE g.id=9                                                                                                                                                                                                                                                                                                               |
| 94969 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT f.*,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,t3.text_original AS t3__text_original,t3.text_parsed AS t3__text_parsed FROM ocp_f_member_custom_fields f LEFT JOIN ocp_translate t0 ON t0.id=field_1 AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=field_38 AND t1.language='EN' LEFT JOIN ocp_translate t2 ON t2.id=field_7 AND t2.language='EN' LEFT JOIN ocp_translate t3 ON t3.id=field_41 AND t3.language='EN' WHERE mf_member_id=6564 |
| 94970 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT g.*,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 ocp_f_groups g LEFT JOIN ocp_translate t0 ON t0.id=g_name AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=g_title AND t1.language='EN' WHERE g.id=3 OR g.id=27 OR g.id=14 OR g.id=16 OR g.id=18 OR g.id=19 OR g.id=23 OR g.id=2                                                                                                                                                                                                                                   |
| 94972 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT g.*,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 ocp_f_groups g LEFT JOIN ocp_translate t0 ON t0.id=g_name AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=g_title AND t1.language='EN' WHERE g.id=9                                                                                                                                                                                                                                                                                                               |
| 94974 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT g.*,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 ocp_f_groups g LEFT JOIN ocp_translate t0 ON t0.id=g_name AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=g_title AND t1.language='EN' WHERE g.id=9                                                                                                                                                                                                                                                                                                               |
| 94977 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT main.id,main.g_name,main.g_is_default,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed FROM ocp_f_groups main LEFT JOIN ocp_translate t0 ON t0.id=main.g_name AND t0.language='EN' WHERE (main.g_is_presented_at_install=1) ORDER BY g_order                                                                                                                                                                                                                                                                                                                                                                 |
| 94978 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   31 | Copying to tmp table | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=138107  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94979 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   31 | Copying to tmp table | SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=138107  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1                                                                                                                                                                                                                                                                                                                                                                       |
| 94981 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT *,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 ocp_cached_comcode_pages a LEFT JOIN ocp_comcode_pages b ON (a.the_page=b.the_page AND a.the_zone=b.the_zone) LEFT JOIN ocp_translate t0 ON t0.id=string_index AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=cc_page_title AND t1.language='EN' WHERE (a.the_page='panel_top' AND a.the_zone='' AND the_theme='V9MK1OC')  LIMIT 1                                                                                                                                 |
| 94982 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT *,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 ocp_cached_comcode_pages a LEFT JOIN ocp_comcode_pages b ON (a.the_page=b.the_page AND a.the_zone=b.the_zone) LEFT JOIN ocp_translate t0 ON t0.id=string_index AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=cc_page_title AND t1.language='EN' WHERE (a.the_page='start' AND a.the_zone='' AND the_theme='V9MK1OC')  LIMIT 1                                                                                                                                     |
| 94983 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | 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 ocp_zones main LEFT JOIN ocp_translate t0 ON t0.id=main.zone_title AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=main.zone_header_text AND t1.language='EN' ORDER BY zone_name LIMIT 0,50                                                                                                                                                                                                                                          |
| 94984 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT *,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 ocp_cached_comcode_pages a LEFT JOIN ocp_comcode_pages b ON (a.the_page=b.the_page AND a.the_zone=b.the_zone) LEFT JOIN ocp_translate t0 ON t0.id=string_index AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=cc_page_title AND t1.language='EN' WHERE (a.the_page='start' AND a.the_zone='' AND the_theme='V9MK1OC')  LIMIT 1                                                                                                                                     |
| 94986 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT *,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 ocp_cached_comcode_pages a LEFT JOIN ocp_comcode_pages b ON (a.the_page=b.the_page AND a.the_zone=b.the_zone) LEFT JOIN ocp_translate t0 ON t0.id=string_index AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=cc_page_title AND t1.language='EN' WHERE (a.the_page='start' AND a.the_zone='' AND the_theme='V9MK1OC')  LIMIT 1                                                                                                                                     |
| 94987 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    6 | Locked               | SELECT *,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 ocp_cached_comcode_pages a LEFT JOIN ocp_comcode_pages b ON (a.the_page=b.the_page AND a.the_zone=b.the_zone) LEFT JOIN ocp_translate t0 ON t0.id=string_index AND t0.language='EN' LEFT JOIN ocp_translate t1 ON t1.id=cc_page_title AND t1.language='EN' WHERE (a.the_page='start' AND a.the_zone='' AND the_theme='V9MK1OC')  LIMIT 1                                                                                                                                     |
| 95016 | eximstats   | localhost | eximstats        | Sleep          |   18 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| 95089 | root        | localhost | NULL             | Query          |    0 | NULL                 | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
+-------+-------------+-----------+------------------+----------------+------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
29 rows in set (0.00 sec)

mysql> show full processlist;
+-------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id    | User        | Host      | db               | Command        | Time | State                | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+-------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 93636 | DELAYED     | localhost | eximstats        | Delayed insert |   32 | Waiting for INSERT   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 94901 | DELAYED     | localhost | eximstats        | Delayed insert |   54 | Waiting for INSERT   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 94948 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | Sending data         | SELECT COUNT(*) FROM ocp_galleries r LEFT JOIN ocp_seo_meta m ON (m.meta_for_type='gallery' AND m.meta_for_id=r.name) JOIN ocp_translate tm ON tm.id=m.meta_keywords AND tm.language='EN' WHERE MATCH (tm.text_original) AGAINST ('universal joints' IN BOOLEAN MODE) AND (tm.text_original IS NOT NULL) AND add_date>1326047920 AND name NOT LIKE 'download\_%' LIMIT 1                                                                                                                                                                                                                             |
| 94963 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 94964 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 94965 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | System lock          | INSERT INTO ocp_stats (access_denied_counter, browser, operating_system, the_page, ip, the_user, date_and_time, referer, get, post, milliseconds) VALUES (0, 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0', 'Windows NT 6.1; WOW64; rv:17.0', 'forum/pages/modules/topicview.php', '90.217.85.93', 22828, 1357583976, 'http://vwgolfmk1.org.uk/forum/index.php?page=vforums&type=misc', '<param>page=topicview</param>\n<param>id=149971</param>\n', '', 53000)                                                                                                         |
| 94966 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 94969 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | System lock          | INSERT INTO ocp_stats (access_denied_counter, browser, operating_system, the_page, ip, the_user, date_and_time, referer, get, post, milliseconds) VALUES (0, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/534.57.2 (KHTML, like Gecko) Version/5.1.7 Safari/534.57.2', 'Macintosh; Intel Mac OS X 10_6_8', 'forum/pages/modules/topicview.php', '86.158.55.245', 14628, 1357583976, 'http://vwgolfmk1.org.uk/forum/index.php?page=forumview&type=misc&id=cars-for-sale_2&start=60', '<param>page=topicview</param>\n<param>id=147635</param>\n<param>kfs100=60</param>\n', '', 50000) |
| 94983 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 95089 | root        | localhost | NULL             | Query          |    0 | NULL                 | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| 95157 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 95158 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | System lock          | INSERT INTO ocp_stats (access_denied_counter, browser, operating_system, the_page, ip, the_user, date_and_time, referer, get, post, milliseconds) VALUES (0, 'Mozilla/5.0 (Windows NT 5.2; rv:16.0) Gecko/20100101 Firefox/16.0', 'Windows NT 5.2; rv:16.0', 'forum/pages/modules/topicview.php', '91.207.9.146', -369526384, 1357583976, 'http://vwgolfmk1.org.uk/forum/index.php?page=topicview&id=your-mk1-golfs_2%2Fmy-golf-gl', '<param>page=topicview</param>\n<param>id=149981</param>\n', '', 6000)                                                                                          |
| 95161 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 95162 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | closing tables       | INSERT INTO ocp_stats (access_denied_counter, browser, operating_system, the_page, ip, the_user, date_and_time, referer, get, post, milliseconds) VALUES (0, 'Mozilla/5.0 (Windows NT 5.1; rv:7.0) Gecko/20100101 Firefox/7.0', 'Windows NT 5.1; rv:7.0', 'pages/modules/join.php', '91.207.9.146', -369526384, 1357583976, 'http://vwgolfmk1.org.uk/index.php?page=join&redirect=http%3A%2F%2Fvwgolfmk1.org.uk%2Fforum%2Findex.php%3Fpage%3Dforumview', '<param>page=join</param>\n<param>redirect=http://vwgolfmk1.org.uk/forum/index.php?page=forumview</param>\n', '', 5000)                     |
| 95172 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 95173 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Sleep          |    0 |                      | NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 95174 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    0 | Copying to tmp table | SELECT DISTINCT t_forum_id,t.id FROM ocp_f_topics t LEFT JOIN ocp_f_read_logs l ON (t.id=l_topic_id AND l_member_id=15821) WHERE (t_forum_id=79) AND t_cache_last_time>1355769576 AND (l_time<t_cache_last_time OR l_time IS NULL)                                                                                                                                                                                                                                                                                                                                                                   |
+-------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
17 rows in set (0.00 sec)

Give any clue ?

Cheers,
Ade
Back to the top
 
Posted
Rating:
#94484
Avatar

I think

Code

SELECT p.p_title,t.text_parsed,t.id,p.p_poster,p.p_poster_name_if_guest FROM ocp_f_posts p LEFT JOIN ocp_translate t ON t.id=p.p_post WHERE p_validated=1 AND p_topic_id=138107  AND t.text_original NOT LIKE '%This is a spacer post%' ORDER BY p_time,p.id LIMIT 1
is running slow. I'll look into optimising that.

Because this is slow running and reading ocp_translate, it is locking ocp_translate to writes. I think then the write to ocp_translate that is in the queue is then locking ocp_translate to further reads (didn't know that happened, it's interesting).


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:
#94485
Avatar

It shouldn't be slow, p_topic_id should have an index on it, so it will need to only search the posts in the topic, for which I highly doubt there are hundreds (which is where you would start having any measurable slow-down).

I'll take a look on your site.


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:
#94486
Avatar

Took around 10 seconds on your site, very slow!


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:
#94487
Avatar

Community saint

Thanks Chris.

It has slowed down a few times tonight, never more than 30 seconds though.
All the database optimisation has helped a lot - so it has a positive.

Hope you can track it down.

I know it has happened because of the cron email output

Cheers
Ade
Back to the top
 
Posted
Rating:
#94488
Avatar

Community saint

ah ok - what is causing it ?
Back to the top
 
Posted
Rating:
#94489
Avatar

I'm not sure. Can I have phpMyAdmin access? Trying to step-through queries and DB structure in OcCLE is a bit of a challenge.


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:
#94491
Avatar

Chris Graham said

I'm not sure. Can I have phpMyAdmin access? Trying to step-through queries and DB structure in OcCLE is a bit of a challenge.

Hold on that. I had to adjust ocP slightly to grab EXPLAIN data, but now I can do it from OcCLE. It's okay, doing things the hard way for now, makes it easier in the future; ).


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
Item has a rating of 5 (Liked by LhasadreamsLiked by Guest)  
Rating:
#94492
Avatar

Okay, so MySQL on your server was not picking an index for some reason. It decided it wanted to copy and merge two large tables fully on disk, rather than isolating a small number of rows first.

I have added an index hint and resolved it :).

You should find anything that reads in comment topics (e.g. viewing news) much faster now. The lock issue should be fixed too.


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:
#94493
Avatar

Community saint

Thank you very much for sorting this Chris.

Cheers,
Ade
Back to the top
 
Posted
Rating:
#94506
Avatar

Community saint

Hi Chris,

We are still having the odd blip.

It characterises itself by the site appearing to lock up for a few minutes, followed by an email from the cron bridge to say there has been an error.

It happened a couple of times yesterday - almost like everything is blocked until some query completes.

I was not around to capture what was going on - will try to next time it happens.

Is there anything that can be put to capture what database queries are being worked on when the cron bridge reports the error? It may of cleared by then of course.

Cheers,
Ade
Back to the top
 
Posted
Rating:
#94509
Avatar

You can turn on the MySQL slow query log.


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:
#94511
Avatar

Community saint

Ok, cheers Chris.

It has just happened again.

OCP gives a bail out message because of exceeded connections - which is not true as you can see in the output below.

I got 3 cron bridge error messages via email.

It took 3 minutes to come back - nothing dies it just recovers. So it appears that Mysql is working hard and blocking everything else, load goes up to 1.5.

Code

mysql> show processlist;
+--------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id     | User        | Host      | db               | Command        | Time | State                | Info                                                                                                 |
+--------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+
| 136114 | DELAYED     | localhost | eximstats        | Delayed insert |   55 | Waiting for INSERT   |                                                                                                      |
| 136167 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   93 | Copying to tmp table | SELECT r.*,MATCH (t1.text_original) AGAINST ('cars for sale') AND (t1.text_original IS NOT NULL) AS  |
| 136183 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | UPDATE ocp_translate SET source_user=456, broken=0, text_original='reason behind the struts bein str |
| 136184 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136186 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136187 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.id,text_original,g_name,g.g_hidden FROM ocp_f_groups g LEFT JOIN ocp_translate t ON languag |
| 136188 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136189 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.id,main.s_title,main.s_group_id,main.s_cost,t0.text_original AS t0__text_original,t0.tex |
| 136190 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136192 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Copying to tmp table | SELECT r.* FROM ocp_images r LEFT JOIN ocp_seo_meta m ON (m.meta_for_type='image' AND m.meta_for_id= |
| 136195 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.id,text_original,g_name,g.g_hidden FROM ocp_f_groups g LEFT JOIN ocp_translate t ON languag |
| 136196 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.id,main.s_title,main.s_group_id,main.s_cost,t0.text_original AS t0__text_original,t0.tex |
| 136197 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136198 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136201 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.id,text_original,g_name,g.g_hidden FROM ocp_f_groups g LEFT JOIN ocp_translate t ON languag |
| 136202 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.id,text_original,g_name,g.g_hidden FROM ocp_f_groups g LEFT JOIN ocp_translate t ON languag |
| 136203 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.id,text_original,g_name,g.g_hidden FROM ocp_f_groups g LEFT JOIN ocp_translate t ON languag |
| 136204 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136205 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.id,main.s_title,main.s_group_id,main.s_cost,t0.text_original AS t0__text_original,t0.tex |
| 136207 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.id,main.g_name,main.g_is_default,t0.text_original AS t0__text_original,t0.text_parsed AS |
| 136208 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136209 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT p.*,t.text_parsed AS text_parsed,t.text_original AS message_comcode,h.h_post_id FROM ocp_f_po |
| 136210 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT p.*,t.text_parsed AS text_parsed,t.text_original AS message_comcode,h.h_post_id FROM ocp_f_po |
| 136238 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_origin |
| 136239 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT p.*,t.text_parsed AS text_parsed,t.text_original AS message_comcode,h.h_post_id FROM ocp_f_po |
| 136252 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   48 | Locked               | SELECT g.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original  |
| 136307 | root        | localhost | NULL             | Query          |    0 | NULL                 | show processlist                                                                                     |
+--------+-------------+-----------+------------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+
27 rows in set (0.00 sec)

mysql> show status like '%onn%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| Aborted_connects         | 187    |
| Connections              | 136319 |
| Max_used_connections     | 28     |
| Ssl_client_connects      | 0      |
| Ssl_connect_renegotiates | 0      |
| Ssl_finished_connects    | 0      |
| Threads_connected        | 5      |
+--------------------------+--------+
7 rows in set (0.03 sec)

mysql> show processlist;
+--------+-------------+-----------+------------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id     | User        | Host      | db               | Command        | Time | State              | Info                                                                                                 |
+--------+-------------+-----------+------------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 136114 | DELAYED     | localhost | eximstats        | Delayed insert |   66 | Waiting for INSERT |                                                                                                      |
| 136167 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |    2 | Sending data       | SELECT COUNT(*) FROM ocp_galleries r LEFT JOIN ocp_seo_meta m ON (m.meta_for_type='gallery' AND m.me |
| 136192 | vwgolfm_ocp | localhost | vwgolfm_ocp_live | Query          |   10 | Sending data       | SELECT ((SELECT COUNT(DISTINCT r.id) FROM ocp_images r JOIN ocp_translate t1 ON t1.id=r.comments AND |
| 136307 | root        | localhost | NULL             | Query          |    0 | NULL               | show processlist                                                                                     |
+--------+-------------+-----------+------------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql>

Any clue from this ?

Cheers
Ade
Back to the top
 
Posted
Rating:
#94514
Avatar

I should have asked you to run "SHOW FULL PROCESSLIST", as this is cropped (I guess you did do the full one before though, as the previous dump was okay).

I have managed to resolve the SELECT r.* FROM ocp_images r LEFT JOIN ocp_seo_meta m ON (m.meta_for_type='image' AND m.meta_for_id= one here, which seems to be what has locked up everything here. It turns out MySQL created a temporary table (=v slow) for some thing about this search query, and I was able to workaround that for most cases.

I'm not sure about the SELECT r.*,MATCH (t1.text_original) AGAINST ('cars for sale') AND (t1.text_original IS NOT NULL) AS one, as I couldn't find a way to reproduce a query that starts like that that creates a temporary table. However, that doesn't seem to be locking stuff up oddly (you'll notice the time is way before the other ones, which all locked up together), so I am suspicious about it.


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:
#94515
Avatar

Community saint

Excellent, thanks Chris.
I have the slow query log on now, worst is 14 seconds but with minute lock times - they just look like queries querying lots of records.

Do you know why MySQL is doing this?
Back to the top
 
Posted
Rating:
#94516
Avatar

Do you know why MySQL is doing this?

It's difficult to answer that, there are many variables. Depends on usage patterns (in terms of people noticing locks made by another user), the amount of data (I think you have a lot of images for example, more than most), MySQL version, table types, and MySQL settings. The amount of data will likely be the main thing, most sites don't have search actively used, and most don't have a lot of data, so we may see some cases where inefficient processing shows up that would otherwise go unnoticed.

Can you show me the long queries?


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
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand