58 reputation
5
bio website
location Amsterdam, Netherlands
age 38
visits member for 2 years, 1 month
seen Dec 5 '13 at 10:47

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


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?