On 04/03/2018 06:15 PM, Sebastien FLAESCH wrote:
On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote:
Hi all,
Looking for some configuration tips to speed execution of our non-regression
tests with MySQL.
We do pure functional testing, data persistence is not critical.
Our tests are not using a
On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote:
Hi all,
Looking for some configuration tips to speed execution of our non-regression
tests with MySQL.
We do pure functional testing, data persistence is not critical.
Our tests are not using a lot of data, but we create and drop a lot of test
> You can read a few pages from High Performance MySQL 1st edition at
> http://books.google.ca/books?id=sgMvu2uZXlsC&printsec=frontcover&dq=mysql+high+performance#PPP1,M1
> Google Books also has excerpts from other MySQL books.
You can also get the Query Optimization chapter online as a PDF from
h
At 06:44 PM 2/10/2009, Michael Dykman wrote:
On Tue, Feb 10, 2009 at 7:23 PM, Baron Schwartz wrote:
> Hi,
>
> On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote:
>> Hi All,
>>
>> I'm not sure if this question is fine, I'm new to the list and I just
have one very important question.
>> Can any
On Tue, Feb 10, 2009 at 7:23 PM, Baron Schwartz wrote:
> Hi,
>
> On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote:
>> Hi All,
>>
>> I'm not sure if this question is fine, I'm new to the list and I just have
>> one very important question.
>> Can anyone help me suggest the right optimization f
Hi,
On Tue, Feb 10, 2009 at 9:25 AM, monloi perez wrote:
> Hi All,
>
> I'm not sure if this question is fine, I'm new to the list and I just have
> one very important question.
> Can anyone help me suggest the right optimization for our company's server.
I suggest High Performance MySQL, Second
This isn't a bug, it's a missing feature. The parent query won't use indexes,
just the subquery.
There's been a lot of complaints about how it renders sub queries less than
useful.
I seem to remember that it might be fixed in 5.1, but I'm not a reliable source
of info on this.
David
Dyego
Hi,
It seems that you don't have any index on your tables.
You should at least create an index on flObjectID in all tables.
You should also use 'explain' on your query to make sure that
indexes are properly used.
Hope this helps
Joseph Bueno
John Glenn wrote:
>
>
> I'm looking for recomendatio
