…in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database…index header (most complex part of opening and closing MyISAM table) can happen by OS in…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading an indexed…index creation uses temporary files in tmpdir for all indexes being created. So make sure you have enough tmpdir space when using expand_fast_index…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…databases Many people assume their application is difficult or somehow different, and that we need all kinds of…in mysql…of the analysis for last. You cannot consider any one of these factors (schema, queries, indexing) in…
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
…INDEXES are relevant. These are usual InnoDB tables, but they’re hidden from a user(you can see them in information_scheme database in…in < MySQL-4.0.14 space id the page belongs to (== 0) but in later versions the ‘new’ checksum of…in InnoDB dictionary for table test/t2 In this case you need to drop…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…of data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL…of some of the tactics I’ve used to successfully scale large click-processing and other types of event-analysis databases. In…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of…index are the most active or which are not being used at all and could be candidates for dropping. All… block users having huge spike in MySQL usage Personally I would see …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…all indexes are created equal. Some indexes may be placed in sorted way or pages placed in random places – this may affect index…In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…of the input data. The ICE schema was discussed in the comments of the last post. ICE does not have any indexes…(but not the ontime_fact data): DROP TABLE IF EXISTS `dim_airport`; CREATE TABLE `…COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show …
Post: Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
…Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of…in MySQL, it’s best to show some execution plans on dummy data: EXPLAIN SELECT * FROM coordinates FORCE INDEX…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…index of dispersion, an amazingly useful metric for discovering periods of poor performance), and more. Analyze the distribution of…in most systems such as database…in MySQL servers I work with when they’re running a simple read-mostly workload with most data in…
