…mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | …| NULL | Query | 317 | Waiting for table flush | flush tables with read lock | 0 | …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…federatedblogpercona.commanual flushblogpercona.commanual Flush_commandsblogpercona.commanual flush_timeblogpercona.commanual foreign_key…skip_grant_tablesblogpercona.commanual skip_host_cacheblogpercona.commanual skip_lockingblogpercona….
Comment: How to track down the source of Aborted_connects
July 10, 2010 By 17 Comments
…_errors MySQL will block the host from connecting again until you issue a FLUSH HOSTS command. By the above statement it seems clear that mysql server stores the bad client hosts…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host | db | Command…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…completely ignoring the fact they chose shared hosting. Of course this alone is not …: 240 Select_commands: 1759 Update_commands: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> … be cleaned with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS). All that can …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…commands: $ cat servers.txt | grep “10.”| grep -v internal |tee hosts.internal [host list omitted] Now you need to set up the hosts…-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… “we are a SaaS hosted application for data mining …the MySQL version is, and I check (with the ‘file’ command) … | 216162991863 | | Com_admin_commands | 255868807 | … snip … | Uptime | 162626 | | Uptime_since_flush_status | 162626 | +———————————–+———————-+…
Post: Percona Server and XtraBackup weekly news, March 28th
March 27, 2011 By Leave a Comment
…actually worse in some ways), there is flush list flushing and LRU flushing, and on and on. We …. It is called XtraBackup Manager and is hosted on Google Code. We finished preparing XtraBackup …, removing mention of obsolete features and documenting command-line options that were not mentioned in the…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries. The catch here is FLUSH TABLES WITH… slave to saved binary log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file…
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
…moment. When it goes to stable status, several command-line options and configuration variables will be renamed….that. We are working on a new adaptive flushing algorithm that should further improve the quality and…backup needing to be present on the local host. This can save even more disk space. …
