…your primary server so you can perform point in time recovery. Store … server. For example in xtrabackup 2.0.5+, the time taken for… backups between myisam and innodb tables. Global read lock only held until myisam tables are… from github, Mostly for multi-part upload support. This prevents us …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…clearly save indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix …Innodb Table id2 is not needed pas part of second key as PRIMARY key is appended to it internally anyway. For MyISAM… expression and the result will be IN(-2) which is not what you’re looking for…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… the database and application performance. Over time msl patch …-pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector –param=ssp-…to check the platform specific part of the reference manual …engines used (InnoDB will take significantly longer to close than MyISAM), database configuration…
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
…as in reality only 1 (max 2) partitions got data inserted to them…index on column C – the “UPDATE” part of INSERT ON DUPLICATE KEY … Both MyISAM and Innodb are affected by this issue. The Update path for MyISAM …cost you. From this benchmarks the performance remains reasonable with about 100 partitions…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance…INNODB_OPEN_FILES | 300 | 2000 | | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE…Innodb table but getting MyISAM because Innodb…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and … months of work (2) MyISAM toasts InnoDB in read performance is a myth. InnoDB rules for now with low concurrency. Eagerly waiting for part II. Tagged…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM and Innodb in… is speaking about seeks but it is only part of the latency. Disk rotation is another big … even if you run with innodb_flush_logs_at_trx_commit=2 you still do not solve all …
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… ranges MySQL will use both key parts. Hence if you change this predicate…will quite likely see improved query performance. Beware however of large nested … read data Some storage engines (MyISAM and Innodb included) can also use index to…is not simply savings of having 2 reads per index entry instead …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…plugins instead of patches. 2. Be Scalable I’…Innodb scaling issues are the most common problem (and patches currently available only fix part of it) but far from being only problem. There are fair amount of issues with MyISAM…asynchronous. To offer great performance on distributed systems, …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…storage in terms of performance management – the SAN is shared resource (has more or less shared parts) so it …executed having only one IO at the time if Innodb or MyISAM tables are used. There is read-ahead … Sure it needs double the storage but you get 2 copies of data too and using SAN you …
