… a mysql.properties file While not explicitly required, I prefer to create this once so that the command line is shorter and neater. In… tabs: Tables – Names, number of children, parents, count of columns, row counts, and comments — a great way for a high level overview of the table sizes and …
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…in a MySQL table. So what’s the maximum number of columns in a MySQL table? Well.. I tried a few things before I settled on the following (perl) program (accepts command line…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…number 380166807992 1 row in set (0.41 sec) 1 row in set (1 min 0.00 sec) Log sequence number 380170274979 1 row in…of the queries.log file, you will see a copy of your session. Conclusion The mysql command line client is not as glossy as most of…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…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 30 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 20 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…
