Improving Connection Rate for mysqld

Tuesday -

@ Community Dinner Venue (The Mercantile Bar)

MySQL / MariaDB

Lightning Talk

Intermediate

Tracks:
Operations

We improved the connection rate of mysqld for both non-ssl and ssl-connections. We got a 2.5X improvement in improving connection rate non-SSL, and a 1.7X improvement on connection accept rate for SSL connections. We also ended up benchmarking and understanding the different SSL libraries and versions (OpenSSL 1.0, OpenSSL 1.1 and BoringSSL ). This improvement is deployed at scale at Facebook, and uses shared locking pattern to significantly reduce contention in mysqld global datastructures. It also uses advanced kernel features like SO_REUSEPORT to achieve these improvements. Implementing this has helped us handle connection surges in FB mysql tiers, more gracefully.


Speakers

Anirban Rahut

Anirban Rahut (Facebook)

Software Engineer

Biography:

Anirban works in the mysql team of Facebook, where he is currently focusing on CPU optimizations in mysqld, and exploring operational techniques like balancing shard placement for better CPU usage in the cluster. Anirban's interests are in databases, distributed systems and linux.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA