Top 5 MySQL settings I usually configure in a Single Instance

My goal on this post is to give newbies in MySQL an idea on the list of some of the most important settings they need to review after completing a MySQL Server installation. Note: The recommendation here doesn't cover tuning and optimizing a MySQL Replication. 1. innodb_buffer_pool_size This...

Read More

What is the correct pronunciation of MySQL?

Have you ever attended a MySQL conference or a simple webinar? Have you noticed the different ways a speaker or a participant pronounce MySQL? I do! And it confused me before. You might have encountered some saying it "m|y|s|q|l" (spelled), or "my seek well", or "my es Q el". So which one is...

Read More

Why MySQL?

In order to fully appreciate the benefits for using MySQL as your organization's primary database, let's first discuss some important facts about MySQL. MySQL is the world's most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading...

Read More

Welcome to MySQL Specialist Philippines

Welcome to MySQL Specialist Philippines! My name is Jonathan Valerio, I'm a MySQL Database Administrator for almost 7 years now (2015), and I have decided to create this blog site in order for me to document every MySQL challenges, issues, bugs and anything worth sharing, and contribute to...

Read More