|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
|
|||||||
| New Webmasters ask "How-To" questions here. This is where other fucking Webmasters help. |
|
|
Thread Tools |
04-12-2006, 12:42 AM
|
#1 |
|
No commissions, no fees.
Industry Role:
Join Date: Apr 2003
Location: USA
Posts: 17,706
|
Any MySQL experts?
I need to optimize MySQL on my machine, let me know if I'm doing everything right in the my.cnf.
|
|
|
|
04-12-2006, 08:05 AM
|
#2 |
|
Registered User
Industry Role:
Join Date: Mar 2006
Location: North Pole
Posts: 82
|
i can help - hit me up on ICQ!
__________________
rRhino.com ...social networking for book fans... |
|
|
|
|
04-12-2006, 11:05 AM
|
#3 | |
|
No commissions, no fees.
Industry Role:
Join Date: Apr 2003
Location: USA
Posts: 17,706
|
Quote:
Ok, I'll hit you up when I get back tonight. |
|
|
|
|
|
04-14-2006, 05:28 PM
|
#4 |
|
Registered User
Join Date: Apr 2006
Posts: 11
|
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. |
|
|
|
|
04-14-2006, 08:06 PM
|
#5 | |
|
No commissions, no fees.
Industry Role:
Join Date: Apr 2003
Location: USA
Posts: 17,706
|
Quote:
That I know and do. DB design I have mastered. |
|
|
|
|
|
04-14-2006, 10:26 PM
|
#6 |
|
Registered User
Industry Role:
Join Date: Mar 2006
Location: North Pole
Posts: 82
|
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.
__________________
rRhino.com ...social networking for book fans... |
|
|
|
|
04-15-2006, 12:16 AM
|
#7 |
|
No commissions, no fees.
Industry Role:
Join Date: Apr 2003
Location: USA
Posts: 17,706
|
As I said, I need someone to look at the my.cnf.
|
|
|
|
|
04-15-2006, 12:45 AM
|
#8 |
|
Registered User
Industry Role:
Join Date: Mar 2006
Location: North Pole
Posts: 82
|
Good stuff; you can hit me up anytime on ICQ when you're ready.
__________________
rRhino.com ...social networking for book fans... |
|
|
|
|
04-16-2006, 12:17 AM
|
#9 |
|
Registered User
Join Date: Feb 2006
Location: TEH PIT
Posts: 88
|
I see the previous round of MySQL flamewars coming down all again ;)
__________________
Mike Seth - 274-570-412 <mikeseth at gmail.com> |
|
|
|
|
04-16-2006, 04:09 AM
|
#10 | |
|
No commissions, no fees.
Industry Role:
Join Date: Apr 2003
Location: USA
Posts: 17,706
|
Quote:
There isn't anything to flame about. |
|
|
|
|
|
04-16-2006, 05:33 AM
|
#11 |
|
Registered User
Join Date: Dec 2005
Posts: 32
|
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.
|
|
|
|
