This issue specifically occurs when phpMyAdmin cannot use MySQL plugins after a PHP update, causing it to malfunction. Generally, PHP and MySQL come as a series of integrated packages, but if this problem arises, refer to the following solution:
phpMyAdmin“Cannot load my …
Oracle just released the MySQL 5.6.10 GA version, so it’s time to update the previous performance benchmark data. This round of testing includes the following versions: MySQL-5.5.29 MySQL-5.6.10 MariaDB-5.5.28a MariaDB-10.0.1 This test also retains …
Since most MySQL deployments today run on Linux, here are some general and straightforward strategies for optimizing MySQL on the Linux operating system. These methods can all help improve MySQL performance. Without further ado, let’s get straight to the point. 1. CPU Let’s start with the CPU. Check carefully …
Today, I bought a Host1Plus VPS and tried to install MySQL. Initially, I used the yum -y install mysqld command, but after the installation, I was speechless:
Checked if there was a service starting with “my” in /etc/rc.d/init.d/ ls /etc/rc.d/init.d/my*
Using service …
NoSQL surged in popularity in 2010, with web sites large and small turning to NoSQL technologies as a top priority in the pursuit of high performance and high reliability. At the start of this year, InfoQ Chinese had the pleasure of inviting Mr. Sun Li from Phoenix New Media to share his experience with NoSQL …
The UMP (Unified MySQL Platform) system is a low-cost, high-performance MySQL cloud data solution developed by Taobao’s core system database team, with key modules implemented in the Erlang language. The system includes controller servers, proxy servers, agent servers, API/Web services …
When designing database table structures and operating databases (especially SQL queries when looking up tables), we need to pay attention to data operation performance. Here, we won’t discuss too much SQL statement optimization, but will focus specifically on MySQL, the most widely used database in web applications. Hopefully the optimization techniques below …
SSL replication requires that both the primary and replica servers have their own certificates and private keys. By default, SSL functionality is not enabled on the primary and replica servers; you need to enable it first. 1 2 3 4 5 6 7 8 9 10 11 12 mysql> show variables like '%ssl%'; +——— …
Overview Replication is commonly used to create copies of the master node, ensuring high availability by adding redundant nodes. Of course, replication can also serve other purposes, such as performing data reads and analysis on slave nodes. In horizontally scaling businesses, replication is easy to implement, primarily by utilizing the master node for write operations …
Based on a suggestion by morgo, I ran some small tests on the queries and datasets mentioned in Impact of Column Types on MySQL JOIN Performance, but uncovered an issue on another level: response time (aka MySQL versions). The answer, in short …
