347 reputation
18
bio website
location
age
visits member for 4 years, 6 months
seen Dec 17 '12 at 22:09

Aug
30
answered Any pitfalls for replicating MySQL to a remote server
Apr
17
comment Sync SSD to spindle drive using RAID or DRBD
He could see a performance hit on random/sequential writes with a fully synchronous setup. SSDs are just absolutely crushing spindled drives in every category including write performance. The only 2 categories HDDs have over SSDs are still price and reliability.
Jan
6
comment How to drop all tables in a MySQL database without dropping the database?
Would you consider revising your answer to include the proper commands and procedure then?
Jan
5
comment How to drop all tables in a MySQL database without dropping the database?
Extremely bad idea for any non-trivial setup as MySQL is not expecting these files to suddenly disappear and could be in the middle of any number of operations, transactions, replication, locks...
Nov
30
awarded  Tumbleweed
Oct
20
comment Delegating Windows permissions to different groups of administrators
@Harvey - As indicated by syneticon-dj it will be MORE work to accomplish what you want with your current configuration and your users will STILL find ways to break out. The most secure, viable path I see is to have 1 role per server.
Oct
19
comment Delegating Windows permissions to different groups of administrators
Can you split the servers so each server does exactly one job? Then you dont have to worry about the DBA accidentally touching the IIS stuff because thats a different server. Virtual servers could help here.
Sep
26
comment What is Linux process 'SMBD' running on my server?
@JM4 - samba is not related to apache at all. You would edit the system startup configuration to disable smbd (and its compliment nmbd).
Aug
24
comment How many partitions should we create if there are around 100 millions rows
@N.B - Its not true that there will be no benefit at all if its all on the same disk. The concept of "partition pruning" can speed up queries dramatically. Smaller per-partition indexes will have another benefit as well. He'll be better off with multiple disks but partitioning is about more than just that.
Aug
22
awarded  Critic
Jun
29
awarded  Yearling
Jun
20
revised Quick method to determine SSD drive health?
spelling + grammar
Jun
20
answered Quick method to determine SSD drive health?
Jun
10
answered Has anyone achieved true differential sync with rsync in ESXi?
Jun
6
awarded  Scholar
Jun
6
accepted What is a “virtual context switch”
Jun
2
awarded  Student
Jun
2
awarded  Commentator
Jun
2
comment What is a “virtual context switch”
No, I suppose I'm overthinking it. Its exactly like a regular context switch but on a virtual processor. A process running on a VP hasn't completed but the hypervisor is deciding to evict it for another process so must save the state of the first process. Right?
Jun
2
comment What is a “virtual context switch”
So does that mean that when a VP has no more work to do a virtual context switch is recorded when it gives up its remaining time to any other VPs that need it? I'm trying to diagnose what seeing 500,000 (yes half a million) virtual context switches on a badly behaving machine means exactly.