… reaching the 75% maximum for dirty pages. How can you detect in regular MySQL that…strategy which will give the biggest benefit is: Install more memory or upgrade the I/O … to Percona Server, with a more advanced flushing algorithm, may give a good performance gain. If you already use Percona Server…
Page: Consulting for MySQL
July 31, 2006 By
Percona offers consulting (and …server runs well on day to day basis, install security updates, perform schema maintainance setup backup procedures, pro actively monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
…to do an upgrade. Odds are that we’re not going to reboot the whole machine to do this upgrade; we’ll just install…to the process/thread limit: (root@revolution 23:59:37)# service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…to analyze your replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is easy to…to check the types and frequencies of queries but also how much IO they are causing and how…be easy to see on the graphs. If you have not yet installed something for…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…Oops’ moment? Let me show you quickly how. This howto assumes that you already…merge option was made available to the lvconvert binary. Base installs of Ubuntu 11.04 (Natty…to merge the state of the snapshot to the original LV. [root@sb logs]# /etc/init.d/mysql stop Shutting down MySQL (Percona Server…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
…my demos at the dev meeting was showing how we can set up tests for Xtrabackup…for. We want the innobackupex prepare call to run without error? Boom goes the dynamite!: #…installed (test tests use the randgen and this is required…hey, it is a WONDER-tool!) : ) * Innobackupex, a MySQL / Percona server…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 38 Comments
…how long it will be supported for. Desktop Ubuntu is not of any interest to me, but the server…to install. At one point we had a RH support contract and they refused to honour it if we installed XFS, and refused to…
Post: HandlerSocket on SSD
November 2, 2010 By 9 Comments
… storage. I should give respect to HandlerSocket developers – I was able to install and get it working with Percona Server 5.1.50-12.1… rows and I used kind of PK lookups queries to HandlerSocket. To measure how IO access affects throughput, I vary amount of rows… am looking to run write benchmarks on HandlerSocket and if the results are good we may include it in our Percona Server distribution.
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…to crash MySQL/DOS server on purpose but rather cause most of the issues unintentionally by running bad queries or installing…Percona releases) or Log analyzes as well as PROCESSLIST monitoring. This allows you to…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… we’re working on Percona Server 5.6, I did wonder if this was a good opportunity to re-examine how we could provide… to reproduce all the information in the slow query log. The code for my prototype can be found at lp:~stewart/percona-server… Building Blocks headers installed as I used their tbb::atomic<> implementation. My solution to log file rotation is to basically count how many people…
