Buy Percona ServicesBuy Now!

This Week in Data with Colin Charles 42: Security Focus on Redis and Docker a Timely Reminder to Stay Alert

 | June 15, 2018 |  Posted In: Amazon Aurora, Events and Announcements, MySQL, MySQL 8.0, Security

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Much of last week, there was a lot of talk around this article: New research shows 75% of ‘open’ Redis servers infected. It turns out, it helps that one should always read beyond the headlines […]

Read More

This Week in Data with Colin Charles 40: a Peak at Blockchain, Lots of MariaDB News, then Back on the Road

 | June 1, 2018 |  Posted In: AWS, Events and Announcements, MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Server for MySQL, PostgreSQL, ProxySQL

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Shortly after the last dispatch, I jetted off for a spot of vacation (which really meant I was checking out the hype behind Blockchain with a database developer lens at the Blockchain Week NYC), and then […]

Read More

This Week in Data with Colin Charles 39: a valuable time spent at rootconf.in

 | May 11, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Events and Announcements, MyRocks, MySQL, MySQL 8.0, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. rootconf.in 2018 just ended, and it was very enjoyable to be in Bangalore for the conference. The audience was large, the conversations were great, and overall I think this is a rather important conference if you’re […]

Read More

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

The Final Countdown: Are You Ready for Percona Live 2018?

 | April 20, 2018 |  Posted In: AWS, Containers, Database Monitoring, MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Live

Are you ready for Percona Live

It’s hard to believe Percona Live 2018 starts on Monday! We’re looking forward to seeing everyone in Santa Clara next week! Here are some quick highlights to remember: In addition to all the amazing sessions and keynotes we’ve announced, we’ll be hosting the MySQL Community Awards and the Lightning Talks on Monday during the Opening […]

Read More

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

Read More