… multiple GB MyISAM table few times, though Table Locks is probably the …indexes which are not supported for Innodb tables. So what can you do ? Leave Tables…all tables at once. In some cases full text search is used on secondary small tables… to have MyISAM table anywhere. We use Sphinx in a lot …
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/…all sorts of dirty tricks and neat ideas with each other. Nothing is off the table. Queries can be rewritten. Indexes…Sphinx, or something like that.) In the common case, though, a query simply needs a rewrite or a new index…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… summary tables, significant schema changes, use of replication, caching, using memcached, sphinx, … add has higher risks – adding index you rarely would add bugs … to have more bugs on all levels starting from Hardware and … others (like excessive row level locks) may be caused by application design…
