… I was looking for has not changed. When writing slow …in spite of this. You could still get a report of …’s mine: cat <<'GO' | mysql –raw –skip-column-names –quick –silent –no-auto-…Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… the time taken by MySQL 5.5 to finish the query on IO bound workload so that it could fit well in… on an indexed column The SQL used for this test together with its EXPLAIN output as returned by MySQL 5.5 is… scans of the PK to fetch the columns that are not part of the secondary key. Even though MySQL 5.6 uses MRR to…
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… each team could be cross tested with each database/api (for example if the 3364 opm mysql result … the perl api to communicate with mysql (DBI/DBD::mysql) there is not only one way to fire a …348,140 fetches per second. A boost of 680% in the question of fetching just a single column from a mysql …
Comment: Four ways to optimize paginated displays
September 24, 2008 By 27 Comments
… usually requires as little time as possible for mySQL will usually consult the index fetching the primary key constituents and will, most… little time as it could take; mySQL can fetch the record information for the rows required as efficiently as it could ( i.e by…, or not { 1. SELECT id FROM table ORDER BY foo LIMIT offset, size + 1 2. Collect ids(i.e columns that comprise…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, …not happening ie your VMSTAT “si/so” columns are zero on Linux. Couple of swaps per minute would not…I have one IO to fetch page data swapped out. This…while doing IO while there could be locks set while accessing…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… individual rows rather than sorting; OPTIMIZE TABLE could be faster if secondary indexes were temporarily … mysql> SET profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE t ADD COLUMN …method, because it does not have to do random disk seeks to fetch secondary index pages to …
