izua
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by izua
-
-
Hello everyone, i'm andrew! I'm an amateur webdesigner, and i'm planning on making an online text-based game, just for the fun of it. I've bought a 3.0 Ghz dual core (intel) CPU, 1 gb ram and a SATA hdd (as much as i know, they're faster).
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.
Thanks, andrew
MySQL configuration
in MySQL Help
Posted
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.
Andrew