… 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)
… 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
… 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?
…. 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
… 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
…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
…. 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
… 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!
… 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
…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…

