… and there really no cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` int(…your browser to zero in on a particular table Constraints – lists the explicit Foreign Key constraints in the database (this does…are some ERD tools you use and how do they compare with SchemaSpy? Feel…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… see how to…from the t table s1> select count(*) from t; +———-+ | count(*) …your last chance is to be able to recover data from the crashed master, but that’s another story). In…Does it mean that we cannot easily recover the data with mysqlbinlog? There is a solution of course, but very poor in…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… review them. Snapshots ZFS does snapshot, like LVM but…of snapshots. With LVM, your IO performance drops to …interesting to speed up point in time recovery when you …InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables…slow gzip-1 mode works well. The tpcc database, …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… topology. However you should keep in mind some limitations of the current…. The manual describes very nicely how to switch to GTID-based replication…create a new table on the master: mysql> create table test.t (id … replication can be tricky if your application does not easily tolerate downtime or…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… were not found in 32-bit builds due to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause… and thus does not need to read any bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION…
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: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
… Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) …range and thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can…today is that sometimes you find unexpected differences in performance like this, so it pays to test… the tables and columns. It turned out this solution was 150x faster for this case, so your suggestion…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. I have a large innodb database, do I have to export databases from mysql and import them in Percona server or can… using CentOS for my servers but i develop apps in windows, do you think percona will release windows version as well? Thanks
