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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
