Thu, 28 Sep 2023 14:46:18 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/dont-start-using-your-mysql-server-until-youve-configured-your-os/ https://www.percona.com/blog/dont-start-using-your-mysql-server-until-youve-configured-your-os/#comments Thu, 28 Sep 2023 14:46:18 +0000 https://www.percona.com/blog/?p=91143 Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first. Let’s review the […]]]> https://www.percona.com/blog/dont-start-using-your-mysql-server-until-youve-configured-your-os/feed/ 1 91143 https://www.percona.com/blog/replication-issues-and-binlog-compressor/ https://www.percona.com/blog/replication-issues-and-binlog-compressor/#comments Fri, 24 Mar 2023 11:57:39 +0000 https://www.percona.com/blog/?p=86350 You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article discusses the need for using binlog compression and the potential issues it may cause.Binlog compression is a technique used to reduce the size of binary log files, which can become quite large over time. This […]]]> https://www.percona.com/blog/replication-issues-and-binlog-compressor/feed/ 2 86350 https://www.percona.com/blog/count-vs-countcol-in-mysql/ https://www.percona.com/blog/count-vs-countcol-in-mysql/#comments Mon, 09 Jan 2023 13:43:10 +0000 https://www.percona.com/blog/?p=84510 Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and just use what they happen to like, while there is a substantial difference in performance and even query results. Also, we find a difference in execution on InnoDB and MyISAM engines.NOTE: All tests were applied […]]]> https://www.percona.com/blog/count-vs-countcol-in-mysql/feed/ 2 84510