Raise performance to maximum

Hello,

i have a production web-based application running under MySQL 4.1.21.
I use it for an helpdesk environment.

The database is quite small, the mysqldump is about 30Megabytes, but there
are lots of query both to update and retrieve data simultaneously.

The Machine is an IBM X206 Server, Pentium 4 Xeon wiht 2Gb of RAM, Sata
Hard-Drives.

Since the size is very small, could you please suggest me some parameters in
my.ini toget the best best best configuration for Speed?

Thank you, cheers!

Francesco

On Sat, 4 Aug 2007 15:41:24 +0200, Francesco wrote:
> Hello,
>
> i have a production web-based application running under MySQL 4.1.21.
> I use it for an helpdesk environment.
>
> The database is quite small, the mysqldump is about 30Megabytes, but there
> are lots of query both to update and retrieve data simultaneously.
>
> The Machine is an IBM X206 Server, Pentium 4 Xeon wiht 2Gb of RAM, Sata
> Hard-Drives.
>
> Since the size is very small, could you please suggest me some parameters in
> my.ini toget the best best best configuration for Speed?

Is speed inadequate now?

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord

>
> Is speed inadequate now?
>


Hello Peter,

actually i bit yes, speed is inadequate; when i run some .asp pages
containing lots of query in order to make some production process, i always
wait some seconds to get the result.

I would love to speed up the DB!

Thank you cheers!

Francesco

Francesco wrote:
>> Is speed inadequate now?
>>
>
>
> Hello Peter,
>
> actually i bit yes, speed is inadequate; when i run some .asp pages
> containing lots of query in order to make some production process, i always
> wait some seconds to get the result.
>
> I would love to speed up the DB!
>
> Thank you cheers!
>
> Francesco
>
>
>

Before you can improve the speed, you need to spend time determining the
cause of the slowdown. Just changing parameters at random will probably
not get you much.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Sun, 5 Aug 2007 09:29:37 +0200, Francesco wrote:
>>
>> Is speed inadequate now?
>>
>
>
> Hello Peter,
>
> actually i bit yes, speed is inadequate; when i run some .asp pages
> containing lots of query in order to make some production process, i always
> wait some seconds to get the result.
>
> I would love to speed up the DB!

Usually one of the first steps is to start looking for queries doing
table scans unnecessarily often. With small but active databases (with
many small updates), tables scans and table locks can really burn a lot
of time. These systems may even test well with only one user, but slow
down when many users start working.

http://dev.mysql.com/doc/refman/5.0/...query-log.html has
information about how to find queries missing indexes. You will be more
interested in the --log-queries-not-using-indexes option than slow
queries themselves.

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord

You will be more
interested in the --log-queries-not-using-indexes option than slow
queries themselves.

Nice!

Can i use it with MySQL Server 4.1.12 too?

Thank you, cheers!

Francesco


"Peter H. Coffin" <hellsop@ninehells.com> ha scritto nel messaggio
news:slrnfbbsb4.c5e.hellsop@abyss.ninehells.com...
> On Sun, 5 Aug 2007 09:29:37 +0200, Francesco wrote:
>>>
>>> Is speed inadequate now?
>>>
>>
>>
>> Hello Peter,
>>
>> actually i bit yes, speed is inadequate; when i run some .asp pages
>> containing lots of query in order to make some production process, i
>> always
>> wait some seconds to get the result.
>>
>> I would love to speed up the DB!
>
> Usually one of the first steps is to start looking for queries doing
> table scans unnecessarily often. With small but active databases (with
> many small updates), tables scans and table locks can really burn a lot
> of time. These systems may even test well with only one user, but slow
> down when many users start working.
>
> http://dev.mysql.com/doc/refman/5.0/...query-log.html has
> information about how to find queries missing indexes. You will be more
> interested in the --log-queries-not-using-indexes option than slow
> queries themselves.
>
> --
> 6. I will not gloat over my enemies' predicament before killing them.
> --Peter Anspach's list of things to do as an Evil Overlord