… are slow or not available and you’re not dealing with timeouts properly. Or may be you have several connections to MySQL server… trace originated from php stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections leaving last… know any debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the one for…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… mysql_* functions directly This is probably bad but I do not like solutions proposed by original article ether. PEAR is slow as… also note for many PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections can be much… with loosing data etc. Read more in my Why MySQL Could be slow with Large Tables article. 5. The n+1 pattern…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…| 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002…a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata …MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh… $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh… laptop (running dbt2) was not slowed down by handling all those connections. I tried generating the idle connections from a third box and…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you… connections can help with that. By the way, we’re seeing reports that MySQL 5.6 non-persistent connections…in sync continuously. Q: If a slave is slow because of bandwidth issues, the seconds behind master…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive…-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… mysql connection opened in slow HTTP connection reaches to wait_timeout and MySQL aborts those mysql connections. There were about 200 Aborted_Clients per hour in mysql error… me that the main bottleneck of web server only serving php scripts is CPU not RAM. Modern best dual CPUs can…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…PHP script which retrieves all rows from the table: < ?php $link = mysql_connect(‘localhost’, ‘root’, ”) or die(‘Could not connect: ‘ . mysql_error()); mysql…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 30 Comments
…seeing this occurring due to every apache connection opening a mysql connection (as is common in a PHP driven website). If there is …requests increase 2. mysql queries increase 3. mysql slow queries increase 4. apache connections start to wait on slow mysql queries 5. apache connections take longer …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… mysql_* functions directly This is probably bad but I do not like > solutions proposed by original article ether. PEAR is slow as… also note for many PHP applications abstraction layer is > not the main performance problem, also benefit from persistent > connections can be much… with loosing data etc. Read more in my > Why MySQL Could be slow with Large Tables article. Deciding whether or not to…
