Optimizing performance on Cloud SQL for MySQL (Next Rewind '18)

Опубликовано 5 ноября 2018, 19:00

Database performance tuning can be challenging and time-consuming. In this session, we will share the performance tuning our team has conducted in the last year to considerably improve Cloud SQL for MySQL, and highlight changes we've made in the Linux kernel, EXT4 filesystem, and Google's Persistent Disk storage layer to improve write performance. You'll come away knowing more about MySQL performance tuning, an underused EXT4 feature called “bigalloc” and how to let Cloud SQL handle mundane, yet necessary, tasks so you can focus on developing your next great app.

Original talk by Stanley Feng, Theodore Tso, and Brett Hesterberg
Rewind by Gabriela Ferrara

CloudSQL MySQL flags → bit.ly/cloudsql-mysql-flags
PerfkitBenchmarker → bit.ly/2CSlOK2

Watch full session here → bit.ly/2R1bBho
Watch more recaps here → bit.ly/NextRewind2018

Watch more Infrastructure & Operations sessions here → bit.ly/2uEykpQ
Next ‘18 All Sessions playlist → bit.ly/Allsessions

Subscribe to the Google Cloud Platform channel! → bit.ly/GCloudPlatform event: Google Cloud Next 2018; re_ty: Publish; product: Cloud - Databases - Cloud SQL; fullname: Stanley Feng, Theodore Tso, Brett Hesterberg;