TheDataGuy's user avatar
TheDataGuy's user avatar
TheDataGuy's user avatar
TheDataGuy
  • Member for 6 years, 2 months
  • Last seen this week
11 votes
2 answers
29k views

Best Practice to Archive Old Data in MySQL

5 votes
2 answers
2k views

MySQL - Delete with IN Clause taking more time

4 votes
2 answers
4k views

MySQL - Master to master replication without downtime in Live production

4 votes
2 answers
18k views

Mariadb - Variable 'innodb_log_file_size' is a read only variable

4 votes
1 answer
3k views

InnoDB Error - InnoDB: Error: trying to remove tablespace 264 from the cache but InnoDB: it is not there

3 votes
1 answer
2k views

How does SQL Server reuse reserved pages after deleting a table

2 votes
0 answers
148 views

Postgresql - Auto vacuum is disables in conf file, but still everyday its running

2 votes
5 answers
13k views

Delete from table in chunks

2 votes
1 answer
2k views

MySQL - Fastest restore of 1TB database

2 votes
2 answers
9k views

Percona - Unable to start mysql after restart

2 votes
0 answers
424 views

Postgresql - Primary key index getting corrupted after upgrade from 9.2 to 9.6

2 votes
1 answer
3k views

mariadb Unknown system variable 'server_uuid'

2 votes
2 answers
2k views

Unable to configure MongoDB replication without initial sync

2 votes
2 answers
5k views

Postgresql - Map a Linux user to login

2 votes
1 answer
4k views

MySQL default wait_timeout is 28800 but in my server I can see more than that value

2 votes
1 answer
17k views

MySQL Crashed - InnoDB

2 votes
2 answers
2k views

Backup and Restore SQL server files and filegroups

2 votes
0 answers
1k views

MySQL memory usage is too high - OOM

2 votes
1 answer
1k views

Mongodb - Will Bulk.find.remove() lock the collection

2 votes
1 answer
209 views

Pglogical - multiple database tables to single table

2 votes
3 answers
2k views

Postgres COPY with multiple small chunks

1 vote
2 answers
1k views

Prepared statements with pgBouncer

1 vote
1 answer
2k views

oracle - Change host to 0.0.0.0 in listener

1 vote
0 answers
483 views

PostgreSQL COPY - Generated columns cannot be used in COPY

1 vote
1 answer
286 views

PostgreSQL Generate create Foreign keys from information_schema or pg_constraint

1 vote
1 answer
450 views

Mongodb - Best Practice for TTL index on huge dataset

1 vote
0 answers
144 views

GTID ignore error on parallel replication

1 vote
2 answers
2k views

AWS RDS Post Optimisation after a huge delete

1 vote
0 answers
416 views

MHA vs Orchestrator

1 vote
0 answers
468 views

Postgresql - Can we create streaming and logical replication replication from same server