…use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything … by the query. For example SELECT COUNT(*) FROM links WHERE domain = ‘mysql.com’; will … need to analyze much more rows because it is optimized differently. One of typical …
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
…MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last 10 years I chased first Monty and later Igor with Optimizer…database 100% in RAM (even for Disk tables such MyISAM or Innodb) others keep database…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1… MySQL optimizer currently does not take it into account. For In memory workload index accesses might be faster even if 50% of rows are accessed…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… look at Disk Based databases all data accesses are treated as IOs – it… while to understand if MySQL goes through more rows than it needs…most commonly used RAID level for write intensive database systems, you will … seek time optimizations come from the striping – consider 100GB database which is …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… If you can’t get access to the time of day …files, and build support in the database for one or two capabilities you absolutely… to use it for things that it’s not 100% optimal for. But …more. Finally, PostgreSQL is clearly better for some workloads out-of-the-box than MySQL is, especially for more…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… will contain redundant, but non-accessed data for all configurations of more than one node. This would…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact… over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306…
Post: Getting MySQL to use full key length
January 31, 2007 By 5 Comments
… good reason for removing redundant indexes Here is example from NNSEEK database: mysql> explain SELECT … more as basically the same data is traversed anyway. So how do you force MySQL optimizer…for second query is accessing subset of rows from the first plan so estimation for number of rows for…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…database tables where you can add a where clause and search individual columns, and a ton more “database…for our application here. It should provide the interface and the same access…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
…more please let me know, for my taste these 3 are bad enough so I have not been looking for more…database deals with on disk data it often uses different set of algorithms which are optimized…more sequential. Most of these were designed before SSD era. For example Insert Buffer in MySQL… accesses cause…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… examine query execution on your MySQL server. Queries are logged with timing…For example, sometimes there is no access to the database server. I’ve seen this when access… task you’re trying to optimize or analyze. You might also …is likely to be easier and more reliable than changing the application …
