…MySQL 3.23 when there would only handful of places where memory could be allocated but it is a lot larger problems with MySQL…for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you’re using large… valgrind are too slow to run in …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
… you could be reading the same page multiple times. Consider if you have a small buffer pool and a very large number of rows from table2 that do not fit into the buffer pool, then worst case you could be reading… is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table above and the values for…
Post: Why MySQL could be slow with large tables ?
… number of index lookups which could be random accesses. This problem exists for all kinds of applications, however for OLTP applications with queries examining… join of few large tables, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL is lack…
Post: Database problems in MySQL/PHP Applications
…, your ALTER TABLE or OPTIMIZE TABLE now locks small table for few seconds rather than giant 100GB table for few hours so can be done pretty much…. Read more in my Why MySQL Could be slow with Large Tables article. 5. The n+1 pattern This probably should rather be called Not using Join…
Comment: Database problems in MySQL/PHP Applications
…, your ALTER TABLE or OPTIMIZE TABLE > now locks small table for few seconds rather than giant 100GB table > for few hours so can be done pretty much… 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…
Post: Slow DROP TABLE
…mysql> drop table large_table; Query OK, 0 rows affected (0.29 sec) A better solution through MySQL internals could be to simulate the table…
Post: MySQL: what read_buffer_size value is optimal ?
… for large table you should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL…. It could be OS has to split large requests into multiple ones submitting them to device which slows things down or it could be something else…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
…and could be used by something else. True in theory but in practice for years…tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM if they are large… slow query log or general log. flush, flush_time Flushing (closing) of tables …
Post: Read Buffers, mmap, malloc and MySQL Performance
…for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well could be… times slow …large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large…table or LIMIT 10 in full table scan query you well may not need large…
Post: MySQL extensions for hosting
…being used at all and could be candidates for dropping. All the patch features will surely be a great help for…mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table…

