…a “flush tables with read lock” and the flush operation will take some time to complete. Compression ZFS…raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an …
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… features that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use… and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up today!
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…type of log now (slow, general, binary, and …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL… of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces… would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces… dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from … would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs…
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: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in …% compatible to standard format as TIME type which is used to store query execution time and lock time does not store fractions of the second. Today I’ve got some time to play with table based slow query…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…Schema: sbtest Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent: 0 Rows_examined:…I get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root[root]…found and returned up to the top level MySQL part for processing are counted the Rows_examined…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
…, time is 02:28:05, feels [like] almost summer! | +———————————————————-+ 1 row in set (0.00 sec) host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[me] @ localhost [] # Thread_id: 3432 Schema: test # Query_time: 0.000695 Lock_time: 0…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… for MySQL process: root@ubuntu:/var/log/mysql# cat…time spent. This is because IO handling requires significant number of CPU. With Percona Server, enabled full query logging and log_slow…======= ======= ======= ======= # Count 98 1753697 # Exec time 52 4337s 71us 466ms 2ms 12ms 7ms 176us # Lock time…
