(mysql.info.gz) Update speed

Info Catalog

(mysql.info.gz) Insert speed

(mysql.info.gz) Query Speed

(mysql.info.gz) Delete speed

 
 7.2.15 Speed of `UPDATE' Statements
 -----------------------------------
 
 Update statements are optimized as a `SELECT' query with the additional
 overhead of a write. The speed of the write depends on the amount of
 data being updated and the number of indexes that are updated.  Indexes
 that are not changed will not be updated.
 
 Also, another way to get fast updates is to delay updates and then do
 many updates in a row later. Doing many updates in a row is much quicker
 than doing one at a time if you lock the table.
 
 Note that for a `MyISAM' table that uses dynamic record format,
 updating a record to a longer total length may split the record.  If
 you do this often, it is very important to use `OPTIMIZE TABLE'
 occasionally.   `OPTIMIZE TABLE' OPTIMIZE TABLE.
 

Info Catalog

(mysql.info.gz) Insert speed

(mysql.info.gz) Query Speed

(mysql.info.gz) Delete speed