Geek asks and answers

Why should we store log files and bin-log files on different paths or disks in mysql

I have a mysql database replication settings .... the location of the log file in the bin-log file is all in the same path, by default my mysql data directory.

I read that for best performance they should be stored separately.

Can anyone provide me with how this improves performance. Is there any documentation available for this. The reason why you need to do this?

+3
source share
4 answers

Mostly because reading, reading, and writing can be done almost in parallel. It is saved separately on different disks.

Linux H/W MySQL - MySQL - ​​ , SSD- SCSI, .

, !

+2

, .

+1

, binlogging SPOF, , MySQL binlog, , . , . SSD , SSD.

0

, , , . , .

, binlogs , MySQL binlog , . , , , COMMIT .

, , binlogs , datadir. Datadir RAID10 12 . . , RAID .

You don’t need to do every piece of advice someone says gives better performance, because any given tip may not make any difference to the workload of your application. You need to measure many of the performance and resource utilization metrics and come up with the right setup or customization to help bottlenecks in your workload.

There is no magic configuration that would do everything with high performance.

0
source

More articles:


All Articles