Linked Questions
11 questions linked to/from Is it safe to use innodb_flush_log_at_trx_commit = 2
11
votes
2
answers
36k
views
Dynamic change to innodb_flush_log_at_trx_commit
This is related to this question. It does help to get better performance for InnoDB tables.
According to MySQL manual, innodb_flush_log_at_trx_commit is a global dynamic variable. Thus, I can change ...
- 337
3
votes
2
answers
6k
views
MySQL Master-Master Replication not syncing
SETUP:
I have a WAMP MySQL Master-Master replication setup on 2 machines with sync_binlog=1 for safety.
Machine config: Windows Azure Standard 2: 2 core, 4GB RAM, Windows Server 2008, MySQL 5.6.12, ...
- 51
1
vote
1
answer
5k
views
Fastest way to do a mysqldump restore on Amazon RDS?
We need to restore a database from a 7-Gb mysqldump file to a RDS Amazon instance.
The full restore takes between 3 and 4 hours (probably because of network latency since the dump has to reside on a ...
- 1,294
3
votes
1
answer
2k
views
Database replication without locking tables
I've been asked to setup replication between master and slave database.
The aim is not to lock any tables while dumping database.
I've never setup replication but I have found this guide:
https://...
- 43
1
vote
2
answers
2k
views
Mysql sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 with replication
I'm looking into sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 to improve write performance. There is this question, but it doesn't address the specific problems with replication.
I have an ...
- 191
2
votes
1
answer
2k
views
innodb_flush settings on Amazon RDS
Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...
- 308
0
votes
1
answer
849
views
Mysql Percona 5.6 slave lags gradually
I have got into slave lag gradually say every minute it lags around 5secs on slave.
So it started morning 10AM the Seconds_behind_master was 13. Now at 4:30 PM it has reached to 560.
No variable ...
- 1,511
1
vote
1
answer
454
views
MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica
We have a Source Database of about 1TB, and a Replica on another server (similar architecture).
We have setup Master Slave replication and delay between Master and Slave is always growing since.
...
- 13
0
votes
1
answer
391
views
what is the best configuration for innodb_flush_log_at_trx_commit?
There are 3 different configuration is available for innodb_flush_log_at_trx_commit
innodb_flush_log_at_trx_commit = 0
innodb_flush_log_at_trx_commit = 1
innodb_flush_log_at_trx_commit = 2
Which ...
2
votes
1
answer
181
views
Using innodb_flush_log_at_trx_commit = 2 with RDS MultiAZ - Safe?
I understand the downsides of using the parameter setting
innodb_flush_log_at_trx_commit = 2
If you want to know more, look at another answer, for example Is it safe to use ...
- 143
2
votes
1
answer
98
views
Which hardware you suggest?
I'm completely new to buying a database hosting and I would greatly appreciate your opinion about the following situation. I just created an App and I want to go live this weekend. I want to be ...
- 123