201 reputation
12
bio website
location Esbo, Finland
age 38
visits member for 2 years, 10 months
seen Sep 11 at 12:38

Nov
7
awarded  Yearling
Nov
12
comment Can I choose which CPUs / Cores to be used by MySQL?
stackoverflow.com/questions/2777137/… was mentioned one solution:" you can right click the process in the task manager and set the affinity. This will define which cores are allowed to run the process."
Nov
12
comment Can I choose which CPUs / Cores to be used by MySQL?
what about mysql limits, would they help you? dev.mysql.com/doc/refman/5.0/en/user-resources.html
Nov
11
comment Can I choose which CPUs / Cores to be used by MySQL?
possible duplicate serverfault.com/questions/49138/…
Nov
11
comment MySQL encryption
If possible it's better to do the encryption/decryption away from the database. This will save your database CPU and makes it harder to gain unauthorized access to data.
Nov
11
answered Help me choose a RAID level combination for a SQL Server 2008 instance
Nov
9
comment Help optimizing MySQL slow query
Maybe split it in two queries? You could actually order by wp_posts.ID DESC as it's propably same as post_date. As this field is also in wp_term_relationships you could fetch the 10 biggest from wp_term_relationships and then fetch these from wp_posts.
Nov
8
awarded  Supporter
Nov
8
awarded  Teacher
Nov
8
answered Possible attack on my SQL server?