This course is mainly aimed at Java developers, not entirely suitable for operation and maintenance database engineers 1, MySQL architecture introduction 2, index optimization analysis...
Starting mysql. The server quit without updating PID file Starting mysql. The server quit without updating PID file Starting mysql. The server quit without updating...
Conclusion: Under RR, innoDB illusion is solved by MVCC or GAP lock or next-key lock. Snapshot read: a simple select operation. Snapshot read is not...
Download online find a mysql8.0 installation package download, installation package and package, I'm used to package https://dev.mysql.com/downloads/mysql/ installation to your favorite dish, I need with...
Readers responded to an interesting deadlock case, and I analyzed and summarized an article. Deadlock condition: transaction 2 has S lock, wants to lock X,...
Indexes speed up lookups because they are ordered between sibling nodes at each level and can be quickly located by dichotomy. If some operation breaks...
You've heard of MySQL replication, synchronous replication, asynchronous replication, etc. What's the overall evolution of MySQL replication? Why does this happen?
The author divides optimization into two categories: soft optimization and hard optimization. Soft optimization is generally the operation of the database; Hard tuning involves manipulating...
Abstract: At the Percona Live Open Source Database conference, the MySQL Community Committee announced that aliCloud was the only MySQL Corporate Contributor Award for 2018....
Abstract: Recently, enterprise distributed application services (EDAS) for Kubernetes application management function new online, top of the HALO of EDAS, which Kubernetes application management is...