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

preview_player
Показать описание
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.

Рекомендации по теме
Комментарии
Автор

In Semi sync replication, masters commit post he receive an acknowledgement from slave ( that tx has been written in to the relay log) instead of committing before acknowledgement.

chalusan