…with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with… with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read… write cache use. Even the fairly slow gzip-1 mode works well. The …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…2.1.10) then retire. 2.2 is largely backward-compatible with 2.1, but some tools were changed …with PXC and figure out which tools work with it and how. There’s still one noticeable omission: pt-table…. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… star join with dimention tables being small it would not slow things down too much. On other hand join of few large tables, which is completely disk bound can be very slow. One…% or rows or less full table scan may be faster. Avoid joins to large tables Joining of large data sets using nested loops is…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… when working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data… will lock tables for very long time and Innodb can get too many old row versions to deal with which can slow down… may not apply to large data set so you need to re-test your “final design” again with large set. One thing I…
Post: More on table_cache
November 26, 2009 By 7 Comments
…. With Table Cache of 2000 I got about 16400 selects/sec with Table Cache of 20000 13500 selects/sec. So there is some slow down… scenario for misses hit from large table_cache is faster. There are also possible optimization for “hit” path with large table cache though this should only affect someone who runs really large amount of simple queries – this is when opening table can…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… auto_increment functionality This is right. With some > exception however. For example Innodb tables do internal full table > lock if auto_increment is… table however so you do > not have all these problems with loosing data etc. Read more in my > Why MySQL Could be slow with Large Tables…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…_increment functionality This is right. With some exception however. For example Innodb tables do internal full table lock if auto_increment is used… by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens of thousands of tables per… table however so you do not have all these problems with loosing data etc. Read more in my Why MySQL Could be slow with Large Tables…
Comment: Why MySQL could be slow with large tables ?
May 23, 2007 By 141 Comments
This article is not about MySQL being slow at large tables. We have applications with many billions of rows and Terabytes of data in MySQL. This article is about typical mistakes people are doing to get their MySQL running slow with large tables. MySQL can store XML in Text field.
Comment: Small things are better
July 6, 2007 By 15 Comments
…-be-slow-with-large-tables/ I was just very surprised when reading some of the comments that an alter table on a 500GB (say) table could take up to 2 days!! I have my tables as separate files/table (which I…’t get the statement regarding the column information NOT stored with each row. (can you point me to other resource to…
Comment: Why MySQL could be slow with large tables ?
June 10, 2006 By 141 Comments
…Why MySQL could be slow with large tables ?: “If you’ve been reading enough database related forums, mailing … of the users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What could …
