…could be allocated but it is a lot larger problems with MySQL 5.5 with…MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables…with memory leaks is rather complicated as good tools to detect memory leaks like valgrind are too slow…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…could be reading the same page multiple times. Consider if you have a small buffer pool and a very large…hash table will be created based on the columns of table t1 that are two be used to join rows with table… slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…,Technocarati MySQL has installations with many billions of rows and delivers great performance. What could be the reason ? The reason is normally table design and…have 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…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… cached lookup 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 article. 5. The n+1 pattern This probably should rather be called…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… are different with MySQL. Good design will help dictate how many tables are required in order to get the job done. To be good… cached lookup 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 article…
Comment: Small things are better
July 6, 2007 By 15 Comments
…/why-mysql-could-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…
Comment: Why MySQL could be slow with large tables ?
June 10, 2006 By 139 Comments
…Why MySQL could be slow with large tables ?: “If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable… well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What could be the…
Comment: Why MySQL could be slow with large tables ?
February 25, 2009 By 139 Comments
[...] Why MySQL could be slow with large tables [...]
Post: Slow DROP TABLE
June 16, 2009 By 20 Comments
…MySQL into removing smaller files with DROP TABLE to minimize the effect, such as: TRUNCATE TABLE large_table; ALTER TABLE large_table ENGINE=…; DROP TABLE large_table; TRUNCATE TABLE large_table; OPTIMIZE TABLE large_table; DROP TABLE large_table…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…large log file generated. Another thing that we normally do is set the variable log_slow…MySQL server, you would see an entry like this in the slow… Server with log_slow_verbosity=full…tables are probably being created because of blob columns being accessed by the query. So a quick fix here could be…
