… decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The entire main db…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… usage, and it can be bought with an optional tech support agreement. OpenIndiana is desktop oriented, and not quite stable, IMHO…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: How to change innodb_log_file_size safely
June 6, 2013 By 17 Comments
I followed the article, mysql is working fine now, but i dont see any innodb tables in phpmyadmin, when “check table” it says table does not exist
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… do. First, we need to make sure our environment will support multicast. This is a question for your network guys and…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int(10…_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` int(10…_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… Intel DC S3700 SSDs. BTW, Is percona ever going to support OmniOS?
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…
