… query design mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is… application allows it. In MySQL 5.1 with row level replication you will not have selection process running on SLAVE but it… out and slow down your batch job (such as adding sleep calls) to ensure there is enough breathing room for replication…
Comment: Apache PHP MySQL and Runaway Scripts
May 21, 2008 By 20 Comments
… something. If script is just doing something like scripts or MySQL calls and does not output anything to the browser neither… the server will know that the client is there. The MySQL SLEEP function gives me thoughts about possible SQL Injection attack for… can inject SLEEP(99999999) (choose your number) and disconnect. Doing it till there are no more web processes/threads, or the MySQL connections…
Post: Announcing Percona XtraBackup 2.0.5
January 23, 2013 By Leave a Comment
… what extra file to read the default MySQL options before the standard defaults-file. It … of streaming backups, innobackupex would resume the XtraBackup process and then wait for it to finish …. Bug fixed #1095249 (Alexey Kopytov). Unnecessary long sleep() in innobackupex lead to FLUSH TABLES WITH …
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… had to forward the tcpdump output to another host for processing because the database host couldn’t handle the additional IO… $TMP/$LOCKFILE # run the tcpdump & write to remote file and sleep for a bit tcpdump -i eth0 -s 65535 -x -n… == 2′ 2>/dev/null \ | ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both remote…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… you can use this sample database to spread processing over up to 20 nodes. The Infobright Community… data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’… innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… user, load average: 0.79, 1.00, 0.95 328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu… 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Comment: Using MyISAM in production
June 20, 2006 By 36 Comments
…: RedHat linux 2.4 Application: Java jetty server with Hibernate MySQL version = 4.1.19 We have been running application in… doing nothing resulting in large number of db connections Once MySQL unfreezes, all of threads complete and everything is fine again… and don’t see any thing happening as most fo processes are SLEEP mode We are suspecting ,based on some thread on…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… our plans to create excellent free tools for MySQL administrators. There is one really big thing to …, and set up offsets and modulos and set sleep times and throttle the tool and be careful …ton of great improvements to our testing and development process, as well as rewriting pt-diskstats from awk …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… sec, process no 3396, OS thread id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id…, process no 3396, OS thread id 1150142816 fetching rows, thread declared inside InnoDB 166 mysql tables in use 1, locked 0 MySQL thread…. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway,…pw” => “”, “etc” => “etc” ); # skip the first 3 lines (); (); (); # Process the query log, and build a couple…run each one. # I use while(){ sleep 1 } rather than sleep n to # avoid timing issues – this…
