… is no MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table. mysql> show processlist… SELECT queries to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
Many in the MySQL community are snobbish about using MyISAM (not using it that is) and that if not using InnoDB you aren…, InnoDB brings a lot of cons to the table which are missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB… not use MyISAM. If none of the above apply, then you get the benefits of MyISAM which includes consistently faster query speeds, tables…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…! But first, what’s new with the MySQL query cache? You may know that it still … be able to see that you had MyISAM problems really easily when you had a …InnoDB Architecture and Performance Optimization. These detailed presentations will give you the hands-on experience you need to take your MySQL…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… PK values. MyISAM scales very bad, and reason is the same as for READ_KEY_POINT queries. InnoDB is better than MyISAM by 2-26 times and than Falcon by 1.64 – 3.85 times. READ_PK_RANGE_INDEX Query…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… KEY (`id`) -> ) ENGINE=MYISAM; Query OK, 0 rows affected (0.03 sec) mysql> insert into test2 select * from test; Query OK, 229376 rows affected…_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best … of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but …-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL, although we’…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… fragmentation which affects performance of full table scan. Not all queries are going to be affected same way, for example point… used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log… scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb suffers fragmentation less…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… is something nasty going on on Innodb level, so I tried running the test with MyISAM tables instead. The process completed in… && trx->mysql_query_str) { /* Scan the MySQL query string; check if SELECT is the first word there */ ibool success; dict_accept(*trx->mysql_query_str, “SELECT…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-engine innodb –myisam…
