May 22, 2012

Post: Testing STEC SSD MACH16 200GB SLC

… throughput on line 222 MiB/sec To understand better what kind of response time we should expect,…suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC…. Disclaimer: This benchmark is done as part of consulting work for STEC, but this post is totally…

Post: MySQL Consulting - Being on your own

… getting better. Market is Great The market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing… with significant MySQL Experience and so MySQL Consultants is great way to solve problems for a lot of companies. Marketing Diving into consulting venture…

Post: What's required to tune MySQL?

… be needed to tune[1] a database for better performance. It is a question that I hear … you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its… file and see something wrong. Usually, though, the consultant needs to look at several important factors, including …

Post: Is your MySQL Application having Busy IO by Oracle Measures ?

… SAN 2010 by James Morle from Scale Abilities – and Oracle consulting company. It is worth to read for variety of reason… continue to be significant difference between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL is making…

Post: MySQL Performance Forums

… to announce availability of MySQL Performance Forums on MySQL Performance Blog. This forum is created as free alternative to MySQL Consulting Services which we… comments and sent by email and we had to find better way to organize it. We will try to reply to… a bit wider set of topics than just MySQL Performance. There is MySQL for MySQL Performance topics. LAMP Forum for Web Application scaling…

Post: How Percona diagnoses MySQL server stalls

…OS’s awesome tool that Linux doesn’t have] better? What’s nice about collect is that it gathers…the time. If you’re not a Percona support/consulting staff member, then of course you can hire us…. are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over…

Post: How we work on High Performance MySQL Second Edition

… of hard editorial work. Due to these problems, to get better book and get the book out faster we wanted to… for authoring a book being involved in MySQL Support, MySQL Consulting, Documentation, MySQL Training while working for MySQL and now on his own. Finally we… well as being author of very popular tools – Innotop and MySQL Toolkit. Initially Andy proposed us to work on the book…

Post: MySQL Sizing questions

… questions along the lines of “how many transactions per second MySQL can do” or “how many servers I need to handle… correct at least to the order of magnitude. Seriously in MySQL Consulting practice it would not be exception to have 1-2… based on your previous purchase history etc. To illustrate it better – take a look at Dell DVD Store Whitepaper This paper…

Post: How Percona does a MySQL Performance Audit

…, you know the term “thin-slicing.” That describes an experienced consultant‘s approach to the problem very well. The audit itself…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… the customer understood that the consultant had really done a lot of work, but it’s better to show the client the…

Post: Percona Launches New Support Option for MySQL

… other software for which we have offered top-notch consulting since 2006. Just MySQL, MariaDB, Percona Server with XtraDB, and Percona XtraBackup… is a significant step forward for the entire community. MySQL users need better choices. They need immediate access to deep expertise, 24×7…