Jump to content

Archived

This topic is now archived and is closed to further replies.

izua

MySQL configuration

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Alas, I've never run MySQL on a windows box.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.