Search Results for: mysql memory map

Using Cgroups to Limit MySQL and MongoDB memory usage

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am […]

What stopped MySQL? Tracing back signals sent to MySQL

Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? ūüėČ If so, you might want to read on. I’m going to tell you how you can […]

Tips from the trenches for over-extended MySQL DBAs

This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA,” during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at the “over-stretched DBA,” identified as the MySQL DBA short of time or an […]

Q&A: Common (but deadly) MySQL Development Mistakes

On Wednesday I gave a presentation on ‚ÄúHow to Avoid Common (but Deadly) MySQL Development Mistakes‚ÄĚ for Percona MySQL Webinars. If you missed it, you can still¬†register¬†to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time […]

Introduction to Percona XtraBackup 2.1 (MySQL webinar & more)

Percona XtraBackup 2.1 has been in GA now for a little over four months and has some impressive new features to improve backup performance, security, and storage requirements. When used with Percona Server, additional features are enabled that can provide even more dramatic performance improvements. Percona XtraBackup is open source, free MySQL hot backup software […]

Announcing Percona Server for MySQL version 5.1.67-14.4

Percona is glad to announce the release of¬†Percona Server for MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available¬†here¬†and from the¬†Percona Software Repositories). Based on¬†MySQL 5.1.67, including all the bug fixes in it,¬†Percona Server¬†5.1.67-14.4 is now the current stable release in the 5.1 series. All of¬†Percona‘s software is open-source and free, all the details […]

Announcing Percona Server for MySQL version 5.5.29-30.0

Percona is glad to announce the release of¬†Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available¬†here¬†and from the¬†Percona Software Repositories). Based on¬†MySQL 5.5.29, including all the bug fixes in it,¬†Percona Server¬†5.5.29-30.0 is now the current stable release in the 5.5 series. All of¬†Percona‘s software is open-source and free, all the details […]

InnoDB memory allocation, ulimit, and OpenSUSE

I recently encountered an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel 2.6.31.12-0.2-desktop x86_64 √ā¬† with 96 GB RAM when the innodb_buffer_pool_size was set to anything more than 62 GB. I decided to try it with 76 GB. The error message was an assert due to a failed malloc() […]

Talking MySQL to Sphinx

In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage but it is still fun to play with. A thing to mention – unlike MySQL Storage Engines, some of which as InfoBright […]