…and memory is what really …of instance storage 64-bit …MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is…ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE…drop was mainly caused…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…. NDB cluster is yet another example I’d put in here. I do not feel it is ready as main storage engine for most of applications just yet but for some cases it may be handy. The fact which is… this point is the fact MySQL has only Storage Engine pluggable but SQL layer is kind of fixed same for all. This dramatically limits what you…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what is…me list Transactional Storage Engines I heard of on Conference and main impression about…. soon. Falcon The Storage Engine which is developed in MySQL. The performance we see…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… get to the point what we’re comparing here – it is mainly DRBD to MySQL Replication based techniques (lets leave MySQL Cluster and Continnuent alone… work. This is not to mention other things you can do with MySQL Replication, such as filtered replication or cross storage engine replication, though…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… DB_TYPE. i.e. what storage engine it is. We can ignore the upper limit on number of storage engines for MySQL and understanding the relationship between… work out which Storage Engine to ask to drop the table. The main consequence of this bit of code is that MySQL may cause unnecessary…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… hire someone who could focus on such tasks. What are we expecting from MySQL Performance Engineer ? Such person should have a passion for… to find the truth source code is your best friend. One should have good MySQL knowledge including main storage engines, and best have experience using…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…systems would work as well. What is really needed is ability to create atomic …storage engines. Fast Backup You simply do file copy in the binary form so it is…MySQL Server to continue, which is done by running UNLOCK TABLES or simply closing connection. 5) Mount backup Filesystem: mount /dev/Main…
Post: MySQL Architecture meeting at Google
April 24, 2008 By 2 Comments
…MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine…storage engines with MySQL which was previously hard because of defined row by row retrieval interface and nested loops used for joins. However what…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage engine…MySQL server – in particular Optimizer may have harder time because costs between storage engines…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… is the right approach to this problem. The reasons are – this formula is very complex nowadays and what is… Watch for these especially now with many storage engines being released for MySQL by various parties. I do not…if you have something to add). But the main point is – there are a lot of memory …
