User RolandoMySQLDBA

688 votes

Accepted

How do you mysqldump specific table(s)?

answered Dec 16, 2011 at 20:46

463 votes

How do I list all databases and tables using psql?

postgresql tools psql command-line

answered Feb 17, 2011 at 18:30

341 votes

Accepted

How large should be mysql innodb_buffer_pool_size?

mysql innodb database-recommendation

answered Oct 22, 2012 at 0:30

202 votes

Accepted

Is it safe to delete mysql-bin files?

mysql replication mysql-5 binlog

answered Apr 26, 2013 at 21:57

144 votes

Accepted

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

mysql backup innodb mysqldump

answered Nov 23, 2014 at 3:04

140 votes

Accepted

Possible to make MySQL use more than one core?

mysql performance innodb mysql-5.5 tuning

answered Sep 12, 2011 at 15:35

139 votes

How can I optimize a mysqldump of a large database?

mysql performance innodb backup mysqldump

answered Apr 17, 2011 at 3:31

117 votes

Accepted

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

mysql innodb

answered Dec 9, 2011 at 6:30

110 votes

Accepted

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

mysql backup mysqldump linux

answered Jun 20, 2012 at 2:02

100 votes

What are the main differences between InnoDB and MyISAM?

mysql innodb myisam

answered Apr 14, 2011 at 21:03

94 votes

Accepted

How does ORDER BY FIELD() in MySQL work internally

mysql order-by fields

answered Aug 5, 2015 at 20:28

91 votes

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

mysql postgresql performance query-performance join

answered Sep 18, 2014 at 16:54

89 votes

Accepted

How to safely change MySQL innodb variable 'innodb_log_file_size'?

mysql innodb myisam logs

answered Feb 16, 2011 at 17:15

88 votes

Accepted

Advantages and Disadvantages to using ENUM vs Integer types?

mysql database-design datatypes

answered Oct 19, 2011 at 16:25

83 votes

Accepted

Possible INDEX on a VARCHAR field in MySql

mysql index full-text-search varchar

answered Mar 3, 2013 at 2:57

80 votes

Accepted

Restore mysql database with different name

mysql backup restore mysqldump mysql-5

answered Dec 7, 2011 at 16:10

77 votes

Accepted

MySQL Error Reading Communication Packets

mysql mysql-5.5

answered Jun 12, 2012 at 19:11

76 votes

Accepted

Which is faster, InnoDB or MyISAM?

mysql innodb myisam storage-engine

answered May 3, 2012 at 21:32

74 votes

Accepted

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

mysql innodb mysql-5.5 mysql-5.6 mysql-5

answered Dec 7, 2013 at 2:24

70 votes

Accepted

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

mysql hierarchy

answered Oct 24, 2011 at 17:36

70 votes

Accepted

Why does InnoDB store all databases in one file?

mysql innodb mysql-5.5 mysqldump myisam

answered Mar 25, 2012 at 21:28

67 votes

Accepted

MySQL: Create index If not exists

mysql index if-not-exists

answered Sep 19, 2012 at 15:12

67 votes

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

mysql index innodb

answered Jul 10, 2013 at 17:36

66 votes

Accepted

Is it safe to use innodb_flush_log_at_trx_commit = 2

mysql performance innodb

answered Feb 10, 2012 at 5:54

64 votes

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

mysql performance innodb varchar

answered May 10, 2011 at 21:21

63 votes

How could DBAs be more 'programmer friendly'?

database-design best-practices

answered May 2, 2011 at 17:32

63 votes

Accepted

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

mysql mysql-5

answered Mar 3, 2011 at 21:22

62 votes

Accepted

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

mysql backup join select mysqldump

answered Aug 15, 2011 at 22:32

56 votes

Why is Database Administration so hard?

learning management

answered May 24, 2011 at 16:59

51 votes

Accepted

restore table from .frm and .ibd file?

mysql innodb

answered Apr 23, 2012 at 19:33

Stack Exchange Network

current community

your communities

more stack exchange communities

3,127 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?

Possible to make MySQL use more than one core?

How can I optimize a mysqldump of a large database?

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?

What are the main differences between InnoDB and MyISAM?

How does ORDER BY FIELD() in MySQL work internally

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

How to safely change MySQL innodb variable 'innodb_log_file_size'?

Advantages and Disadvantages to using ENUM vs Integer types?

Possible INDEX on a VARCHAR field in MySql

Restore mysql database with different name

MySQL Error Reading Communication Packets

Which is faster, InnoDB or MyISAM?

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

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

Why does InnoDB store all databases in one file?

MySQL: Create index If not exists

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

Is it safe to use innodb_flush_log_at_trx_commit = 2

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

How could DBAs be more 'programmer friendly'?

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

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

Why is Database Administration so hard?

restore table from .frm and .ibd file?