MySQL Performance Blog:
MySQL Performance Blog (and percona.com too) were down today because the switch in our rack died completely. It took a while to fix it using secondary switch we had. Provider was not willing to do it as remote hands so I had to drive to the data center to fix it.We got number of calls and messages from the customers and (Read More)
MySQL Performance Blog:
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul!What’s the “ideal” use case for the PBXT engine, and how does it compare in performance? When would I use PBXT in (Read More)
ModPerl | ModPerl:
Hi, I'm hoping someone can point me in the right direction here. I am creating a proxy using Apache with a bunch of URL rewrites. I also need to do. (Read More)
MySQL Performance Blog:
There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state.When you see bug happening you would see MySQL log flooded with error messages like this:091119 23:03: (Read More)
HowtoForge - Linux Howtos and Tutorials - Howtos about Linux and Open Source:
The Perfect Server - OpenSUSE 11.2 x86_64 [ISPConfig 3]This is a detailed description about how to set up an OpenSUSE 11.2 64bit (x86_64)server that offers all services needed by ISPs and hosters: Apache webserver (SSL-capable) with PHP, CGI and SSI support, Postfix mail serverwith SMTP-AUTH, TLS and virtual mail users, MyD (Read More)
MySQL Performance Blog:
Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode.Unlike MyISAM Innodb does not have t (Read More)
MySQL Performance Blog:
Dear Community,We are pleased to present the 20th build of MySQL server with Percona patches.Comparing to the previous release it has following new features:The build is based on MySQL-5.0.87innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3To be compatible with RedHat RPM repository, the naming scheme has changed to-- (Read More)
MySQL Performance Blog:
A final update on training for this year – registration for InnoDB/XtraDB training in Chicago (8th December) and Atlanta (10th December) are now open.While in Atlanta I’ll be giving a talk at the Atlanta PHP User Group on Optimizing MySQL Performance (details to be posted to their website shortly). If you’re in Chicago and (Read More)
MySQL Performance Blog:
I forwarded on a list of questions about PBXT to Paul McCullagh today. While Paul’s busy answering them, I’d like to announce that Robert Dempsey (InfiniDB storage engine) and Bradley C. Kuszmaul (TokuDB storage engine) have also accepted an interview. If you have any questions about either storage engine, please post the (Read More)
MySQL Performance Blog:
I wrote a post a while back that said why you don’t want to shard. In that post that I tried to explain that hardware advances such as 128G of RAM being so cheap is changing the point at which you need to shard, and that the (often omitted) operational issues created by sharding can be painful.What I didn’t mention was tha (Read More)
HowtoForge - Linux Howtos and Tutorials - Howtos about Linux and Open Source:
The Perfect Server - OpenSUSE 11.1 x86_64 [ISPConfig 3]This is a detailed description about how to set up an OpenSUSE 11.1 64bit (x86_64)server that offers all services needed by ISPs and hosters: Apache webserver (SSL-capable) with PHP, CGI and SSI support, Postfix mail serverwith SMTP-AUTH, TLS and virtual mail users, MyD (Read More)
MySQL Performance Blog:
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked an example on how to perform a simple scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and I decided to take a look, why writing something when a good (Read More)
MySQL Performance Blog:
In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL, replication. High Availability solution for MySQL: Replic (Read More)
ModPerl | ModPerl:
Developing Web Applications with Apache, MySQL, memcached, and Perl Patrick Galbraith http://ca.wiley.com/WileyCDA/WileyTitle/productCd-0470414642,de. (Read More)
MySQL Performance Blog:
In the next week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please post them here by Monday 16th November.Note: The idea for this interview was inspired by a previous interview with Heikki Tuuri – creator of InnoDB. You can see the answers here a (Read More)