Jump to content


Photo

MySQL configuration


  • Please log in to reply
3 replies to this topic

#1 izua

izua
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 15 September 2006 - 12:54 AM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 September 2006 - 12:34 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 izua

izua
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 16 September 2006 - 05:58 PM

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

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 16 September 2006 - 11:24 PM

Alas, I've never run MySQL on a windows box.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users