60 reputation
7
bio website
location Amsterdam, Netherlands
age 39
visits member for 2 years, 8 months
seen Aug 14 at 16:01

I'm a database administrator supporting a conglomerate of high-traffic, high-volume websites on the classifieds sector.


Sep
24
awarded  Autobiographer
Aug
4
accepted How to Correctly Estimate the Average Number of I/O Operations my RAID 10 disk can offer?
Aug
1
awarded  Popular Question
Oct
15
awarded  Informed
Sep
24
accepted Why is MySQL database data-files deployed under /var/lib/mysql?
Sep
23
asked Why is MySQL database data-files deployed under /var/lib/mysql?
May
8
awarded  Scholar
May
8
accepted What causes InnoDB to write 100% more pages while slowing down answering queries?
Mar
6
answered How to properly kill MySQL?
Mar
5
comment Enable MySQL to use more than 1 core (multicore)
@RolandoMySQLDBA I believe there's a misunderstanding here. MySQL won't divide a single query's work between different Server Threads, and one Server Thread won't ever use more than one CPU core at any given point-in-time. Therefore, if (as the question states) there's only one query to run, the maximum number of CPU cores a MySQL Server can get working on the problem is 1: one thread must take care of the query, and one CPU core will be used to run the process.
Mar
4
awarded  Teacher
Mar
4
answered Enable MySQL to use more than 1 core (multicore)
Mar
4
answered What causes InnoDB to write 100% more pages while slowing down answering queries?
Mar
1
awarded  Supporter
Mar
1
comment How to Correctly Estimate the Average Number of I/O Operations my RAID 10 disk can offer?
I'm sorry, but it's exactly because I cannot afford working with guesses that I've posted the question.
Feb
28
asked How to Correctly Estimate the Average Number of I/O Operations my RAID 10 disk can offer?
Feb
27
asked What causes InnoDB to write 100% more pages while slowing down answering queries?
Mar
2
awarded  Student
Mar
2
asked MySQL Cluster over WAN: Best Architecture Options?