user avatar
user avatar
user avatar
Dave Rix
  • Member for 11 years, 4 months
  • Last seen more than a month ago
14 votes
Accepted

One Big Database vs. Several Smaller Ones

5 votes

"Copying to tmp table" extremely slow

5 votes
Accepted

Check if DISTINCT is really necessary

5 votes
Accepted

Scalable table structure for periodically updated stats that get aggregated over time

4 votes

Creating partitions on a production database

4 votes

What is the best approach to run a DELETE query on 92K of 4 million rows?

4 votes
Accepted

MySQL Replication question

4 votes

MySQL: 2 separate queries run very fast, combined query with OR runs very slow

3 votes

Multiple tables entry with current timestamp

3 votes

Need to Check if a Table Exists Before Deleting a Record

3 votes

Dynamically changeable database

3 votes
Accepted

MySQL Partitioning

3 votes

Optimized my.cnf for high-end and busy server

2 votes
Accepted

MySQL Replication via DNS Failure

2 votes

MySQL ignoring some params from my.cnf

2 votes

MySQL replication problem: slave has become out of sync

2 votes

Database-backed website configuration

2 votes

MySQL, foreign key, can't create table error 150

2 votes

How to convert MySQL Keyword to normal column

2 votes
Accepted

How can I get the maxium number of concurrent connections to MySQL over a specific time interval?

2 votes
Accepted

MySQL InnoDB Plugin default engine type not accepting config setting

2 votes

Amazon RDS low in memory no mysql connections

2 votes

Mysql consumes a lot of memory

2 votes

Is it good idea to use RAID 1 mirroring to back up database content

2 votes
Accepted

How to change query_cache_type to 2 in AWS RDS?

2 votes
Accepted

How do I efficiently partition a large MySQL (Aurora) table with multiple search columns?

2 votes

Rename the database name through terminal

2 votes

MySQL 5.6 to 5.7 In-Place Upgrade or Fresh Install?

1 vote

Index over multiple fields

1 vote

Possible aproach for MySQL replication