Posted 15 September 2006 - 12:54 AM
I've recently tried some big queries on mysql (adding 50000 rows in a table, 10k rows in another, and adding an element from the second table to the first, depending on a part of a column in the first table. I guess this is not really relevant). I was really surprised to see it using under 32megs of ram, and less then 2% cpu power. The whole script took around 30 minutes, which i think it's pretty much for this system.
at this point, I realised the database was on the old (not sata). Moved it on the other SATA hdd, which resulted in a timeframe of ~18 mins for the same query. I wish mysql would use at least half of the system's capacity for mysql.
Any hints on what variables should i change in the mysql configuration?
Edit: oh, and i'm under win. please, no replies like "upgrade to linux", i'm using this box from time to time with Guitar Rig (VST plugin), and i'm not aware of a linux variant for it.
Posted 15 September 2006 - 12:34 PM
Posted 16 September 2006 - 05:58 PM
I believe windows limits the maximum memory size available to a program? Does anyone has any idea on MySQL tweaks?
I also tried reinstalling it, and configuring it as a dedicated machine, and nothing, service wouldn't start. Starting it from services.msc would result in "Abnormal program termination". That's what makes me believe it was somehow killed by windows.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users