…database performance that dropped through the floor (to the point of…of the statement corresponding to the columns in the secondary index, and they were coming in at a rate of…in which they were defined, and the PRIMARY KEY is always going to be considered as being defined first. So, MySQL…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…of importance I would recommend using Percona Server with enabled expand_fast_index…in future MySQL versions also MyISAM tables are essentially at the state they were in MySQL…drop in…database binary incompatible with MySQL. Our focus on compatibility is indeed so high there are number of…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…In MySQL 5.6 the default value of…of lineorder in the buffer pool and the other secondary indexes have been pushed out of the buffer pool. mysql…DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD_DATABASE_PAGES: 2624 * OLD_DATABASE_PAGES: 2623 MODIFIED_DATABASE_PAGES: 0 * MODIFIED_DATABASE…DROP…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
…database=test # ######################################################################## # test.t # ######################################################################## # name_2 is a left-prefix of name_4 [...] # To remove this duplicate index, execute: ALTER TABLE `test`.`t` DROP INDEX…
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: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…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: 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 19 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 …
