… 1317 (70100): Query execution was interrupted So now if you press CTRL-C MySQL Command Line Client will not exit but will terminate query being executed. This is great as so many queries assumed CTRL-C would also abort running query…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… MySQL command line client was used to execute the a script file containing the 11 queries. This same SQL script was used in the Shard-Query tests. For the baseline, the results and response times were captured with the T command. The queries were executed… fed to the run_query.php script and the output was captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… query. I did this as command line client is known to optimize queries sometimes by skipping “unnecessary” comments. So here is the command line run: mysql… MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about MySQL 5.0 Query…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…. That means that every currently running query, including SELECT queries, must finish. So if there is a long-running query on the system, or an… been running for minutes or hours. If such a query were to begin running just before the FLUSH TABLES WITH READ LOCK command is… 6 can’t even log in because it was a MySQL command-line client that wasn’t started with -A, and it’s trying…
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 comment was stripped out (as seen by the query recorded…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…I check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/libexec/… the report to the client. Now I go through it line by line looking for things that look…queries themselves. If the client has long-running queries, it can be pretty easy to catch. Maybe they’re long-running…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…. A third instance, the client, will be discussed in part…mysql host would be much larger. Using another type is trivial. I will assume you are using the command line…To create a security simply run this command: yves@yves-laptop:~$ …use the “crm” tool to query the cluster status. root@monitor:~# crm…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… data to their own clients, with no delays. Finally, …”what kinds of queries do you have to run?” and they say… and parse it 10k lines at a time, aggregating …such as maintenance and repair commands, that essentially negate the …MySQL is, especially for more complex queries. Percona is not tied to MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… can begin. Open command line (shell) on …mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client‘ ‘–with-comment=MySQL…run time with both SET SESSION and SET GLOBAL. long_query_time=# Log all queries that have taken more than long_query…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
…command line mysql client returns error 34, Can’t create a new thread Also issuing a /usr/local/etc/rc.d/mysql-server restart command…query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries = /usr/mysql/logs/mysql…
