… server, thus resulting in less binary log data being sent down to the lower…MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL… try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_…_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=… tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…locks are held for modifications until the transaction commits and that takes an fsync to the redo log… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL … ordering for the transaction, so by the time the original node gets acknowledgement of…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 …[.] rw_lock_x_lock_func(rw_lock_t*, unsigned long, char const*, unsigned long) | — rw_lock_x_lock_func(rw_lock_t…= O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… series at the time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6… the log copying thread. Percona XtraBackup now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL… TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…demand. Time interval between checks done by log copying thread is now configurable by innobackupex –log-copy… fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G…LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 98 1753697 # Exec time 52 4337s 71us 466ms 2ms 12ms 7ms 176us # Lock time 96 69s 17us 3ms 39us…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…: sbtest Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent: 0 Rows_examined:…get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost …found and returned up to the top level MySQL part for processing are counted the Rows_…
