… in the batch performance improved, especially for network tests, however going to batches of 100 and 1000 values performance started to degrade… is something nasty going on on Innodb level, so I tried running the test with MyISAM tables instead. The process completed in… may be kind of performance bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… Innodb tables will simply result in errors. The other way I’ve seen it beating up people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used, so I’ve…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…. That would clearly save indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix adaptive hashing would… Innodb Table id2 is not needed pas part of second key as PRIMARY key is appended to it internally anyway. For MyISAM… “`id` = 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… instead of expected performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices… MySQL Version to get slower plan instead of new one getting faster. Check stats sampling settings such as innodb-stats-method and myisam…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
…Last time I worked with similar system it used MyISAM and the system was built using multiple tables. …MySQL 5.5 (frankly I did not try Percona Server 5.1 in this case) With MySQL 5.1 and Innodb… well as room for more performance optimizations. Dmitri has good suggestions on tuning MySQL 5.5 and this …
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
…solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance …of InnoDB table files and transactional logs. This is going to be fully OpenSource, GPL licensed backup solution for MySQL (MyISAM and InnoDB for…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… SubQueries avoided for MySQL) so do not just compare it directly. It also does not mention if Innodb or MyISAM tables are used…/Threads and stays at this level at higher concurrency. MySQL with Innodb shows its ugly face and drops pretty quickly as concurrency… comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes second and older…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
…I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) … was one major issue, the tables where MyISAM and this is not really recommended with …slave convert the table in InnoDB configure and start the replication finally perform SST on the other nodes…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… indexing within MyISAM and Innodb with a side of Partitioning. I’d expect folks interested in efficient schema design for high performance to… when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) Percona XtraDB Cluster…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/ http://www.mysqlperformanceblog.com/2009… to load data and run queries against available engines: MySQL MyISAM / InnoDB (to have reference results) InfoBright InfiniDB MonetDB LucidDB Greenplum…
