… full tables and in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export…/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0…CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS…mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used… Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write… the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, … Server for MySQL 5.6.11-60.3 are available in our online documentation….
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that was introduced with the fix for bug #710799. This regression caused mysql… temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL 5.5.31-30.3 are available in our…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE…InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) In previous versions of MySQL…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…, honestly, why would you ever want to use MySQL on top of something like that? I … up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read …it is surprisingly cheap. In fact the best tpcc results I got were when using compression. I … on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
