(Jan Lindstrom) A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. The table containing the foreign key is called the child table, and the table containing the candidate key is called the referenced or parent table.
Tag: Open Source
Baffling 5.7 global/status variables issues, unclean migration path
(Shlomi Noach) MySQL 5.7 introduces a change in the way we query for global variables and status variables: the INFORMATION_SCHEMA.(GLOBAL|SESSION)_(VARIABLES|STATUS) tables are now deprecated and empty. Instead, we are to use the respective performance_schema.(global|session)_(variables|status) tab
Baffling 5.7 global/status variables issues, unclean migration path
(Shlomi Noach) MySQL 5.7 introduces a change in the way we query for global variables and status variables: the INFORMATION_SCHEMA.(GLOBAL|SESSION)_(VARIABLES|STATUS) tables are now deprecated and empty. Instead, we are to use the respective performance_schema.(global|session)_(variables|status) tab
Changed defaults between MySQL 5.6 and 5.7
(Giuseppe Maxia) MySQL 5.7 comes with many changes. Some of them are better explained than others.
Changed defaults between MySQL 5.6 and 5.7
(Giuseppe Maxia) MySQL 5.7 comes with many changes. Some of them are better explained than others.
The MySQL query cache: Worst enemy or best friend?
(Stephane Combaudon) During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful.
The MySQL query cache: Worst enemy or best friend?
(Stephane Combaudon) During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful.
In search of cleanliness : the elusive quiet installation
(Giuseppe Maxia) A clean installation of a database server is one where everything goes according to the expectations. It used to be easy: you only had to do what the manual says, and, presto! you would see your database server installed and ready to use. If something went wrong, you got one or more
In search of cleanliness : the elusive quiet installation
(Giuseppe Maxia) A clean installation of a database server is one where everything goes according to the expectations. It used to be easy: you only had to do what the manual says, and, presto! you would see your database server installed and ready to use. If something went wrong, you got one or more
MYSQL_HISTFILE and .mysql_history
(Peter Gulutzan) The MySQL manual says: