News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

MySQL Performance Blog:
SSL Performance Overhead in MySQL
October 11, 2013 @ 11:30:28

On the MySQL Performance Blog there's a recent post looking at the impact of SSL in regards to the overall performance of your application. This is part one of a two part series and focuses largely on the results of two tests - one with connection pooling and the other to evaluate connection time.

Some of you may recall my security webinar from back in mid-August; one of the follow-up questions that I was asked was about the performance impact of enabling SSL connections. My answer was 25%, based on some 2011 data that I had seen over on yaSSL's website, but I included the caveat that it is workload-dependent, because the most expensive part of using SSL is establishing the connection. Not long thereafter, I received a request to conduct some more specific benchmarks surrounding SSL usage in MySQL, and today I'm going to show the results.

He details the environments used for testing including the hardware specs and the version of the software installed. The scripts (really just bash scripts that call sysbench) are included in the post and the results of the tests are both graphed out and dumped in tabular form. The results are pretty surprising, mostly having to do with just how much of an impact the SSL has on the the requests. He makes a few recommendations at the end of the post on how you can mitigate these problems though (hint: it's not about MySQL per se).

0 comments voice your opinion now!
performance overhead mysql ssl results benchmark sysbench

Link: http://www.mysqlperformanceblog.com/2013/10/10/mysql-ssl-performance-overhead/

blog comments powered by Disqus

Similar Posts

Job Posting: Electronic Medical Records Seeks Experienced PHP / MySQL Programmer (Philadelphia, PA)

Internet Super Hero Blog: MySQL native driver for PHP: mysqlnd-5.0.1-beta available

Andrew Martin's Blog: Serving PHP session files from a RAM based disk (tmpfs) for AWS Micro Instance

DevShed: Building an ORM in PHP

Benjamin Eberlei's Blog: Benchmark and Optimize Zend Framework Performance


Community Events





Don't see your event here?
Let us know!


framework podcast testing community opinion wordpress developer install release unittest language threedevsandamaybe introduction configure series list interview code refactor laravel

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework