… completely because InnoDB uses a clustered index based on (in order) … background. > Things are different with MySQL. Good design will help dictate … > becomes managable, your ALTER TABLE or OPTIMIZE TABLE > now locks small table … take up tremendous amounts of memory and disk. Because indexes are …
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
…do well for this purpose, of course if they optimize cache to avoid caching same data by same nodes…a chance. Speaking about NDB cluster – yes it has data on the disk in MySQL 5.1 – I however … OS memory or in MySQL cached. If you’re getting CPU bound you should look for caching data in process memory…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
…, finding Master with many slaves more optimal. There is surely room for master-…MySQL replication is single thread it might be not long before it will be unable to keep up. Waste of cache memory… other installations have similar sizes. MMM Cluster support Master with multiple slaves configuration as…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… so this file fits in memory. In general PBXT seems to be very optimized for Blobs handling and…) Falcon. It is worth to note MySQL official marketing never position MySQL as such per say (for obvious …if performance will be adequate. Solid also has clustering by primary key and unlike Innodb has key …
Comment: Countless storage engines
May 3, 2007 By 6 Comments
… publicly available yet. It is also worth noticing MySQL world is not free (as in beer) any … to memory ratio when Falcon optimizations will allow it to excel. Ie Assume we have 16GB of memory and …clustered you could use Falcon with a large page and row cache and benefit from the better use of memory…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…. On the benefits side we usually see clustering by primary key, caching data, higher concurrency, … (especially if data size is close to memory size), generally slower writes, slower blob handling, … not so common paths in the MySQL server – in particular Optimizer may have harder time because …
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
… is when data size is small enough to fit in memory and so buffer pool. I tested very simple table, having… joins are very fast as data is clustered together with index and generally highly optimized Innodb builds hash indexes which helps to… for MySQL to request next row matching index Note: This applies to CPU bound workload with all content fitting in memory. In…
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
… if you fit everything in memory memcache is about 2x-2.5x better than MySQL for primary key lookups. Am … automatic clustering etc but it is very simple which is cool. Finally… I should note the direct implementation in MySQL … SSDs ? Can it be simple solution instead of using “optimized” systems ?
Post: Percona is hiring a consultant
December 16, 2009 By 7 Comments
… to be able to do anything from optimizing difficult queries to moving high-volume …to answer questions about its internals from memory, such as “how does the insert buffer … desirable skills include: Non-core MySQL technologies: XtraDB, Xtrabackup, NDB Cluster, third-party storage engines and …
Comment: Sharding and Time Base Partitioning
March 15, 2008 By 12 Comments
… honestly think some things are out of the scope of mysql, I think you’re application should be smart enough to…) have built in cache (file, memory, mcache, etc) support you just need to use it. MySQL is very powerful and while I… and tables as a cluster and provide easy to use methods for moving data (tables and databases) for optimization of access might…
