-----------------------------------

Martin

Thu Apr 14, 2005 8:06 am


MySQL /etc/my.cnf tweaking

-----------------------------------

Anyone around care to help me tweak my my.cnf file for MySQL? I think I've optimized my C code as much as I can, but I still think that this'd give me a bit of a boost.

The database has a single connection from the client, takes a lot of data (about 2000 * 13 entries per minute) and no queries except for adding entries.

If anyone cares to help, I can post more details.


-----------------------------------

wtd

Thu Apr 14, 2005 1:43 pm



-----------------------------------

Use Postgres.  :)


-----------------------------------

md

Thu Apr 14, 2005 1:58 pm



-----------------------------------

or try sqlite... 
I don't know how much of a speed bost you'll get from tweaking your config file though


-----------------------------------

Martin

Thu Apr 14, 2005 2:02 pm



-----------------------------------

Thanks for the help guys...  :roll: 

Switching isn't an option at this point.


-----------------------------------

wtd

Thu Apr 14, 2005 2:06 pm



-----------------------------------

Sorry.  I'm not into micro-optimization.  You could use a setup that does absolutely no checking of anything, but that's sacrificing safety for speed.  (Which you've already done in using MySQL at all...)


-----------------------------------

rizzix

Thu Apr 14, 2005 2:10 pm



-----------------------------------

yea i dont know if you can actually optimise the app that way.. wierd.. the only thing i can see a a possilble means of optimisation is load balancing.. and that too, its not the job of the programmer but the administrator.