izua Posted September 15, 2006 Share Posted September 15, 2006 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 15, 2006 Share Posted September 15, 2006 I'm really not sure how windows goes about allocating resources to the mysql server... it is possible that the queries aren't that efficient, since 18min is quite a lot of time, regardless of config tweaks. Quote Link to comment Share on other sites More sharing options...
izua Posted September 16, 2006 Author Share Posted September 16, 2006 Something pretty weird happened. I tried changing the buffer and index pool for MyISAM configs, and it simply lost connection to any query (be it initiated by a script, or me, via the command line). It somehow, stopped. I had to start the service over again.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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 16, 2006 Share Posted September 16, 2006 Alas, I've never run MySQL on a windows box. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.