…; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | … | NULL | Query | 317 | Waiting for table flush | flush tables with read lock | 0 | 0 …
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
… +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host …Flushing tables” is a misnomer — connection 5 is not flushing tables yet. It’s waiting to get the lock. Flushing tables After the FLUSH…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… the patch features will surely be a great help for hosting providers to produce detailed reports on how each customer utillizes… his own application, completely ignoring the fact they chose shared hosting. Of course this alone is not a problem and theoretically… tables and indexes can be cleaned with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS). All that can be fed into…
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â… max_connect_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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual federatedblogpercona.commanual flushblogpercona.commanual Flush_commandsblogpercona.commanual flush_timeblogpercona.commanual foreign_key_checksblogpercona…..commanual skip_grant_tablesblogpercona.commanual skip_host_cacheblogpercona.commanual skip_lockingblogpercona.commanual skip_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 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…-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract… read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode…
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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… in our manual) – # the syntax is: # # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, # MASTER_USER=, MASTER_PASSWORD= ; # # where you replace , , by…-id = 2 # # The replication master for this slave – required #master-host = # # The username the slave will use for authentication when connecting…_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK Note – this command may take a… if you have long running queries. The catch here is FLUSH TABLES WITH READ LOCK actually waits for all statements to… 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.Â… constant. However the shared drive at shared MySQL virtual hosting and powerful RAID system may have very different performance properties…
