…MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality This is right. With some exception however. For example Innodb…important to fix it. Most applications I have to fix have number of indexing missing…start to crawl. So developing you PHP applications use test database with …
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
… up a wrong index simply because of the wrong estimate. The customer reported that he changed the value of innodb_stats_sample… is used to generate index cardinality estimates which are then in turn used by MySQL to pick and choose indexes and hence is… bug was tracked down to http://bugs.mysql.com/bug.php?id=53761 and was indeed fixed in 5.5 as my tests…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1… bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s… that adaptive hash indexes are not used for primary key lookups or not showed up in “show innodb statusâ€. select * from…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… disk to fill up with logs. You can fix this by modifying shard-query/run_worker to … InnoDB file size on disk: 42GB (with indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql …for 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For …
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores… is reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can… asked what are our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB…
Page: Consulting for MySQL
July 31, 2006 By
…Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb…MySQL build in Full Text Search indexing…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now… for most common cases. Innodb scaling issues are the most common problem (and patches currently available only fix part of it) but… example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items are still open…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 141 Comments
Eddie, this depends on 1. Your MY.CONF settings http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/ 2. The type of table it is — is it MYISAM or INNODB? For InnoDB, you may also fix the INNODB specific settings.
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… on this completely because InnoDB uses a clustered index based on (in …background. > Things are different with MySQL. Good design will help dictate…to fix it. Most > applications I have to fix have number of indexing missing…> to crawl. > So developing you PHP applications use test database with …
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1.35 crashes with Failing assertion: index->type & DICT_CLUSTERED Bug… innodb_flush_neighbours=0†Bug #395783 in Percona-XtraDB: “main.innodb_bug42101 fails on 5.1.36†This fixes also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php…
