(Cédric PEINTRE) Today I’m working on integrate the Percona toolkit (instead of maatkit) in my own tools and I’m playing with pt-query-digest and pt-query-advisor.
Tag: Open Source
On complex optimizations and optimizer hints
(Sergey Petrunia) In an ideal world, you should never need to use optimizer hints. In the real world, hints are necessary. We needed hints even before we’ve made a release. The first requests came from our Quality engineer who complained about it being difficult to hit particular join orders while u
Create successful Python projects
(Patrick T. Altman) Creating a successful open source Python project involves more than just writing useful code. It’s about community engagement, increasing cooperation opportunities, craftsmanship, and support. Explore best practices to help you create your own successful project.
Making the impossible: 3 nodes intercontinental replication
(Vadim Tkachenko) In this post I want to show new possibilities which open with Percona XtraDB Cluster.
Help Statement in MYSQL Server
(Arjun Panwar) This article explains the help statement which provides a list of help categories.
Using RichFaces with JSF 2
(Joe Sam Shirah) RichFaces, like most other rich/Ajax component frameworks designed for use with JavaServer Faces (JSF), was extensively revamped for compatibility with the significant changes in JSF 2.
Not if, but when
(Baron Schwartz) As a MySQL consultant, I spend a lot of time talking with people about their backups. More specifically, we talk a lot about recovery. I had an interesting incident myself, which illustrates some of the things that are bound to happen as time passes.
Configuring MySQL For High Number of Connections per Second
(Ryan Lowe) One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account.
MySQL Performance: Linux I/O
(Dimitri) It was a long time now that I wanted to run some benchmark tests to understand better the surprises I’ve met in the past with Linux I/O performance during MySQL benchmarks, and finally it happened last year, but I was able to organize and present my results only now..
Firewall uptime and security with iptables
(Alfredo Deza) Iptables is the standard Linux firewall application. It is easy to configure and maintain while powerful enough to provide the control expected from a high-end appliance. Learn how to get started with iptables, recover from common issues, and simulate a small-office usage scenario.
