Jump to content

izua

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

izua's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
  2. 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
×
×
  • Create New...

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.