… | Command | Time | State | Info | +—-+——+———–+——+————+——+——————-+———————————————————————-+ | 4 | root | localhost | test | Query | 80 | Sending data | select…because it was a MySQL command-line client that wasn’t …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id… select max(author_id) as a ,forum_id as f from sptest where num_links=1; Empty set (2.70 sec) MySQL mysql> select… using Native API more feature full at this point but command line language is very helpful for testing and debugging purposes as…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… all the tools with “make” command. After the compile process we … TERMINATED BY ‘\t’ OPTIONALLY ENCLOSED BY ‘”‘ LINES STARTING BY ‘salaries\t’ (emp_no, from… Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; +——–+——–+————+————+ …
Post: Percona Live London 2012 talks you do not want to miss
October 30, 2012 By Leave a Comment
… Sessions for these two day event. Here is my personal selection of the talks I’d love to attend, though I… Percona Toolkit: Command-line Tools for MySQL by Bill Karwin. This talk is a brief overview of 9 essential Percona Toolkit command line tools. I’m also giving talks myself – Using Percona Server in Production tutorial and Optimizing MySQL Configuration and…
Comment: MySQL Query Cache WhiteSpace and comments
March 25, 2008 By 9 Comments
… the mysql command line client now has an *option* to pass comments to the server, but it’s disabled by default: http://bugs.mysql.com/bug.php?id=26215 I’m running the 5.0.56 client and server, and from the command line, my…: 2 Lock_time: 0 Rows_sent: 230400 Rows_examined: 480 select /* my comment */ * from test.WEBSITE a, test.WEBSITE b;
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…: 0 mysql> flush tables; Query OK, 0 rows affected (0.01 sec) Then, at the shell command line: root@django:/var/lib/mysql/test… then, back in mysql: mysql> use test Database changed mysql> flush tables; Query OK, 0 rows affected (0.00 sec) mysql> select * from test_concat…/lib/mysql/test# myisamchk -r test_concat – recovering (with sort) MyISAM-table ‘test_concat’ Data records: 6 – Fixing index 1 mysql> select * from…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…will be. Find and change the following lines: # This is the max number of
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… the outline of improvements available in MySQL 5.6 which I thought was …Developers – MemcacheD API in Innodb – Explicit Partition Selection in queries – Full Text Search index for …for Authentication – Use obfuscated password storage for command line tools – Policy Based password validation – Plugin …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the MySQL version is, and I check (with the ‘file’ command) whether…Then, I go through it line by line, like this: +———————————–+———————-+———————-+ | Variable_name | Value | Value | … EXPLAIN if possible (rewriting non-SELECT queries if needed, and …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 483762.46 (the query Q0 is: select avg(c1) from (select year,month,count(*) as c1 from ontime… each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data…Here it took time to find how to execute command from command line using included sqlline utility, and I did…
