Mysql

Many testers know how to write SQL queries and how to fetch data from the tables. But only a few understand the internal architecture and how MySQL interacts with storage engines. This blog discusses the MySQL architecture, different layers and journey of SQL statement in MySQL data. MySQL architecture is

Read more

Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent versions of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL, designed and tested to work together. This distribution provides the key components

Read more

One of the most common errors encountered in the MySQL world in general is the infamous error 1040: Concretely, this means that a MySQL instance has reached its maximum authorized limit for client connections. Until the connections are closed, no new connections will be accepted by the server. I would

Read more

Businesses expect extreme reliability from the database infrastructure accessible by their applications. Despite your best intentions and careful engineering, database errors do occur, whether it’s a machine crash or network partitioning. Good planning can help you get ahead of problems and recover faster when problems arise. This blog presents an

Read more

MySQL is a database management system used by WordPress to store and retrieve all the information from your blog. Think of it this way. If your database is a workbook that WordPress uses to organize and store all of your website’s important data (publications, pages, images, etc.), MySQL is the

Read more