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
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
tables.
We have concurrency tests (processes loc
John G. Heim wrote:
- Original Message - From: "Darryle Steplight"
To: "Stephen Edberg"
Cc: "John G. Heim" ;
Sent: Thursday, March 05, 2009 12:53 PM
Subject: Re: best mysql optimization tutorial and/or quick start guide?
High Performance MySql "
- Original Message -
From: "Darryle Steplight"
To: "Stephen Edberg"
Cc: "John G. Heim" ;
Sent: Thursday, March 05, 2009 12:53 PM
Subject: Re: best mysql optimization tutorial and/or quick start guide?
High Performance MySql "Optimization,
High Performance MySql "Optimization, Backups, Replication, and more"
2nd Edition . Got a problem, pick a chapter and read the solution.
This book is awesome, I'm confident you will find what you are looking
for :) .
On Thu, Mar 5, 2009 at 12:30 PM, Stephen Edberg wrote:
>
&
> I've been poking around google looking for tutorials and/or quick start
> guides on optimizing the mysql server. We just upgraded our DB server from
> 2
> Gb of RAM to 16. But I don't know how to reconfigure mysql to take full
> advantage of it. Although, just installing the RAM seems to have
Configuring and optimising a MySQL server is highly dependent on your usage
of it. The most important question for you now is probably: which storage
engines do you use? Based on that, you should start configuring MySQL to
assign memory to optimise the usage of each as good as possible.
Have fun!
I've been poking around google looking for tutorials and/or quick start
guides on optimizing the mysql server. We just upgraded our DB server from 2
Gb of RAM to 16. But I don't know how to reconfigure mysql to take full
advantage of it. Although, just installing the RAM seems to have made a hug
> 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
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.
Our current server is a Dell PowerEdge 1900 a QuadCore with 1TB total (Raid 1)
of HD space and 4G RAM.
The
i am looking for mysql 5.0 optimization documents on FreeBSD 6.3-stable.
I tried to install "mytop" to see the running style of the system but
p5-DBD-mysql has been failed coz of many bugs.
And also read this section
http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html . do you have
any a
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
I have a good question, the MySQL Optimizer is broker ? see the querys:
mysql> explain select * from an where an_id in (100,200);
++-+---+---+---+---+-+--+--+-+
| id | select_type | table | type | possible_keys | key | key_le
Hi All,
Are you interested in MySQL? Do you live/work in Silicon Valley?
Join a fun group of professionals for the monthly MySQL Meetup in
Silicon Valley, held at Yahoo! in Santa Clara, California. The topic
this month is:
MySQL Optimization and the EXPLAIN command
Speaker: Jeremy
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
I'm looking for recomendations on improving system performance. Using
the SQL command below on a MySQL server I find result times averaging
three seconds. Being very inexperienced with database programming I
would appreciate any comments on whether this is expected behaviour, or
where my de
20 matches
Mail list logo