Any MySQL experts?

[AdPatron]

I need to optimize MySQL on my machine, let me know if I'm doing everything right in the my.cnf.

[duckduckgoose]

i can help - hit me up on ICQ!

[AdPatron]

i can help - hit me up on ICQ!

Ok, I'll hit you up when I get back tonight.

[nbreaker]

if you want to optimize your mysql db, my.cnf is the wrong place to look
what you need is called database normalization - you rework all your mysql tables so you don't have any duplicate entries.. it speeds everything up
if you want we can work something out, my icq 237635572.

[AdPatron]

if you want to optimize your mysql db, my.cnf is the wrong place to look what you need is called database normalization - you rework all your mysql tables so you don't have any duplicate entries.. it speeds everything up if you want we can work something out, my icq 237635572.

That I know and do. DB design I have mastered.

[duckduckgoose]

There are many ways to optimize :

- MySQL specific stuff (like the server settings in my.cnf);
- SQL specific stuff (like database normalization in tables);
- General integrity specific stuff (like telling MySQL to optimize the tables after adding or deleting tons of rows so as to update indexes)

I guess it just depends on what you need done. Some are foundation-level stuff; others are housekeeping and maintenance, or adjusting to a higher load or added server RAM.

[AdPatron]

As I said, I need someone to look at the my.cnf.

[duckduckgoose]

Good stuff; you can hit me up anytime on ICQ when you're ready.

[Mike Seth]

I see the previous round of MySQL flamewars coming down all again ;)

[AdPatron]

I see the previous round of MySQL flamewars coming down all again ;)

There isn't anything to flame about.

[ixtractor]

I have five years experience with MySQL. I have quite a bit of knowledge about optimizing MySQL for high traffic sites. E-mail your my.cnf file to ixtractor(at)yahoo(dot)com.