List:General Discussion« Previous MessageNext Message »
From:OKAN ARI Date:September 22 2005 8:39am
Subject:Re: good database design
View as plain text  
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
> 

Thread
connect from oracle to MYSQL.Ananda Kumar20 Sep
  • Fwd: connect from oracle to MYSQL.Ananda Kumar21 Sep
    • Re: connect from oracle to MYSQL.Pooly21 Sep
      • Re: connect from oracle to MYSQL.Ananda Kumar21 Sep
        • Re: connect from oracle to MYSQL.Ananda Kumar22 Sep
          • Re: connect from oracle to MYSQL.Pooly22 Sep
            • Re: connect from oracle to MYSQL.Ananda Kumar22 Sep
  • good database designOKAN ARI22 Sep
  • Re: good database designMartijn Tonies22 Sep
    • RE: good database designTim Hayes22 Sep
      • Re: good database designMartijn Tonies22 Sep
        • Re: good database designJigal van Hemert22 Sep
      • Re: good database designDBA)22 Sep
      • Re: good database designMartijn Tonies22 Sep
  • Re: good database designMartijn Tonies22 Sep
  • Re: good database designOKAN ARI22 Sep
RE: good database designSujay Koduri22 Sep
  • RE: good database designTim Hayes22 Sep
    • Re: good database designMartijn Tonies22 Sep
  • RE: good database designGilles MISSONNIER22 Sep
RE: good database designSujay Koduri22 Sep