MySQL: CPU information from SQL
Do you know that it’s possible to get information from the CPUs of your MySQL Server from SQL ? If you enable the status for the INNODB_METRICS table in INFORMATION_SCHEMA, you will be able to query CPU information.
Category Information_Schema
How to grant privileges to users in MySQL 8.0
It seems, that this is a question that regularly shows up in forums or stackoverflow. To start, let’s highlight the fact that in MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR…
MySQL 8.0 and keywords
As you know, MySQL uses some keywords and some of them are also reserved. Let’s have a look how to deal with that: mysql> create table WRITE (id int auto_increment primary key, varying varchar(10), than int); ERROR 1064 (42000): You…
pre-FOSDEM MySQL Day 2019
For the third year in a row, we will take advantage of the mass presence of our MySQL Engineers during FOSDEM to organize the pre-FOSDEM MySQL Day. The program of this 3rd edition is already on track, thank you to…
MySQL: size of your tables – tricks and tips
Many of you already know how to retrieve the size of your dataset, schemas and tables in MySQL. To summarize, below are the different queries you can run: Dataset Size I the past I was using something like this :…
