… problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK… it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | …
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….
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 5 Comments
… works great for backing MySQL up to an NFS volume, but there is a gotcha …the data. That’s because the data might not be flushed to the NFS server yet — it might just be sitting…can solve this by mounting NFS synchronously on the database host. This is slower for general-purpose usage, but it should…
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 ‘…hosts.internal [host list omitted] Now you need to set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts…per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_…
Post: Percona Server and XtraBackup weekly news, March 28th
March 27, 2011 By Leave a Comment
…. Peter, Vadim, and Nickolay continued investigating alternative methods of implementing flush in Percona Server. (I am involved, but not as deeply… (which is actually worse in some ways), there is flush list flushing and LRU flushing, and on and on. We have been benchmarking… backups with XtraBackup. It is called XtraBackup Manager and is hosted on Google Code. We finished preparing XtraBackup to be used…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…MySQL backup product. One of the representatives told me that their backup product uses FLUSH… is ongoing: mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host | db …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… fact they chose shared hosting. Of course this …transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table…with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS)….
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… later mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot… to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ… slave to saved binary log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file…
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
… never needs to “stall” to perform total modified pages flush but instead flushing of dirty pages happens gradually in small chunks so… case current implementation works just fine – Innodb flush threads selects range of LSN to flush each round which is small enough.Â… to constant. However the shared drive at shared MySQL virtual hosting and powerful RAID system may have very different performance properties…
Comment: How to track down the source of Aborted_connects
July 10, 2010 By 17 Comments
I have read this somewhere MySQL internally increments a per-host counter it uses to track how many “bad connections†…_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 somewhere.I would…
