In the last episode (Jul 15), Tachu(R) said:
> I'm having random query slowness that i can only reproduce once. My main
> question is that the query runs faster the second time around but i dont
> have query cache enabled here is some info from mysql profiler;
>
> The time is spent mostly on the s
att.net
> To: dstepli...@gmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Slow query Performance
>
> On Wed, 15 Jul 2009 23:53:05 -0400 Darryle Steplight said:
>
> > Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
> >
> > On Wed, Jul 15, 200
On Wed, 15 Jul 2009 23:53:05 -0400 Darryle Steplight said:
> Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
>
> On Wed, Jul 15, 2009 at 6:44 PM, Tachu® wrote:
> > I'm having random query slowness that i can only reproduce once. My main
> > question is that the query runs
Can you show us the output of DESCRIBE score and SHOW INDEX FROM score?
On Wed, Jul 15, 2009 at 6:44 PM, Tachu® wrote:
> I'm having random query slowness that i can only reproduce once. My main
> question is that the query runs faster the second time around but i dont
> have query cache enabled he
I'm having random query slowness that i can only reproduce once. My main
question is that the query runs faster the second time around but i dont
have query cache enabled here is some info from mysql profiler;
The time is spent mostly on the sending data step
first time around
63 rows in set (0.5
You're still doing a full table scan with REGEX, so you'll never get
it really fast. I was thinking it would be slightly faster because of
less comparisons. It's the full table scan and no use of indexes that
you want to get away from. Without doing that, the only way to get
things faster i
Hi Brent,
Using REGEXP did not really help with the performance. I need to do
whole word matching sowould prefer not to do LIKE '%Vice President%' as
it may return ome negative results.
I separated out some of the text based columns in to a different table
using MYISAM storage engine. Using FU
Hi Green,
Scrubbing out the data is a great suggestion, I will definitely try that
out. I did try out the other option using REGEXP instead of matching
individual conditions. It definitely cleaned up the implementation, but
did not really improve the performance.
-Harini
[EMAIL PROTECTED] wrot
Hello.
> Does MYSQL provide any other option to perform text based searches? Can
> someone suggest any tips for performance tuning the database in this
> scenario?
>
Use the same queries linked with UNION instead of a lot of ORs in WHERE
clause. For example this query can't use index (at
Harini Raghavan <[EMAIL PROTECTED]> wrote on 10/04/2005
11:17:48 AM:
> Hi,
>
> I am using MYSQL 4.1 database in my J2ee application. I am facing
> performance issues with some queries that are being run on text fields.
> Since MYISAM storage engine does not support transactions(and my
> appli
Hi,
I am using MYSQL 4.1 database in my J2ee application. I am facing
performance issues with some queries that are being run on text fields.
Since MYISAM storage engine does not support transactions(and my
application requires the database tables to support transaction), I have
not been able
11 matches
Mail list logo