Otdfbt

Does this article imply that Turing-Computability is not the same as "effectively computable"?

Would glacier 'trees' be plausible?

What does this colon mean? It is not labeling, it is not ternary operator

What was the state of the German rail system in 1944?

Was Unix ever a single-user OS?

Should I replace my bicycle tires if they have not been inflated in multiple years

Enumerate Derangements

How to reply this mail from potential PhD professor?

If 1. e4 c6 is considered as a sound defense for black, why is 1. c3 so rare?

Is Cola "probably the best-known" Latin word in the world? If not, which might it be?

What is the unit of the area when geometry attributes are calculated in QGIS?

If Earth is tilted, why is Polaris always above the same spot?

Is it cheaper to drop cargo than to land it?

How do I tell my manager that his code review comment is wrong?

Identifying my late father's D&D stuff found in the attic

Is a life-stealing melee cantrip unbalanced?

In Endgame, why were these characters still around?

How did Arya get her dagger back from Sansa?

Can I get a paladin's steed by True Polymorphing into a monster that can cast Find Steed?

Besides the up and down quark, what other quarks are present in daily matter around us?

What are the spoon bit of a spoon and fork bit of a fork called?

Is there a legal ground for stripping the UK of its UN Veto if Scotland and/or N.Ireland split from the UK?

Should one double the thirds or the fifth in chords?

Identifying a transmission to myself

MySQL PDO Too many connections

Debugging mysql too many connections problemMySQL too many connectionsHorrible PHP/MySQL Query Performance On Ubuntu Server 10.04Building a 1,000M row MySQL tableMySQL Error: Too many connectionsMysqldump causes “Too many connections”'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'ubuntu mysql too many connectionsCan't stop mysql too many connectionsMySQL INSERTs on a database table block SELECTS in another database and in another table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I have an application that is constantly inserting to a stats table. The average number of open connections is usually about 20 to 22.

There is also a processing script in PHP run by a cron that runs every 30 minutes. Around 2am UTC it takes about 10 minutes to process which is the longest amount of time during a day.

Around this time, I'm getting about 8000 PDOException: SQLSTATE[08004] [1040] Too many connections errors.

The max_connections is set to 500.

I've observed that by doing SHOW PROCESSLIST; I don't usually see any queries in the Info column. While the cron is running, I do see the query for the cron in the Info column and then the SQL inserts quickly pile up below it.

I don't really know a great deal about configuring MySQL but it seems like the inserts to the stats table are getting queued and surpassing the max connection limit while the Cron script is running.

What can be causing this and which configuration settings should I look at changing?

mysql pdo

share|improve this question

edited Apr 23 at 9:48

Asa Carter

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are any other cron jobs running around that time?
  
  – Jenny D
  Apr 23 at 9:48
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  No, I've disabled a cron that does a MySQL backup to a remote server, while trying to identify the issue.
  
  – Asa Carter
  Apr 23 at 9:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is the table in question InnoDB or MyISAM? Is the cron script performing any write operations (INSERT, DELETE, UPDATE) in this table? In what status are the INSERT queries when this happens? If you are using MyISAM and the queries show "waiting for table level lock", you must keep in mind, that MyISAM locks on table level and you maybe should consider switching to a storage engine, which does row-level locking.
  
  – s1lv3r
  Apr 23 at 9:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  They are InnoDB tables. Lots of inserts and deletes are being done in the cron script. Each statement is closed after execution and the connection is closed on completion.
  
  – Asa Carter
  Apr 23 at 10:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So the interesting info still is: What is the state of the piling up INSERT commands?
  
  – s1lv3r
  Apr 23 at 10:05
  

  
  
  
  

 | 
show 13 more comments

1

I have an application that is constantly inserting to a stats table. The average number of open connections is usually about 20 to 22.

There is also a processing script in PHP run by a cron that runs every 30 minutes. Around 2am UTC it takes about 10 minutes to process which is the longest amount of time during a day.

Around this time, I'm getting about 8000 PDOException: SQLSTATE[08004] [1040] Too many connections errors.

The max_connections is set to 500.

I've observed that by doing SHOW PROCESSLIST; I don't usually see any queries in the Info column. While the cron is running, I do see the query for the cron in the Info column and then the SQL inserts quickly pile up below it.

I don't really know a great deal about configuring MySQL but it seems like the inserts to the stats table are getting queued and surpassing the max connection limit while the Cron script is running.

What can be causing this and which configuration settings should I look at changing?

mysql pdo

share|improve this question

edited Apr 23 at 9:48

Asa Carter

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are any other cron jobs running around that time?
  
  – Jenny D
  Apr 23 at 9:48
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  No, I've disabled a cron that does a MySQL backup to a remote server, while trying to identify the issue.
  
  – Asa Carter
  Apr 23 at 9:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is the table in question InnoDB or MyISAM? Is the cron script performing any write operations (INSERT, DELETE, UPDATE) in this table? In what status are the INSERT queries when this happens? If you are using MyISAM and the queries show "waiting for table level lock", you must keep in mind, that MyISAM locks on table level and you maybe should consider switching to a storage engine, which does row-level locking.
  
  – s1lv3r
  Apr 23 at 9:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  They are InnoDB tables. Lots of inserts and deletes are being done in the cron script. Each statement is closed after execution and the connection is closed on completion.
  
  – Asa Carter
  Apr 23 at 10:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So the interesting info still is: What is the state of the piling up INSERT commands?
  
  – s1lv3r
  Apr 23 at 10:05
  

  
  
  
  

 | 
show 13 more comments

I have an application that is constantly inserting to a stats table. The average number of open connections is usually about 20 to 22.

There is also a processing script in PHP run by a cron that runs every 30 minutes. Around 2am UTC it takes about 10 minutes to process which is the longest amount of time during a day.

Around this time, I'm getting about 8000 PDOException: SQLSTATE[08004] [1040] Too many connections errors.

The max_connections is set to 500.

I've observed that by doing SHOW PROCESSLIST; I don't usually see any queries in the Info column. While the cron is running, I do see the query for the cron in the Info column and then the SQL inserts quickly pile up below it.

I don't really know a great deal about configuring MySQL but it seems like the inserts to the stats table are getting queued and surpassing the max connection limit while the Cron script is running.

What can be causing this and which configuration settings should I look at changing?

mysql pdo

share|improve this question

edited Apr 23 at 9:48

Asa Carter

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

share|improve this question

edited Apr 23 at 9:48

Asa Carter

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

share|improve this question

edited Apr 23 at 9:48

Asa Carter

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112

asked Apr 23 at 9:47

Asa CarterAsa Carter

154112