…,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. Deciding…
Comment: Small things are better
July 6, 2007 By 15 Comments
…/09/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 to… 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: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…with them as it could be which makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL…table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…large…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…large table you should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL…with good explanation. It could be OS has to split large requests into multiple ones submitting them to device which slows things down or it could be…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…be crashing , failing to execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you could…be large if you have a lot of tables. It also means user having CREATE TABLE privilege should be able to run MySQL…with large Blobs (your max_allowed_packet is large…
