… the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot of random data that … it will be caught by ZFS and the data will be read from the other drive in the mirror. … ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema…never-ending stream of queries to playback. Read-only playback Using the –session-init-…, UPDATEs, and DELETEs from corrupting the data on the standby server. You will …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…If there are thousands of tables and slow IO then XtraBackup can spend …Percona XtraBackup didn’t initialize per-thread data in the log copying thread … been changed from abstract mysql to real /usr/bin/mysql file, because rpm … still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer …If there are thousands of tables and slow IO then XtraBackup can spend … still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail…. innobackupex wasn’t handling the innodb_data_file_path option which could cause…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you …slow query log in production while tuning one of the systems. It is pretty nice to be able to work with data… from it (or do any write queries) only read access is possible, with exception of TRUNCATE query….
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-…IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave is connecting using CHANGE… How to restore a slave in a good and slow way The good way is mysqldump again. We …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler_read_prevblogpercona.commanual Handler_read_rndblogpercona.commanual Handler_read…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… is please read this section here in the MySQL manual. Let’s start off with having a look at the Meta Data Locking… | 0.000005 | | sending cached result to clien | 0.000011 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | +——————————–+———-+ 8 rows in…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… 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… good setting for many workloads so unless you have repeatable reads requirement consider using this. sort_buffer_size = 32k – It is…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… the file-based logs on the server. I read the logging code in MySQL 5.6.10 source, in file sql/log…,Long Data,Close stmt,Reset stmt,Set option,Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow…
