Welcome Guest, Not a member yet? Register   Sign In
Website stops responding a few times a day, no apparent reason.
#11

[eluser]smilie[/eluser]
Hi,

MySQL replication is when you have at least 2 databases:
1 master
1 slave

All data is beeing written, edited and deleted on master database; and replication sends all data (SQL commands) to the slave. This is done to 'protect' data in case 1 sql server crashes. Some also use it for beter performance (master only does write statements, while all read comes from slave).

Anyway, mysql replication logging means that you do have replication setup. Otherwise, there would be nothing to log. So, let someone with server administration experience check up what is really going on. If you do have mysql replication, there should be a reason why this is :-)

In any case, you do can 'tweak' replication logs not to take that much space. You can also delete some older logs (i.e. older then 10 days).

MySQL replication should however not slow down your system. Master is trying to send all data almost instantly, but if it is too busy serving data, it 'holds' replication until it has more resources to do it so.

Did you enable mysql-slow-log? If not - do so. And check if you really need mysql replication. If not, disable replication and delete those logs.

Cheers,
Smilie


Messages In This Thread
Website stops responding a few times a day, no apparent reason. - by El Forum - 11-15-2010, 05:42 PM



Theme © iAndrew 2016 - Forum software by © MyBB