… get time metrics for particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G… it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… correctly, you need to add these lines: if (length($line) > 1) { while (substr($line,-2,1) eq “\\”) { $line .= ; } } right at the beginning of the…, rather then time’ing the mysql commands in the loop (second shell), I added –show-warnings to the command line, because otherwise things may…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load… get time metrics for particular IO block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 10 Comments
How many of you use the mysql command-line client? And did you know about the pager command you can give it? It’s pretty useful. It tells mysql to pipe the output of your commands through… at the command line in the traditional Unix pipe-and-filter manner. What sort of goodies can we think of here? mysql> pager…
Post: Logging your MySQL command line client sessions
July 8, 2008 By 9 Comments
… about very helpful but often forgotten about “Pager” feature of command line client. There is another one which falls into the same… done on production. Moreover you can put tee=/logs/mysql.log in “mysql” section in my.cnf to have logging enabled automatically… the client. If you’re looking to log session beyond MySQL command line client you can check out “script” tool.
Post: MySQL 5.1 Command line client improvements
June 16, 2007 By 11 Comments
Just found this little handy feature today: mysql> insert into c select rand()*1000, sha1(rand()) from c; … execution was interrupted So now if you press CTRL-C MySQL Command Line Client will not exit but will terminate query being executed… assumed CTRL-C would also abort running query in previous MySQL versions and I’ve seen many monstrous queries left running…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… this as command line client is known to optimize queries sometimes by skipping “unnecessary” comments. So here is the command line run: mysql> select /* my… not use MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about MySQL 5…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… as the underlying storage for the virtual machines. Baseline: The MySQL command line client was used to execute the a script file containing…, the results and response times were captured with the T command. The queries were executed on a single database schema containing… the output was captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime_one password= port=5029 column=date…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… I’m aware about is running the server from command line with –no-defaults –verbose –help options: pz@ubuntu:~$ /usr…of variable global value Right now I can select: mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_buffer_size | +—————————+ |…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
… VARIABLES value, and settings done by changing tables rather than command line options (like much of Performance Schema configuration). Innodb settings alone… got exposed over last few years. Majority of options in MySQL have been hard code based on guesses or some experiments… natural step I would like to see taken is having MySQL to chose sensible values for them automatically, based on system…
