…raw data from the BTS into a single database table called…mysql> select count(*), count(distinct UniqueCarrier) from dim_flightG *************************** 1. row *************************** count(*): 58625 count(… memory was selected. The selected operating system was Fedora 14. Oracle VirtualBox…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
…> explain select count(*) from trunc where i=4147483647; +—-+————-+——-+——+—————+——+———+——-+——-+————————–+ | id | select_type | table | type … them… so inserts into one table would happen…of hours. Thank you, Oracle team, for having this…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…respect and what works well for Oracle,MS SQL, PostgreSQL may not work…Buffers First thing you need to take into account is the fact – situation …select count(pad) from large; +————+ | count(pad) | +————+ | 31457280 | +————+ 1 row in set (4 min 58.63 sec) mysql> select count…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… comments READ_PK_POINT Query: SELECT name FROM $tableName WHERE id = %d READ_KEY_POINT Query: SELECT name FROM $tableName WHERE country…: SELECT count(id) FROM $tableName WHERE id between %d and %d The same comment as for previous query. READ_KEY_RANGE Query: SELECT… do not know Oracle plans about. It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
September 20, 2007 By 117 Comments
… called ‘horilla’ in MySQL forums: Oracle, DB2. Want to compare test results for a simple query SELECT COUNT(*) FROM …? Theoretically, InnoDB is faster… of physical data files format (in InnoDB, data is written into fixed-size blocks; in MyISAM, data is usually written at…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… MySQL Team at Oracle, MariaDB team or Drizzle team to take a look into solving this …might want to look at Prepared_stmt_count to see how many prepared statements are…tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1….
