user avatar
user avatar
user avatar
RolandoMySQLDBA
  • Member for 11 years, 4 months
  • Last seen this week
  • Jersey City, NJ (USA)
688 votes
Accepted

How do you mysqldump specific table(s)?

463 votes

How do I list all databases and tables using psql?

341 votes
Accepted

How large should be mysql innodb_buffer_pool_size?

202 votes
Accepted

Is it safe to delete mysql-bin files?

144 votes
Accepted

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

140 votes
Accepted

Possible to make MySQL use more than one core?

139 votes

How can I optimize a mysqldump of a large database?

117 votes
Accepted

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

110 votes
Accepted

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

100 votes

What are the main differences between InnoDB and MyISAM?

94 votes
Accepted

How does ORDER BY FIELD() in MySQL work internally

91 votes

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

89 votes
Accepted

How to safely change MySQL innodb variable 'innodb_log_file_size'?

88 votes
Accepted

Advantages and Disadvantages to using ENUM vs Integer types?

83 votes
Accepted

Possible INDEX on a VARCHAR field in MySql

80 votes
Accepted

Restore mysql database with different name

77 votes
Accepted

MySQL Error Reading Communication Packets

76 votes
Accepted

Which is faster, InnoDB or MyISAM?

74 votes
Accepted

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

70 votes
Accepted

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

70 votes
Accepted

Why does InnoDB store all databases in one file?

67 votes
Accepted

MySQL: Create index If not exists

67 votes

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

66 votes
Accepted

Is it safe to use innodb_flush_log_at_trx_commit = 2

64 votes

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

63 votes

How could DBAs be more 'programmer friendly'?

63 votes
Accepted

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

62 votes
Accepted

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

56 votes

Why is Database Administration so hard?

51 votes
Accepted

restore table from .frm and .ibd file?

1
2 3 4 5
105