User RolandoMySQLDBA

735 votes

Accepted

How do you mysqldump specific table(s)?

answered Dec 16, 2011 at 20:46

512 votes

How do I list all databases and tables using psql?

answered Feb 17, 2011 at 18:30

383 votes

Accepted

How large should be mysql innodb_buffer_pool_size?

answered Oct 22, 2012 at 0:30

224 votes

Accepted

Is it safe to delete mysql-bin files?

answered Apr 26, 2013 at 21:57

172 votes

Accepted

MySQL any way to import a huge (32 GB) sql dump faster?

answered Nov 23, 2014 at 3:04

147 votes

How can I optimize a mysqldump of a large database?

answered Apr 17, 2011 at 3:31

142 votes

Accepted

Possible to make MySQL use more than one core?

answered Sep 12, 2011 at 15:35

120 votes

Accepted

What is the best way to reduce the size of ibdata in mysql?

answered Dec 9, 2011 at 6:30

115 votes

Accepted

Safest way to perform mysqldump on a live system with active reads and writes?

answered Jun 20, 2012 at 2:02

106 votes

Accepted

How does ORDER BY FIELD() in MySQL work internally

answered Aug 5, 2015 at 20:28

103 votes

What is faster, one big query or many small queries?

answered Sep 18, 2014 at 16:54

101 votes

What are the main differences between InnoDB and MyISAM?

answered Apr 14, 2011 at 21:03

95 votes

Accepted

Advantages and Disadvantages to using ENUM vs Integer types?

answered Oct 19, 2011 at 16:25

94 votes

Accepted

How to safely change MySQL innodb variable 'innodb_log_file_size'?

answered Feb 16, 2011 at 17:15

93 votes

Accepted

MySQL Error Reading Communication Packets

answered Jun 12, 2012 at 19:11

91 votes

Accepted

Possible INDEX on a VARCHAR field in MySql

answered Mar 3, 2013 at 2:57

82 votes

Accepted

Restore mysql database with different name

answered Dec 7, 2011 at 16:10

78 votes

Accepted

Which is faster, InnoDB or MyISAM?

answered May 3, 2012 at 21:32

75 votes

Accepted

InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

answered Dec 7, 2013 at 2:24

74 votes

Accepted

MySQL: Create index If not exists

answered Sep 19, 2012 at 15:12

72 votes

Accepted

Find highest level of a hierarchical field: with vs without CTEs

answered Oct 24, 2011 at 17:36

70 votes

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

answered May 10, 2011 at 21:21

70 votes

Accepted

Why does InnoDB store all databases in one file?

answered Mar 25, 2012 at 21:28

68 votes

Accepted

Is it safe to use innodb_flush_log_at_trx_commit = 2

answered Feb 10, 2012 at 5:54

68 votes

How to estimate/predict data size and index size of a table in MySQL

answered Jul 10, 2013 at 17:36

67 votes

Accepted

Is it possible to mysqldump a subset of a database required to reproduce a query?

answered Aug 15, 2011 at 22:32

65 votes

Accepted

How long is "too long" for MySQL Connections to sleep?

answered Mar 3, 2011 at 21:22

63 votes

How could DBAs be more 'programmer friendly'?

answered May 2, 2011 at 17:32

56 votes

Why is Database Administration so hard?

answered May 24, 2011 at 16:59

55 votes

Accepted

restore table from .frm and .ibd file?

answered Apr 23, 2012 at 19:33

Stack Exchange Network

3,216 Answers

How do you mysqldump specific table(s)?

How do I list all databases and tables using psql?

How large should be mysql innodb_buffer_pool_size?

Is it safe to delete mysql-bin files?

MySQL any way to import a huge (32 GB) sql dump faster?

How can I optimize a mysqldump of a large database?

Possible to make MySQL use more than one core?

What is the best way to reduce the size of ibdata in mysql?

Safest way to perform mysqldump on a live system with active reads and writes?

How does ORDER BY FIELD() in MySQL work internally

What is faster, one big query or many small queries?

What are the main differences between InnoDB and MyISAM?

Advantages and Disadvantages to using ENUM vs Integer types?

How to safely change MySQL innodb variable 'innodb_log_file_size'?

MySQL Error Reading Communication Packets

Possible INDEX on a VARCHAR field in MySql

Restore mysql database with different name

Which is faster, InnoDB or MyISAM?

InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

MySQL: Create index If not exists

Find highest level of a hierarchical field: with vs without CTEs

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

Why does InnoDB store all databases in one file?

Is it safe to use innodb_flush_log_at_trx_commit = 2

How to estimate/predict data size and index size of a table in MySQL

Is it possible to mysqldump a subset of a database required to reproduce a query?

How long is "too long" for MySQL Connections to sleep?

How could DBAs be more 'programmer friendly'?

Why is Database Administration so hard?

restore table from .frm and .ibd file?