… ? The reason is normally table design and understanding inner works of MySQL. If you design your data wisely considering what MySQL can do and what… to memory before join so there is no random IO needed to populate the caches. With proper application architecture and table design you…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… which appeared in MySQL 4.0 Query Cache was designed to work with single core systems and relatively small memory amounts, both of… given table. Instead we could track versions for tables (increment each time table is updated) and check whenever version matches for all tables on…. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… in memory. Memory Tables If you can create memory tables you can create any number of them and even though there is max_heap_table_size…_table_size or max_prepared_stmt_count are designed to protect from typical application mistakes not from someone intentionally trying to bring MySQL…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM if… which affects all tables but it was designed for MyISAM tables. It makes little sense to use it with Innodb tables for example. Note…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
….000 of rows which is relatively fast for this (in memory) table but will become unacceptable as soon as you get to…-generated table and use the join to retrieve the rows from original table: mysql> show create table dl \G *************************** 1. row *************************** Table: dl Create Table: CREATE TABLE… question to check with MySQL Optimizer team 
UPDATE: I just heard back from Igor Babaev saying it was designed this way (because…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
…SHOW VARIABLES value, and settings done by changing tables rather than command line options (like much …to especially in system like MySQL where a lot of things have been designed to be independent …or about other components in MySQL which makes it hard to manage memory, a lot of resource allocation…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…design can start to have issues as the data size increases and you blow through your available memory… this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions … email address ). Seems simple enough right? My two tables each contain 5M rows of data. let’…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… from this table are invalidated at once. Most of them quite likely would not have change their result set but MySQL has… usable memory – Queries are constantly being invalidated from query cache by table updates, this means number of queries in cache and memory used… is still not as fast as specially designed systems such as memcached or local shared memory. It can’t retrieve multiple objects…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… but it is extremely important for MySQL Performance Optimization. In fact I probably …designing your application think what kind of application are you designing ? Can you make it CPU bound/In memory…locality) also becomes very important – if Innodb tables are used having simply auto_increment …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…need 100K of memory not 8-16M as you need with page cache. There are design techniques …should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical … feature, for example changing default value needs table rebuild even though for other storage engines …
