User Rick James

27 votes

How large should be mysql innodb_buffer_pool_size?

answered Feb 7, 2015 at 1:02

24 votes

Accepted

MySQL: will a transaction lock the row?

answered Mar 5, 2017 at 17:10

23 votes

How to safely change MySQL innodb variable 'innodb_log_file_size'?

answered Jul 25, 2011 at 23:15

21 votes

How can I optimize a mysqldump of a large database?

answered May 20, 2011 at 20:55

21 votes

Possible to make MySQL use more than one core?

answered May 17, 2012 at 23:23

21 votes

Performance implications of MySQL VARCHAR sizes

answered Jul 2, 2016 at 5:33

21 votes

Accepted

Should I use UUID as well as ID

answered Oct 25, 2015 at 18:37

19 votes

Accepted

Identity column re-seed: when it is necessary?

answered Nov 25, 2018 at 23:09

17 votes

In the same query INSERT, can two VALUES being NOW() return a different time?

answered Mar 22, 2021 at 5:10

16 votes

Accepted

MySQL DELETE becomes exceptionaly slow with a large number of rows

answered Aug 18, 2016 at 1:31

15 votes

Accepted

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

answered Nov 13, 2017 at 14:17

15 votes

Accepted

Convert MySQL database from latin1 to utf8mb4 - and take care of German umlauts

answered Dec 16, 2015 at 16:51

14 votes

Accepted

Error Log Location?

answered Aug 2, 2016 at 22:03

13 votes

Accepted

Automatically purging binary logs

answered Mar 14, 2015 at 1:10

13 votes

How do you calculate how much hardware resources you need for a database?

answered Aug 25, 2015 at 20:47

13 votes

How to optimize very slow SELECT with LEFT JOINs over big tables

answered Oct 21, 2015 at 16:20

12 votes

Best General Purpose Character Set and Collation for MySQL

answered Jun 3, 2021 at 0:29

12 votes

DELETE command not completing on 30,000,000 row table

answered Feb 7, 2015 at 21:57

12 votes

Are junction tables a good practice?

answered Jul 6, 2015 at 21:58

12 votes

Accepted

Do varchar/text/longtext columns in MySQL occupy full size in filesystem even for partially filled cells?

answered Mar 29, 2016 at 4:22

12 votes

MySQL - UUID/created_at cursor based pagination?

answered May 15, 2018 at 20:11

12 votes

How to lower "Created_tmp_disk_tables" - temporary tables count created on DISK?

answered Sep 18, 2015 at 19:36

11 votes

Accepted

Best Practice to Archive Old Data in MySQL

answered Jul 11, 2017 at 0:54

11 votes

How to make mysqldump use /!40101 SET character_set_client = utf8mb4 /;?

answered May 5, 2016 at 14:54

11 votes

Error 1366: Incorrect string value: '\xF0\x9F\x98\x8A\x0AC…' for column 'text_body' at row 1

answered Jan 18, 2017 at 21:08

10 votes

Accepted

Delete Slow Query Log File

answered Aug 16, 2016 at 15:05

10 votes

Accepted

Biggest possible double/float for a column in my MySQL database

answered Jul 26, 2016 at 16:39

10 votes

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

answered Jan 27, 2019 at 22:39

10 votes

mysqlcheck to optimize innodb tables -- performance/scheduling

answered Nov 20, 2012 at 1:02

10 votes

Mysql - unknown variable 'table_cache=64'

answered Jun 14, 2015 at 21:43

Stack Exchange Network

5,482 Answers

How large should be mysql innodb_buffer_pool_size?

MySQL: will a transaction lock the row?

How to safely change MySQL innodb variable 'innodb_log_file_size'?

How can I optimize a mysqldump of a large database?

Possible to make MySQL use more than one core?

Performance implications of MySQL VARCHAR sizes

Should I use UUID as well as ID

Identity column re-seed: when it is necessary?

In the same query INSERT, can two VALUES being NOW() return a different time?

MySQL DELETE becomes exceptionaly slow with a large number of rows

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

Convert MySQL database from latin1 to utf8mb4 - and take care of German umlauts

Error Log Location?

Automatically purging binary logs

How do you calculate how much hardware resources you need for a database?

How to optimize very slow SELECT with LEFT JOINs over big tables

Best General Purpose Character Set and Collation for MySQL

DELETE command not completing on 30,000,000 row table

Are junction tables a good practice?

Do varchar/text/longtext columns in MySQL occupy full size in filesystem even for partially filled cells?

MySQL - UUID/created_at cursor based pagination?

How to lower "Created_tmp_disk_tables" - temporary tables count created on DISK?

Best Practice to Archive Old Data in MySQL

How to make mysqldump use /!40101 SET character_set_client = utf8mb4 /;?

Error 1366: Incorrect string value: '\xF0\x9F\x98\x8A\x0AC…' for column 'text_body' at row 1

Delete Slow Query Log File

Biggest possible double/float for a column in my MySQL database

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

mysqlcheck to optimize innodb tables -- performance/scheduling

Mysql - unknown variable 'table_cache=64'