User BenMorel

6 votes

2 answers

19k views

What happened to my-*.cnf in MySQL 5.6.8?

asked Nov 23, 2012 at 16:44

6 votes

2 answers

3k views

What's the risk of keeping a table with row size > 8126 in MySQL 5.7?

asked Mar 23, 2016 at 23:57

5 votes

1 answer

2k views

InnoDB primary key efficiency

asked Apr 22, 2014 at 15:31

5 votes

1 answer

1k views

Is it possible to check all constraints in a MySQL database?

asked Jan 20, 2013 at 1:15

5 votes

1 answer

2k views

Running the DBT2 test results in 0.00 NOTPM

asked Jul 26, 2013 at 22:15

5 votes

1 answer

6k views

Lock a MySQL database for upgrade

asked Sep 18, 2013 at 11:29

5 votes

2 answers

6k views

Stored procedures, binlog and SUPER privilege

asked Oct 4, 2013 at 8:28

5 votes

2 answers

5k views

What's the difference between mysql-community-server and mysql-community-server-minimal?

asked Oct 30, 2015 at 10:46

4 votes

2 answers

6k views

Connection to MySQL fails via PHP while command-line works fine

asked Sep 21, 2015 at 20:10

4 votes

1 answer

2k views

"Cannot resolve table name" error when applying MySQL dump to RDS

asked Mar 25, 2016 at 2:07

3 votes

1 answer

2k views

How do I set the MySQL error level?

asked Dec 12, 2014 at 15:06

3 votes

1 answer

5k views

Check all MySQL tables at once

asked Nov 5, 2013 at 12:47

3 votes

1 answer

1k views

Is there any danger using binary data over an UTF-8 MySQL connection?

asked Mar 25, 2014 at 14:33

3 votes

2 answers

1k views

Choose security group for restore-db-instance-to-point-in-time

asked Sep 15, 2013 at 15:17

2 votes

0 answers

289 views

Does it make a difference to add the DEFAULT keyword in CREATE TABLE?

asked Sep 24, 2013 at 17:12

2 votes

2 answers

2k views

How to skip table data for replication in MySQL?

asked May 24, 2017 at 15:11

2 votes

1 answer

146 views

"mysqld" vs "server" in my.cnf

asked Sep 16, 2020 at 12:03

1 vote

1 answer

38 views

How to know how full the MySQL redo log is?

asked Sep 19, 2020 at 22:25

1 vote

1 answer

290 views

Optimize MySQL FULLTEXT searches to use another index

asked Jul 30, 2019 at 12:28

1 vote

2 answers

755 views

Why does START TRANSACTION WITH CONSISTENT SNAPSHOT not work with SERIALIZABLE isolation level?

asked Dec 21, 2019 at 22:27

1 vote

1 answer

4k views

MySQL slave stuck on Applying batch of row changes (write)

asked Jan 24, 2019 at 17:09

1 vote

1 answer

118 views

How to efficiently swap a portion of a large table's data?

asked Nov 7, 2014 at 18:44

0 votes

0 answers

50 views

How to repair/replace a single faulty table on a MySQL slave server?

asked Nov 2, 2017 at 17:38

0 votes

1 answer

503 views

Non matching attribute 'INSTANT COLUMN(s)' between partition and table

asked Aug 24, 2018 at 0:32

0 votes

1 answer

1k views

Why does MySQL allow duplicate index names, but not duplicate foreign key names?

asked Jun 27, 2019 at 14:13

0 votes

1 answer

808 views

Automatically purging binlogs after successful replication

asked Dec 5, 2015 at 11:08

0 votes

1 answer

39 views

Where does each MySQL data file type belong?

asked Nov 20, 2020 at 13:02

0 votes

1 answer

1k views

Replication compatibility between minor MySQL versions

asked Feb 23, 2016 at 21:37

-1 votes

1 answer

1k views

Should I run mysql_upgrade after minor version upgrade via RPM?

asked Dec 18, 2015 at 11:03

Stack Exchange Network

29 Questions

What happened to my-*.cnf in MySQL 5.6.8?

What's the risk of keeping a table with row size > 8126 in MySQL 5.7?

InnoDB primary key efficiency

Is it possible to check all constraints in a MySQL database?

Running the DBT2 test results in 0.00 NOTPM

Lock a MySQL database for upgrade

Stored procedures, binlog and SUPER privilege

What's the difference between mysql-community-server and mysql-community-server-minimal?

Connection to MySQL fails via PHP while command-line works fine

"Cannot resolve table name" error when applying MySQL dump to RDS

How do I set the MySQL error level?

Check all MySQL tables at once

Is there any danger using binary data over an UTF-8 MySQL connection?

Choose security group for restore-db-instance-to-point-in-time

Does it make a difference to add the DEFAULT keyword in CREATE TABLE?

How to skip table data for replication in MySQL?

"mysqld" vs "server" in my.cnf

How to know how full the MySQL redo log is?

Optimize MySQL FULLTEXT searches to use another index

Why does START TRANSACTION WITH CONSISTENT SNAPSHOT not work with SERIALIZABLE isolation level?

MySQL slave stuck on Applying batch of row changes (write)

How to efficiently swap a portion of a large table's data?

How to repair/replace a single faulty table on a MySQL slave server?

Non matching attribute 'INSTANT COLUMN(s)' between partition and table

Why does MySQL allow duplicate index names, but not duplicate foreign key names?

Automatically purging binlogs after successful replication

Where does each MySQL data file type belong?

Replication compatibility between minor MySQL versions

Should I run mysql_upgrade after minor version upgrade via RPM?