…number of the flight. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE `ontime_fact` ( `date_id` int(11… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: …
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… to look beyond average performance numbers because they almost never really matter…: CREATE TABLE t_x(i int(11) not null auto_increment primary key…mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m –max-time=900 –num-threads=8 –max…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…int(11) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1 mysql> select count(*) from m; +———-+ | count(*) | +———-+ | 1047684 | +———-+ 1 row in set (0.00 sec) mysql…5130 @ 2.00GHz CPU. This number is per core. In…length: 129 Data_length: 685609952 Max_data_length: 948528873 Index_…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…( `l_orderkey` int(11) NOT NULL DEFAULT ’0′, `l_partkey` int(11) DEFAULT NULL, `l_suppkey` int(11) DEFAULT NULL, `l_linenumber` int(11) …1/3 the number of rows in the table orders (left operand), and so MySQL 5.5 …numbered 1 to 8 are enabled. Optimizer is naive in the sense that it always uses the max…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…_id int auto_increment…mysql> select count(*), min(FlightDate), max(FlightDate) from dim_dateG *************************** 1. row *************************** count(*): 8401 min(FlightDate): 1988-01-01 max…flight numbers …MySQL command line client was used to execute the a script file containing the 11…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…number of simple benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c…Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728 Auto_increment: 4587468 Create_time: 2011-11…
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…36 [ERROR] mysqld got signal 11 ; This could be because you …_buffer_size=524288 max_used_connections=281 max_threads=2002 threads_connected…sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*,… 16:43:39 mysqld_safe Number of processes running now: 0…
