…MySQL manual, especially the option …clientblogpercona.commanual character_set_client_handshakeblogpercona.commanual character_….commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona….
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…time of 1 second tcpdump traffic only from a small and representative subset of clients…dev/null \ | ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to…ssh $REMOTEHOST — “mk-query-digest –type tcpdump –limit $LIMIT < $TMP/$TMPfile 2>&1 > $TMP/$RESfile” scp …
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… for scripts running very long time. For simplicity I did not use MySQL, but other system call – sleep() which has similar behavior for… connection abort from client will not be discovered. This is unfortunately very serious limitation in practice when you’re using MySQL with PHP…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… so long time(wait_timeout). Original timeout was set to default (300 seconds). Some terribly slow http connection consumes timeout limit to… be ok. Mysql connections in sleep state only are available for short duration and there are no aboted_clients in mysql error log. Opening…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… one Peter wrote about recently). The client‘s performance is suffering in … and see if there are sleep() statements). What did I see in … mysql show query times in microseconds? I had to resort to Perl + Time::HiRes for timing… use — there are a number of limitations (concurrency, for one) and it …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…time (18:37 friday) System copes fine with these figures. Queries/sec: 265 Traffic: 1Mb/sec Connections:259 ‘Aborted_clients…0.95 328 processes: 326 sleeping, 2 running, 0 zombie…mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit…
