With Halloween all but a distant memory, the time has come to turn our attention to the upcoming holiday season. First, Thanksgiving, then Black Friday and Cyber Monday, culminating in the Christmas/boxing week shopping bonanza. For business owners, this time of the year marks the long-awaited year’s end profit taking. For some DBA’s, it brings fear, trepidation, and even sleepless nights toiling away to bring systems back online.

Thankfully, this need not be the case. With a little proactive tweaking of MySQL performance variables, you can insulate your database server(s) against the onslaught of increased demand that the shopping season brings.

Tip #1: Determine the Maximum Number of MySQL Connections

A good starting estimate for the maximum number connections on MySQL is one for every five requests to your web server. A few of those five requests to your web server will be for resources like CSS style sheets, …

We would like to wish you a happy holidays on behalf of the DBAHire.com team. May all your dreams come true in 2015!

Photograph taken at the Christmas market of Valencia (Spain) in December 2014.

May your MySQL innodb_buffer_pool_reads be low and your Uptime high in 2015.

Dear Customer,

We at Monitis want to thank you for being with us this past year and tell you what a pleasure it has been to help you reach your everyday business goals. Monitis is growing fast and we sincerely appreciate the trust you put in us to help you manage all of your IT challenges.

During the past year we have worked diligently to expand and improve our suite of services to match your needs. We were especially excited to bring you new offerings such as;

• Powerful integrations with industry leading partners such as; WHMCS, Zapier, PagerDuty and VictorOps
• Enriching our Application monitoring and added; Log Monitor, Email Round Trip, MySQL and Node.js monitors
• Real User Monitoring to a clear and quick view into the experience of your …

Hello everyone! Before I move to the seasonal greetings, let me share some exciting news.

2008 was quite remarkable for Pythian and, in addition to our ongoing success and growth, we established Pythian Europe back in May. To top it off, we have now laid the foundation for Pythian East Asia Pacific.

Pythian Australia Pty Ltd was incorporated and started official operations in Australia this month, taking over service delivery for the region. We have a few local clients and already signed some new ones, so this is quite an exciting beginning.

Today, there are three of us working in Sydney office:

A little bit of history. Pythian has operated in Australia for almost three years by now (well, longer than …

Sometimes one has weird ideas, or am I the only one? - This specific one is at least a year old, now, during the Christmas days, waiting for New Year's Eve I had the time and mood to finally try it out: MySQL 5.1 has a plugin interface to easily add storage engines. PHP can easily embedded into other applications.  So why not combine these two things? - Writing a MySQL Storage Engine which reads data by calling a PHP script.

Let's start with a simple example first:

<?phpfunction create_table($table, $data) {
    return true;
}

function open_table($table) {
…

Finding free quality wallpaper is hard and its even harder to find quality wallpaper for Christmas. Here is a couple sources I came across with a pretty good selection. If you have any suggestions of other sources for the holiday season drop a comment.

Source: CSSBuilt - 29 Beautiful Christmas Wallpapers
Source: CSS Count - 30 List of Stunning Christmas Wallpapers