… with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes… is brewing. Or if you watch your MySQL server’s memory usage and you see that it’s… that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL… key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… looking for a lot. This will cause data clustering done by these columns which can be helpful … fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with … of indexes. The indexes can’t fit in memory anymore. How does this affect performance? A: Typically …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory workload index accesses might be faster… radom IO if index ranges are scanned. There are also clustered keys in Innodb which combine index access with data access… with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these…MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory…can get advantage of Innodb properties – clustering by primary key, having primary key …
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool …add index live as it can now do on Cluster ? Is it expected to rebuild index by sort …fields can’t work with in memory temporary table. The other thing – since MySQL 4.1 sorting can be …
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL…MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in MySQL…of InnoDB work, including clustered indexes, insert buffer, …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. … you have any limitation in resources in a cluster (cpu, memory, disk, power,etc) then split the … which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to… throughput over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 read…-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… In Memory storage engines vs Distributed ones. Trying to handle all different cases in Optimizer – such as in memory nature of MEMORY storage engine, clustering…transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to…
