Re: good database design

[OKAN ARI]

sorry for wrong reply:(
And
> Did you do an analysis to come to this conclusion? Is it really MySQL
> that's hogging your CPU?
>
> Did you analyse what queries were bringing the server down?

The senteces above are my big problem. How can I be sure about the quesries 
making my server down Please, any link, any info, any word is important 
forme. I can't find the right start point.

Thanks
OKAN

----- Original Message ----- 
From: "Martijn Tonies" <m.tonies@stripped>
To: <mysql@stripped>
Sent: Thursday, September 22, 2005 11:25 AM
Subject: Re: good database design


> Hi,
>
> Please reply to the list and not to me personally only.
>
>> I want to explain my condition. I have a web site that habe 110onlne 
>> users
>> at same time. But cpu usage is 2.00/2.00 (p4 3.0ghzHT)
>> I think my database design is horrible because of this high cpu load.
>
> Did you do an analysis to come to this conclusion? Is it really MySQL
> that's hogging your CPU?
>
> Did you analyse what queries were bringing the server down?
>
>> SO I want to learn something about good database design. Can you suggest
> any
>> thing to me?
>
> Read a book, any book, that describes the normal forms.
>
> After that, analyse your queries and their plans and see if any indices 
> are
> needed.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>