Relational database
The popular open-source database behind much of the web.
A widely deployed relational database whose default InnoDB storage engine provides ACID transactions, row-level locking and clustered primary keys. Available as Community and Enterprise editions.
MySQLBeginnerThe error points at a query that returned arbitrary values. Fix it with aggregates, primary-key grouping, ANY_VALUE() or window functions, and keep the SQL mode on.
#configuration#troubleshooting
MySQLIntermediatePage 1 takes 5 ms and page 5,000 takes 4 seconds. OFFSET reads and throws away every skipped row. Switch to keyset (cursor) pagination for constant-time pages.
#indexing#pagination#performance
MySQLBeginnerMySQL's utf8 isn't real UTF-8. Here's why emoji break it, how to convert tables and connections to utf8mb4, and how to get past the 767-byte index limit.
#configuration#data-types#troubleshooting
MySQLIntermediateError 1205 on a simple UPDATE, from code that doesn't even use transactions. Find the blocking session, spot the missing index that's locking too much and stop it coming back.
#locking#transactions#troubleshooting
MySQLIntermediateStale reads and 2 a.m. lag spikes usually come down to single-threaded apply, tables without primary keys and giant transactions. Diagnose and fix each one.
#performance#replication#troubleshooting
MySQLIntermediateIn MySQL's InnoDB, the table is the primary key index. That single fact shapes insert speed, index size and how you should pick primary keys.
#indexing#internals#schema-design
MySQLBeginnerHow NULL behaves in MySQL comparisons, functions, aggregates, sorting, constraints and indexes, with the queries that silently drop rows and how to fix them.
MySQLBeginnerLearn what MySQL Enterprise has to offer to developers and enterprises to build and manage scalable, reliable, and highly available database.
MySQLBeginnerWrite a MySQL CREATE TABLE statement with sensible data types, keys and constraints, check the result, fix the common errors and drop the table safely.
MySQLBeginnerCreate a MySQL database with the right character set and collation, add an application user with limited grants, verify the result and fix the usual errors.
#mysql-5.7
MySQLBeginnerMySQL 5.7 is the latest release of the most popular open source database. Here is a list of new and improved features in this release.
#mysql-5.7
