… allocated in it and how frequently threads are signaled using sync array. These counters can be used to represent frequency with… id 3771312 starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320 MySQL thread id 30898, query…. mysql tables in use 1, locked 0 is number of tables used by transaction in question (meaning it was accessed) and number of tables locked by…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… explain how to run pt-table-checksum and pt-table-sync from slave? This was… pt-query-digest –review S=/tmp/mysql_sandbox5527.sock,u=msandbox,p=…lock the table, long running transactions that lock (part of) the table can make the tool abort with a ‘Lock wait timeout exceeded’ error. The table…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
… the master. In any case you need slave to be synced with Master. To discover the difference between Master and Slave… rename table instead of locking – for many applications this works better anyway as having table locked causes connections to pile up and either MySQL runs… can do following instead: mysql> rename table rep to rep_maint; Query OK, 0 rows affected (0.01 sec) mysql> select * from rep…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master which slave remembers becomes stale. During MySQL 4… recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount of tables or your load…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… be removed or overwritten A table (or entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server…-transactional tables, now you can be locked sub-second. Even with innodb only this can greatly cut down on the lock time by syncing… further improve lock times here when non-transactional tables are used Almost no locking, if not using myisam tables Built in compression Each table is…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb…_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1…
Comment: Resyncing table on MySQL Slave
July 1, 2008 By 11 Comments
… sync. There may be some data sync issues you discover through replication errors; or perhaps you use mk-table-sync or mk-table-checksum, or MySQL‘s built-in CHECKSUM() function. At any rate, if it’s a small table, mk-table-sync is… a longer time and will (read) lock the master for a longer time if the table is bigger. Still, this is a…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… of sync with internal data dictionary if you crash at wrong time. Transaction Support We have to deal with mix of locks… Innodb specifics well. We could get rid of SQL level table locks and using Innodb internal data dictionary instead of Innodb files… in truly hot way without nasty “FLUSH TABLE WITH READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…the transaction log and the doublewrite buffer, such sync of metadata isn’t needed. Bug Fixed: #… tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (…global_temporary_tables caused the server to crash in some scenarios due to insufficient locking. Fixed by…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.14, including all the bug fixes in it….), but for the transaction log and the doublewrite buffer, such sync of metadata isn’t needed. Bug Fixed: #803270 (Yasufumi Kinoshita…#61790 in MySQL (Alexey Kopytov). Querying global_temporary_tables caused the server to crash in some scenarios due to insufficient locking. Fixed by…
