… amazing MySQL manual, especially the option and …commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual…thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
…tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) …by spaceid limit 1;”` if [ "a$CURRENT_SPACEID" == "a" ]; then exit fi CURRENT_TABLENAME=`mysql …mysql/recover/ chown mysql.mysql /var/lib/mysql/recover/$CURRENT_TABLENAME.ibd sleep 1 echo “importing tablespace” mysql -…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need …delete with LIMIT in the loop, controlling maximum amount of values per batch in multiple row insert … down your batch job (such as adding sleep calls) to ensure there is enough breathing …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…, OS thread id 1151088992 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked…400 tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_… by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use …
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…_sleep_delay and innodb_concurrency_tickets. I’ll try to explain how it works. MySQL has pluginable architecture which divides work between mysql… (e.g. a lot of INSERT threads) thread thrashing could be still observed even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…ha_read’, ’0′ ‘Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill’, ’47′ ‘Com_load…1.00, 0.95 328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped…mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… your normal working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize such effect… or as set of queries going one after another. Have sleep between them so none of them can take too much… too long time. If you delete things do DELETE … LIMIT 1000 and insert sleep 10; in between. By spreading load this way you…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…vs. MonetDB would interpret really large INSERT statements, the kind produced by mysqldump… and see if there are sleep() statements). What did I see in … front-end is a great idea; MySQL abstracts the storage backend, but why… use — there are a number of limitations (concurrency, for one) and it …
