…to filter what gets written to the binary log on the master. This can be useful if you’re trying to…to wait for the next release of MHA. Q: How do you monitor MySQL to…to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any) system variables. For… server. Granted, this can take a lot of disk space, but it allows you to “run… used, and changed/renamed other options to be more logical. The result is a simpler…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 16403 n bits 72 index `PRIMARY` of table `test/iz` trx id 0 42313619 lock…) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 16403 n bits 72 index `PRIMARY` of table `test/iz` trx id 0 42313620 lock…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 13 Comments
… pretty handy way to be able to search and scroll through. No mouse required, of course. But it doesn’t have to be this simple! You… are any lock waits: mysql> pager /tmp/lock_waits PAGER set to ‘/tmp/lock_waits‘ mysql> show innodb status\G ——- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… j=0 where i=5 ——- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 33504 n bits 328 index `j` of table `test/sample` trx id 0 42304626 lock…’ll not see any write activity. Other transaction which happes to be simple primary key update is waiting on sample table for this record to be unlocked.
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
Hi Miguel ， I’ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are as… t values(33); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Here I tried to insert a value out of [21… insert into t values(33) ——- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 57 page no 3 n bits 72…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
…LOCK command immediately requests the global read lock. As soon as this happens, even before the lock is granted to it, all other processes attempting to…Waiting for the lock Before the FLUSH TABLES WITH READ LOCK command can successfully acquire the lock, anything else that currently holds the lock…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…to be aware of is SELECT FOR UPDATE. This operation acquires and holds a row-level lock for each row returned by the SELECT. These locks…they are taken for granted. But engine developers need to keep performance, … thread to do recovery asynchronously. So the thread can wait for the LOCK_plugin to be …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…in average? This leads to the …to ‘b’ is 2mb then the total amount of memory would be something like 1800 + 2*600 = 3G right? To much to handle for…_show_fields’, ’4260′ ‘Com_show_grants‘, ’0′ ‘Com_show_innodb_status…to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…120619 13:21:18 InnoDB: Waiting for the background threads to start 120619 13:21:19 Percona… and write to all cluster nodes. This can be done, but because of optimistic locking at commit… variable. To set it up, create the clustercheck user. mysql> grant process on *.* to ‘clustercheckuser’@'localhost…
