Social Networks for the life of the world
Articles about the MySQL relational data management system.
This is the data definition language used by the Index MySQL For Speed plugin to add and remove high-performance keys. This is the code used for recent versions of MariaDB and MySQL, the ones supporting the Barracuda version of the InnoDB storage engine. Notice that each table gets just one ALTER TABLE statement. This allows … Read more
This is the data definition language used by the Index MySQL For Speed plugin to add and remove high-performance keys. This is the code used for older versions of MariaDB and MySQL, the ones supporting the Antelope version of the InnoDB storage engine. Notice that each table gets just one ALTER TABLE statement. This allows … Read more
postgreSQL is, according to this article by Andy Pavlo, doing very well in design wins for new projects. Could WordPress adopt it? It would be hard to do. Even if the core could be adapted, the vast ecosystem of plugins and themes is very MariaDB / MySQL centric. Here are some musings from the core … Read more
Do you need to install an old version of MariaDB on Ubuntu? Maybe you need to do some testing. Here’s how. Visit https://mariadb.com/downloads/ and choose your package and OS. You’ll download a tar fie. Extract the tar file with tar xf mariadb*.tar. Change your working directory to the extracted directory. cd mariadb*debs Set up your … Read more
Sometimes, upon adding indexes to MariaDb or MySQL tables with columns with zero-default dates you’ll get an error message like this: This happens because your server’s default sql_mode includes the NO_ZERO_DATE value. It is prevalent when working on WordPress indexes using phpmyadmin or some other MySQL client program. To prevent it, change the sql_mode before … Read more
Anybody who’s worked with databases knows this: as they grow they can slow down. It’s the curse of the customer base. Successful applications gather users and other transactional data. In this article I’m using MySQL database queries based on WordPress’s database design. Still, the ideas in this article apply to every application built on any … Read more
It’s straightforward to get WordPress to capture the MySQL queries it uses to generate each page view. We can then analyze the captured queries. Capturing WordPress offers a way to capture a list of the database queries it uses in each page view. It’s simple: define the global SAVEQUERIES symbol. You can define it permanently … Read more
People are using the Index WP MySQL For Speed WordPress plugin! That’s great. But it shoots into the dark: nobody can tell how much improvement they’ve seen except subjectively. That’s not good. It’s hard to improve something unless we can actually measure it. Two things can make a troublesome query. If it runs just once … Read more
Installing old versions of MySQL is a giant pain. An AskUbuntu contributor gave a workable procedure. Need to run MySQL 5.5? Download this VM. Running MySQL 5.7 is easier. Install Ubuntu 18.04, then do sudo apt install mysql-server-5.7 .
The information in this post isn’t up to date. This was the original concept paper for the plugin. Please see here for the latest. Rick James and I have cooked up a plugin, Index WP MySQL for Speed, to help optimize the way WordPress uses its MySQL database. It adds indexes to WordPress’s tables in … Read more