Relational Databasing on busy webserver

2008-09-22 Thread Ben A.H.
Hello, We are setting up a relatively common web application which collects "user information"... Right off the bat our system will have over 200,000 USER RECORDS so having an efficient database & lookup scheme is critical. I am a programmer/developer with some education in databasing but my for

Re: Complex SELECT

2008-09-22 Thread Andre Matos
It worked like a charm. Thanks for the help! Andre On 22-Sep-08, at 2:58 PM, Jim Lyons wrote: look at using the "group_concat" function on OptionalDesc and group by the other fields. On Mon, Sep 22, 2008 at 1:40 PM, Andre Matos <[EMAIL PROTECTED] > wrote: Hello, I need help with a SQL

Re: Complex SELECT

2008-09-22 Thread Jim Lyons
look at using the "group_concat" function on OptionalDesc and group by the other fields. On Mon, Sep 22, 2008 at 1:40 PM, Andre Matos <[EMAIL PROTECTED]>wrote: > Hello, > > I need help with a SQL Select statement: > > I have three tables: report, category, and optional > > a) "report" table has 3

Re: Ancient, unsolved high-CPU problem

2008-09-22 Thread Rene Fournier
Uptime: 1054977 Threads: 10 Questions: 15576766 Slow queries: 229 Opens: 489 Flush tables: 1 Open tables: 483 Queries per second avg: 14.765 I know what the slow queries are--some that take 20-30 seconds to compute, and they are normal. The number of open tables seems high, n

Complex SELECT

2008-09-22 Thread Andre Matos
Hello, I need help with a SQL Select statement: I have three tables: report, category, and optional a) "report" table has 3 fields: ReportId, CategoryId, ReportDesc b) "category" table has 2 fields: CategoryId, CategoryDesc c) "optional" table has three fields: OptionalId, CategoryId, Opti

Ancient, unsolved high-CPU problem

2008-09-22 Thread Rene Fournier
For the longest time, I've had a strange problem with MySQL. Basically, after a certain amount of time--sometimes a few days, sometimes a couple weeks--its CPU usage will go from a steady 20-30% to 80-90%. Actual load and number of queries is the same, nothing else changes. If I shutdown

Re: Patch for mysql

2008-09-22 Thread David Ashley
On Mon, Sep 22, 2008 at 7:54 AM, Colin Charles <[EMAIL PROTECTED]>wrote: > Nagaraj S wrote: > >> Hi Gurus, >> >> Good Day! How to apply mysql bug fixing patches or it is just updating or >> replacing some code in a c file and recompiling the source? >> > > Depending on how your patch looks like, y

Re: Patch for mysql

2008-09-22 Thread Colin Charles
Nagaraj S wrote: Hi Gurus, Good Day! How to apply mysql bug fixing patches or it is just updating or replacing some code in a c file and recompiling the source? Depending on how your patch looks like, you will use the Unix patch(1) utility or not Anyone able to supply some simple steps to

Patch for mysql

2008-09-22 Thread Nagaraj S
Hi Gurus, Good Day! How to apply mysql bug fixing patches or it is just updating or replacing some code in a c file and recompiling the source? Anyone able to supply some simple steps to patch instructions? I have mysql server running on Solaris 10 system. Thanks. Naga..

Re: Database Creation

2008-09-22 Thread Arjan Hulshoff
Hi Andrew, You can do this with MySQL Administrator, but you have to look for Catalogs in the left pane. After that right click in the bottom part of the left pain and select 'Create Schema'. Provide a database name and click on ok. That should do the trick. Arjan On Sun, 2008-09-21 at 21:26 -0