June 19, 2013

Post: Slow Query Log analyzes tools

September 6, 2006 By 84 Comments

… to execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of does the thing… of info. Yes this will reduce your performance a bit and will require plenty of …indexes often help SELECT queries but slow down INSERT/UPDATE ones. Final Note: You do not have to have patched MySQL…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… so they are popular for use with tools like Mondrian and also for data mining. …MySQL 5.6 server, rebooted and verified again.  Same issue.  This was very different from MySQL 5.5.30, which performs… the other secondary indexes have been pushed out of the buffer pool. mysql> select * from information…

Filed Under: MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…be exactly identical to the same query when performed against InnoDB data, OR that the results returned…_size to 1, dropped/rebuilt the InnoDB index, and tried again. mysql: SELECT id, full_name, MATCH(full_…Playback) that can help you with this. These tools are free and open source, please use them. …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Data mart or data warehouse?

July 15, 2010 By 14 Comments

…performance using aggregation. Using materialized views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL…tools (OLAP/data mining), data extraction and transformation tools (ETL), and schema management tools… bitmap indexes, table …

Filed Under: Insight for Developers, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…are the lowest common denominator. We often use tools to gather a lot of the data for…there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together,…

Filed Under: Insight for Developers Tagged With:

Post: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

…and get debugging and profiling tools, as well as have tools which protect you from SQL …MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance… I have to fix have number of indexing missing which requires queries to do full …

Filed Under: Insight for Developers Tagged With: , ,

Post: The ultimate tool for generating optimal my.cnf files for MySQL

August 18, 2008 By 34 Comments

….cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and the full application… the point of causing a severe performance penalty. If it were as easy as writing a tool to do this, don’t… and end-all of performance. Tuning your server settings has far less impact on performance than tuning your schema, indexing, queries and — you…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL extensions for hosting

April 24, 2008 By 11 Comments

… sec) mysql> SHOW INDEX_STATISTICS LIKE ‘hosting2%’; +——————————————–+———–+ | Index | Rows_read | …Other_commands a few MySQL performance counters broken down by users … give the administrator powerful tool to almost effortlessly …

Filed Under: Percona Software Tagged With:

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

… and add extra indexes as you require. Doing so however may affect your performance – updating table with a lot of indexes may be… without need to have indexes would be quite handy I also should tell log table implementation in MySQL is well though of…. I guess over time we would have more tools provided with these and similar features if not by MySQL than by community.

Filed Under: Insight for DBAs Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…perform on each database. To do the size comparison, I used the du utility: InnoDB file size on disk: 42GB (with indexes…from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime… su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING…

Filed Under: MySQL
« Older Posts
Newer Posts »