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
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
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
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
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
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
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
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
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..
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
10 matches
Mail list logo