… case you can use trick mentioned in the presentation to convert sort to the union for small ranges. Q: In the… Innodb Table id2 is not needed pas part of second key as PRIMARY key is appended to it internally anyway. For MyISAM… benefit to convert BETWEEN into IN-ranges in some cases for better index usage. Q: Is the b+ tree innodb index a…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… changes, replication etc. Q: Is it possible to move MyISAM to Innodb through plain ALTER TABLE statements? Yes. This is exactly how… to inject MySQL 5.0 in between so it will convert binary log events, as described here yet it does not… storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used, so I’ve seen people thinking they have converted things to Innodb while they really did not because it was substituted back to MyISAM. I do not…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive operation… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… second while converting table to MyISAM I get about 600 deletes per second and about 4000 deletes per second for Innodb (with log… surprised to see MyISAM being significantly slower than Innodb – in this case the table is small and fully fits in Innodb Buffer Pool… was also disabled, meaning Innodb could delay writes and do all the changes directly in memory. MyISAM however had to perform number…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… counters as they are implemented the most trivial way – they convert read load to write load. When you would simply fetch… flushes. If you have innodb_flush_log_at_trx_commit=0 or 2 or if you use MyISAM tables you would not have the problem, if you have innodb_flush_log_at_trx_commit…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments… (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add …works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… with key value – which are offsets for MyISAM and primary key values for Innodb or storing full data which is being retrieved… used and the fields which are being length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can… sometime to see how it really impacts performance both for MyISAM and Innodb.
Comment: What's the recommended MySQL version?
February 8, 2012 By 24 Comments
… found a blag post on upgrading from MyISAM to InnoDB: http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same…/ directory after each change to InnoDB parameters. I stopped mysqld, removed the files, commented out the innodb_force_recovery, restarted mysqld, viola…
Comment: How fast can you sort data with MySQL ?
September 24, 2007 By 26 Comments
… feeding it to myisam then converting, or feeding to myisam then sort .. order by .. insert, or feeding un-ordered PK to innodb directly then doing alter table engine=innodb…
