…timeout = 60 interactive_timeout=1800 skip-name-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…”/Server-Status” checking if script dies after specified timeout. As the next step I pressed “STOP” button…practice when you’re using MySQL with PHP as you can have single runaway query which takes a lot… is wrong and if I would use real MySQL queries this would be counted to max_execution_time…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is… for many applications. Query Timeouts Make it easy to specify timeouts for connects and query execution so page would not timeout but you would rather…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini…-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb…=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…… but not for larger ones. First problem was PHP script generating the table took 10GB of RAM… use buffered query the only real call you can get errors is when you run mysql_query , mysql_fetch_row… errors. Connection can timeout If you do not fetch data for long enough MySQL Server may think client…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… know PHP “mysql” extension supported persistent connections but they were disabled in…available and “/proc/sys/net/ipv4/tcp_fin_timeout” to reduce recycle delay. Reducing last one however…what you get with just few queries concurrently. If you have these queries doing large sorts, using temporary…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL… include support for query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… not dealing with timeouts properly. Or may be you have several connections to MySQL server and right now running query which takes that… stack trace originated from php stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections… any debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the one for…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 28 Comments
… than restarting your server or whatever is to set a MySQL value that does not allow connections to last over 30….cnf: wait_timeout=180 # = 30min php cron script: #!/usr/bin/php -q 1000 && $row['Command'] == “Sleep”) && ($row['User'] != “Root”)) { $killed = 0; mysql_query(“kill “.$row…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… using PHP functions make sure default_socket_timeout has proper value or set it per session. Set Curl Timeouts Set both TIMEOUT and CONNECT_TIMEOUT as these apply to different connection stages and just setting timeout is not enough. Beware of PHP… somewhere in curl module (or mysql – waiting on long query to come back) – this is our query if it is waiting on the…
