…structure with needed index and populate it with insert… select statement as you need it. One little … in the end you can do SELECT * FROM (SELECT * FROM slow_log ORDER BY start_time DESC LIMIT… found even if I convert table to MyISAM, disable concurrent inserts and run long reporting query on …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… ’0′ ‘Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select‘, ’11′ ‘Com_kill’, ’47′ ‘…Select_range’, ’5683551′ ‘Select_range_check’, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF’ ‘Slow…=32M # Only for MyISAM which isnt used. …
Comment: Why MySQL could be slow with large tables ?
October 17, 2011 By 141 Comments
… have 10GB MYISAM table . My website has about 1 million hits daily . Under such a heavy load the SELECT and inserts get slowed . I have the below solutions in mind : 1. Move to innodb engine ( but i fear my selects would get slowed , as the % of selects are much higher in my application ) 2…
Comment: Should you move from MyISAM to Innodb ?
January 21, 2009 By 59 Comments
…. Removing the compression helps for insert performance. Create table and alter table statements are very slow too if we have partitions (indep. from compression). Without partitions, the innodb plugin was o.k., slower than MYISAM (incl. inserts, selects…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert (while Selects are running) for MyISAM… affect Innodb and other storage engines transaction logs, slow query log or general log. flush, flush_time …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1,000 2. UPDATES: 200 3. SELECTS: 1 million Since this is a predominantly SELECTed table, I went for MYISAM. My my… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records are stored in… select queries, as in this case TokuDB has to read and decompress big portion of data. – Despite Inserts…of random IO, waste of RAM memory and slow inserts. This is where I think Tokutek appears to…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… because deletes are awfully slow and my partitioned table …_Week7_T, ObjectInstances_Week8_T) INSERT_METHOD=FIRST; (SEVEN more … ENGINE=MyISAM; 3 main SELECTS are ( replaced actual fields with “*” ): ##————————————————– SELECT o1.* FROM ObjectInstances_T o1 ,(SELECT…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… compression for its indexes, as MyISAM has which in certain cases makes …Insert buffer for delete. For Insert operation Innodb uses nice tecnique called Insert Buffer which speeds up inserts… row is going to be slow. For medium sized blobs it … primary key – you can simply select not to cluster by it …
