191 reputation
113
bio website syneticon.net
location Germany
age
visits member for 2 years, 6 months
seen Jul 7 at 8:20

I am working for a company which is doing infrastructure operations and IT consulting jobs in Germany, Europe.

My sphere of activities includes virtualization topics, IP networking, storage, server operations, monitoring, backups and network security. I was awarded the Microsoft MVP title for Windows Networking for several years in the past, although my public activity on Microsoft-specific topics has declined seriously due to lack of time so it is not likely to happen again that soon.

If you need to get in touch, just mail the company: office@syneticon.net

If you are wondering about the avatar bunny, Ubisoft supplies a lot more to look at and wonder about.


Jul
7
accepted MySQL hogging memory
Jul
7
answered MySQL hogging memory
Jul
2
awarded  Curious
May
27
accepted Check if database is restored to the most recent log file
May
27
comment Check if database is restored to the most recent log file
Thanks a load for pointing me to msdb..restorehistory. This is even better than my approach as I can query for backup_start_date and compare it to the current timestamp which makes for a more robust and generic check.
May
26
comment Check if database is restored to the most recent log file
This looks promising, thank you, I'll check that out.
May
26
comment How to set up MySQL 5.6 Master- Slave Replication step by step
The latter is not replication. All replication is going to do for you is keeping your databases (somewhat) in sync. What you are asking for is a cluster (where replication can be a component, of course, but clustering has signigicantly greater complexity than just replaying binlogs).
May
26
revised Check if database is restored to the most recent log file
edited body
May
26
asked Check if database is restored to the most recent log file
May
12
awarded  Benefactor
May
12
accepted Why would MySQL do serial synchronous I/O?
May
8
comment Why would MySQL do serial synchronous I/O?
Thanks, this gives me some additional understanding of what I am seeing. Does that generally mean that MyISAM is unable to utilize more than one disk worth of IOPS for a single-threaded load? I cannot find any references to this in the docs - do you happen to have something handy?
May
6
comment Why would MySQL do serial synchronous I/O?
I've updated the data to be more coherent - it now shows MyISAM-only results from a single host so folks would not get confused.
May
6
revised Why would MySQL do serial synchronous I/O?
correcting scenario data to be all-coherent MyISAM-only
May
5
revised Why would MySQL do serial synchronous I/O?
added 53 characters in body
May
5
comment Why would MySQL do serial synchronous I/O?
@ScottLeadley the 5 ms await are mostly due to the latency of the employed storage system. I have tested this in different scenarios - from a simple 4-disk RAID10 to a tiered storage filer with a 16-disk shelf and SSD backing, the results consistently show that the I/O load is not parallelized and thus latency-bound. Which I feel is fundamentally wrong. I have added the query details to the question, but I am not yet convinced they would be of great help.
May
5
revised Why would MySQL do serial synchronous I/O?
scenario details
May
5
comment Why would MySQL do serial synchronous I/O?
@ScottLeadley thanks for looking into this. I do not think I would be able to make it "simple" - the issue only would be observable if a largeish amount of data would need to be read for a single query and it would be mostly random I/O. Tables and queries are reasonably straightforward and while I could post the DDL and Query texts, I doubt anybody would be able to reproduce it right away unless the table / index data has grown to hundreds of Megabytes.
Apr
30
comment MySQL IOPS Question
Why haven't you considered asking the publisher of the article? It is obvious that 17-20 are a rather low amount of IOPS but it would depend on the implementation if it would be a sane value or even correct under all circumstances.
Apr
30
revised Why would MySQL do serial synchronous I/O?
added 131 characters in body