…row in set (0.00 sec) The final dimension is the flight dimension, which contains the flight numbers…MySQL command line client was used to execute the a script file containing the 11 queries. This same SQL script was used in…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… This table contained some 25 millions of rows and…number of rows it needs to reach the LIMIT Sphinx mysql…MySQL mysql> select max(author_id) as a ,forum_id as f from sptest where num_links=1; +——+—+ | a | f | +——+—+ | NULL | NULL | +——+—+ 1 row in… point but command line language is …
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…in because it was a MySQL command-line client that wasn’t started with -A, and it’s trying to get a list of tables and columns in…TABLES or a number of other commands. Most backup systems that use FLUSH TABLES WITH READ LOCK are performing a relatively short operation inside of…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… asked Fred Linhoss to document a number of new variables in SHOW STATUS, as well as name changes to command-line options and SHOW VARIABLES variables… the number of rows read from XtraDB tables, which means that single-row lookups don’t increment the counters at all. Mark Callaghan found a bug in…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…number of lock structs in row lock hash table is number of row lock structures allocated by all transactions. Note not same as number of locked rows – there are normally many rows…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…command line: $ cat sales.sql create table…number of lines in the order_lines table, three orders of magnitude more quickly than COUNT(*). mysql> select count(*) cnt from order_lines\G *************************** 1. row *************************** cnt: 155187034 1 row in…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…In total raw data is about 55GB. Average amount of rows in…of RAM and Dual Intel(R) Xeon(TM) CPU 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number…mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data/d1/AirData_ontime/${YEAR}_$i.txt.tr’ INTO TABLE…command from command line…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…in place, we can begin. Open command line…in a comma-separated string. [qc_miss, full_scan, full_join, tmp_table, tmp_table…number of microseconds. Can be changed at run time with both SET SESSION and SET GLOBAL. min_examined_row…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…command line as needed. 2) Make an altered copy of…a fair number of tables: $tables = { rows => [1..50], partitions => [ undef ] }; The value in the ‘rows‘ section tells the data generator to produce 50 tables, with sizes from 1 row…
