User Bill Karwin

29 votes

How to dive into an ugly database?

answered Nov 10, 2008 at 16:55

26 votes

MySQL - How to check for a value in all columns

answered Sep 15, 2019 at 22:28

23 votes

Is the concept of a clustered index in a DB design sensical when using SSDs?

answered Nov 28, 2011 at 19:42

21 votes

Accepted

How are auto_increment keys handled in INSERT (SELECT * FROM...)

answered Mar 9, 2014 at 22:08

20 votes

InnoDB create table error: "Row size too large"

answered Oct 6, 2011 at 23:22

18 votes

Accepted

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

answered Dec 6, 2013 at 22:34

15 votes

Accepted

How do you tune innodb_read_io_threads?

answered Sep 12, 2021 at 15:03

12 votes

What happens to a transaction if the network connection fails?

answered Mar 3, 2014 at 0:59

12 votes

mysqldump not escaping single quotes properly

answered Nov 29, 2012 at 21:28

12 votes

Accepted

Won't start: InnoDB: Corrupted page ... Tablespace was not found

answered Mar 26, 2018 at 17:17

12 votes

Accepted

Row size error with MySQL

answered Aug 29, 2014 at 16:45

10 votes

Accepted

Why does FROM multiple tables default to cartesian product?

answered May 1, 2021 at 17:35

10 votes

Accepted

How do I dump only the data for all tables using mysqldump

answered Feb 5, 2013 at 6:34

10 votes

My.cnf with 64GB RAM

answered Apr 24, 2014 at 19:28

10 votes

Accepted

Do I need --skip-lock-tables with --single-transaction?

answered Sep 28, 2021 at 14:27

10 votes

Accepted

Are enums still evil (in MySQL 8.0)?

answered May 18, 2022 at 15:28

10 votes

In MySQL/MariaDB, do Indexes' performance degrade as they become larger and larger?

answered Dec 29, 2022 at 1:36

9 votes

What is the cost of adding a foreign key in mysql?

answered Sep 28, 2014 at 22:37

9 votes

Accepted

Why is the Innodb Memcached plugin being deprecated in MySQL 8.0.22?

answered Dec 8, 2021 at 17:14

9 votes

Log4j CVE-2021-44228 - vulnerability in MySQL hosts

answered Dec 13, 2021 at 20:10

8 votes

When should run Analyze table statement in mysql

answered Feb 23, 2021 at 23:48

8 votes

Accepted

Dynamically change schema to accommodate custom fields!

answered Mar 12, 2014 at 17:58

8 votes

Accepted

Partitioning large mysql table

answered May 20, 2014 at 19:52

7 votes

Accepted

what effect does changing the data type of an existing indexed field have on the index?

answered Mar 9, 2014 at 21:51

7 votes

Accepted

single query using OR operator vs multiple queries using equals operator

answered Oct 16, 2014 at 0:48

7 votes

Accepted

Percona MySQL 5.5 Unique key is duplicated

answered Jul 15, 2014 at 16:49

7 votes

Accepted

Database Normalization - Can one field point to another?

answered Jun 20, 2014 at 19:19

7 votes

MySQL database copy

answered Feb 8 at 6:49

7 votes

Migrating existing tables to use INT primary key instead of UUID mysql v8

answered Nov 16, 2022 at 16:23

6 votes

Accepted

credentials file for running mysql related jobs via script?

answered Jul 25, 2014 at 18:28

Stack Exchange Network

445 Answers

How to dive into an ugly database?

MySQL - How to check for a value in all columns

Is the concept of a clustered index in a DB design sensical when using SSDs?

How are auto_increment keys handled in INSERT (SELECT * FROM...)

InnoDB create table error: "Row size too large"

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

How do you tune innodb_read_io_threads?

What happens to a transaction if the network connection fails?

mysqldump not escaping single quotes properly

Won't start: InnoDB: Corrupted page ... Tablespace was not found

Row size error with MySQL

Why does FROM multiple tables default to cartesian product?

How do I dump only the data for all tables using mysqldump

My.cnf with 64GB RAM

Do I need --skip-lock-tables with --single-transaction?

Are enums still evil (in MySQL 8.0)?

In MySQL/MariaDB, do Indexes' performance degrade as they become larger and larger?

What is the cost of adding a foreign key in mysql?

Why is the Innodb Memcached plugin being deprecated in MySQL 8.0.22?

Log4j CVE-2021-44228 - vulnerability in MySQL hosts

When should run Analyze table statement in mysql

Dynamically change schema to accommodate custom fields!

Partitioning large mysql table

what effect does changing the data type of an existing indexed field have on the index?

single query using OR operator vs multiple queries using equals operator

Percona MySQL 5.5 Unique key is duplicated

Database Normalization - Can one field point to another?

MySQL database copy

Migrating existing tables to use INT primary key instead of UUID mysql v8

credentials file for running mysql related jobs via script?