| bio | website | |
|---|---|---|
| location | Amsterdam, Netherlands | |
| age | 38 | |
| visits | member for | 1 year, 3 months |
| seen | Jun 6 at 21:36 | |
| stats | profile views | 7 |
I'm a database administrator supporting a conglomerate of high-traffic, high-volume websites on the classifieds sector.
|
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 | Refer to a table with all rows or to the table which restricts allowed rows? |
|
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? |