June 20, 2013

Post: Why MySQL Performance at Low Concurrency is Important

March 27, 2013 By 8 Comments

… want to target an opposite question: why MySQL performance at low concurrency is important for you. I decided to write about this… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer Guide… 1 and the same tool is not possible. Want to talk more about performance? Come to Percona Live MySQL Conference and Expo…

Filed Under: Benchmarks, MySQL, Percona Live Tagged With: , , , , , ,

Post: MySQL Limitations Part 4: One thread per connection

October 27, 2010 By 14 Comments

… implemented is a pool of threads, which was originally coded for MySQL 6.0, but is available now in MariaDB. Unfortunately it isn… MySQL doesn’t do well, but it doesn’t matter that much, because that’s not what it’s designed for. Wrong tool, wrong use, NotABug. I’m thinking of the lack of sort-merge joins or intra-query parallelism, for example…

Filed Under: Insight for Developers, MySQL Tagged With:

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

March 11, 2013 By 7 Comments

… a star schema, so they are popular for use with tools like Mondrian and also for data mining.  I wrote an earlier blog… paths are unique for basedir and datadir I tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except…

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

Post: Tools and Techniques for Index Design Webinar Questions Followup

October 4, 2012 By 5 Comments

…. I’d like to invite folks who are interested in tools for query optimization to attend the new Percona online virtual training… to current versions of MySQL. Q: How do the upcoming changes in MySQL 5.6 change the best practices for index design? Fundamentally, index design best practices will not change.  MySQL 5.6 is still…

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

Post: How Can Percona MySQL Server Development Services Help ?

January 28, 2013 By 3 Comments

… running MySQL 5.1 but the bug is planned to be fixed only in MySQL 5.6, this might not be good enough for you. Percona MySQL Server Development Services can often…-Percona Tools – Can we help you with non-Percona Tools, too? We have worked with a number of Open Source tools from the MySQL…

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

Post: Evaluating IO subsystem performance for MySQL Needs

March 5, 2008 By 23 Comments

… scale. The tool I’m using for this is SysBench which was designed by my team when I still worked for MySQL and we specially implemented bunch of tests to ease hardware evaluation for things which are important for MySQL. To prepare… was 2334.63 Requests/sec which is perfect scalability to 6 hard drive this array has. We have even a bit…

Filed Under: Benchmarks, Hardware and Storage Tagged With:

Post: DBD::mysql 4.014 breaks pt-table-checksum 2.0

February 21, 2012 By Leave a Comment

… lot of errors like: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed [for Statement "..." with ParamValues: ...] at… DBD::mysql a system has, execute: perl -MDBD::mysql -e ‘print $DBD::mysql::VERSION, “\n”;’ This bug may affect other Percona Toolkit tools, but…

Filed Under: Insight for DBAs, MySQL, Percona Software Tagged With: ,

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

… the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL 5.4… make major changes to MySQL itself).  What war stories can you report on in plugging into MySQL? Unfortunately the “war” continues… thing because it provides DBA’s with the tools they need. My goal for PBXT in this regard is twofold: I hope…

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

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

March 4, 2013 By 7 Comments

… | | 7112 | Download Idaho Tax Forms for Individual or Business Needs | 0.9273209571838379 | … | Mark Allen Abrell | 0 | +——-+————————–+——-+ And with 5.6: mysql: SELECT id, full_name, MATCH(full…major MySQL version upgrade before rolling it into production! Percona has tools…

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

Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

January 9, 2013 By Leave a Comment

… new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in beta… plan on running the tools on Percona XtraDB Cluster or MySQL 5.6 are advised to upgrade. The following tools have been verified to… regardless of the server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables…

Filed Under: MySQL, Percona Software, Percona Toolkit Tagged With: , , , ,
« Older Posts
Newer Posts »