Reputation
311
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 18
Impact
~17k people reached

  • 0 posts edited
  • 1 helpful flag
  • 12 votes cast
Dec
4
comment stress-testing MySQL slave with master's queries
@phil_w I have seen the tcpdump capture option in the docs, but the pacing-relevant option is saying This option ensures that each query takes at least Query_time (from slow query log) to execute, which, I assume, means that it won't be able to make use of tcpdump caps. Also, pcap data is even more difficult to pre-process than the slow query log.
Dec
4
comment stress-testing MySQL slave with master's queries
@RolandoMySQLDBA thanks for pointing to your posts. I did search the site already and stumbled upon most of the answers you're referencing. Unfortunately, none of them is addressing both of the issues mentioned above, which is in fact why I am asking.
Dec
3
asked stress-testing MySQL slave with master's queries
Dec
2
awarded  Notable Question
Nov
7
awarded  Popular Question
Oct
2
comment Sudden periods of performance degradation
The older release might have bugs and performance-related issues which have been fixed in the newer release and thus were not visible prior to the role-swap. As replication is asymmetric and slave-initiated, an older slave is not going to affect the master performance-wise.
Oct
2
comment Sudden periods of performance degradation
Possibly related: dba.stackexchange.com/questions/75439/…. You can take a look at what has been done for diagnosis so you could use this in your own setup even if the premise of full-text search indexes does not apply to your setup.
Sep
24
awarded  Autobiographer
Sep
6
comment MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?
The increasing replication lag might be due to replication errors. You should check your mysql server's error.log files and double-check that you have your IDs (server-id and, if applicable, server-uuid) are indeed unique throughout your replication topology.
Sep
5
revised MySQL instance stalling “doing SYNC index”
added 49 characters in body
Sep
5
revised MySQL instance stalling “doing SYNC index”
added 689 characters in body
Sep
5
revised MySQL instance stalling “doing SYNC index”
edited body
Sep
5
revised MySQL instance stalling “doing SYNC index”
added 588 characters in body
Sep
5
comment MySQL instance stalling “doing SYNC index”
ping - I suppose I have found the trigger being an update to the FTS index. Now I just need to figure out why it happens.
Sep
5
revised MySQL instance stalling “doing SYNC index”
added 879 characters in body; edited title
Sep
4
awarded  Nice Question
Sep
4
revised MySQL instance stalling “doing SYNC index”
added 100 characters in body
Sep
4
comment MySQL instance stalling “doing SYNC index”
Ronaldo, thanks, I already tried running O_DIRECT, just forgot to mention it in the respective section. @James no, writes are not stalling. MySQL itself is doing a number of writes at times of stalls (to the logs apparently), but it is waiting for something.
Sep
4
revised MySQL instance stalling “doing SYNC index”
added 1331 characters in body; edited title
Sep
3
revised MySQL instance stalling “doing SYNC index”
added 1841 characters in body