| Author |
Message |
Martin
|
 Posted: Thu Apr 14, 2005 8:06 am Post subject: 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. |
|
|
|
|
 |
Sponsor
Sponsor
|
|
|
wtd
|
| Posted: Thu Apr 14, 2005 1:43 pm Post subject: (No subject) |
|
|
Use Postgres.  |
|
|
|
|
|
md
|
| Posted: Thu Apr 14, 2005 1:58 pm Post subject: (No subject) |
|
|
or try sqlite...
I don't know how much of a speed bost you'll get from tweaking your config file though |
|
|
|
|
|
Martin
|
| Posted: Thu Apr 14, 2005 2:02 pm Post subject: (No subject) |
|
|
Thanks for the help guys... 
Switching isn't an option at this point. |
|
|
|
|
|
wtd
|
| Posted: Thu Apr 14, 2005 2:06 pm Post subject: (No subject) |
|
|
| 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
|
| Posted: Thu Apr 14, 2005 2:10 pm Post subject: (No subject) |
|
|
| 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. |
|
|
|
|
|
|
Register
Wiki
Blog
Search
Turing
Chat Room
Members
