When you process MySQL slow query logs using pt-query-digest you can store … GUI tool. For the visual browsing of tables created by pt-query-digest you may want to use some kind of web tools… post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal… easily solved by using the pager command: mysql> pager more PAGER set to ‘more’ mysql> select title from sakila.film; +—————————–+ | title | +—————————–+ | ACADEMY… your session. Conclusion The mysql command line client is not as glossy as most of the graphical tools, but if you know…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot you probably noticed… how many rows will be examined MySQL will still print full number. Here is example: mysql> explain select * from lt limit 10… EXPLAIN needs serious overhaul so it can be used with GUI tool to provide tree like structure of opertions applied to the…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…star schema, so they are popular for use with tools like Mondrian and also for data mining. I …was written. I compiled both servers from source (cmake -gui .; make; make install) Only changes from defaults was … Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all…
Comment: What to tune in MySQL Server after installation
October 23, 2006 By 118 Comments
… is great information thank you. I’m getting used to mySQL after many years in Oracle, and I’m curious as… cache and key cache? I’ve noticed in the Administrator GUI tool you can see hit ratios for query cache and key…
