…MySQL manual, especially the option and variable reference table…table_sizeblogpercona.commanual max_insert…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… limits as you can’t use mysql_num_rows() and mysql_data_seek() if you use …summary tables and original tables on the same server which can limit your scalability. Using FEDERATED Tables can… do INSERT … SELECT to the temporary table with auto_increment column and fetch data from this table using…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…insert_buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE…tables. It also means user having CREATE TABLE privilege should be able to run MySQL…table which is held until table is closed. Federated…
