Introduction

The my.cnf option rpl_event_checksums enables the use of binlog event checksums. Note that both slaves and masters must used this patch when this is enabled. It is disabled by default.

Details

From tests I ran in the past, the use of checksums reduced performance by 10%. For tests that I run today it reduces performance by 3% to 7% at high levels of concurrency. The checksum is computed with crc32. The use of adler32 from zlib in place of crc32 does not change performance. These are results from sysbench readwrite on a 16-core server for 1 to 64 concurrent users:

checksum	1 user	2 users	4 users	8 users	16 users	32 users	64 users
none	170	379	702	1113	1227	1191	1103
crc32	171	371	688	1064	1205	1153	1067

Comment by newsms.year10, Jan 23, 2010

Sending SMS is a great fun for the youngsters. Get paid for receiving SMS and Email too. You can even earn money by accessing the service. Sending free SMS from the Internet isn’t a new idea at all and companies have been developing the bridge between email and SMS for years. By now it’s a simple and easy service to set up and companies have started adding these services as a feature to bring in eyeballs.

► Sign in to add a comment