Comments on DBA Dojo: MySQL DBT2 Benchmark on EC2 part 1

Thanks for the useful dbt2 post.Just to add that i...

2009-11-27T08:51:38.096-08:00

Thanks for the useful dbt2 post.Just to add that in the stored procedure section the delivery.sql execution is missing.Don't forget to add it as a delivery prosedure.

after editing my.cnf mysql restart is very necessa...

2009-06-19T06:36:47.761-07:00

after editing my.cnf mysql restart is very necessary else it will not show the changes whatever you have made :D

Thanks for the post

2009-02-23T20:16:00.000-08:00

Thanks for the post

Thanks Jenny for the comment.

I will have t...

2008-09-17T05:11:00.000-07:00

Thanks Jenny for the comment.

I will have to try that out.
The no delay option determines the maximum possible TPM, which would indicate a ceiling of sorts for an EC2 node.... now I am even more keen to see what it is for each instance :)

It would need to set delay=0 to run the dbt2, by u...

2008-09-16T10:40:00.000-07:00

It would need to set delay=0 to run the dbt2, by using option:
./run_workload.sh -n ...
This option can increase the CPU utlization from 3%->99%, improving the TPM from arround 250TPM->7850TPM

Also DBT have a mailing list as well for specific ...

2008-01-24T17:38:00.000-08:00

Also DBT have a mailing list as well for specific support questions.

http://sourceforge.net/mail/?group_id=52479

Could be an issue with the PATH to the mysql libra...

2008-01-24T17:30:00.000-08:00

Could be an issue with the PATH to the mysql libraries.

Google is your friend...

http://lists.mysql.com/mysql/200176

Hi,

I got an error in 'make' stage,

...

2008-01-23T19:00:00.000-08:00

Hi,

I got an error in 'make' stage,

like this

[root@search-ksdb1-1 /data3/dbt2-0.40] make
make all-recursive
make[1]: Entering directory `/data3/dbt2-0.40'
Making all in .
make[2]: Entering directory `/data3/dbt2-0.40'
make[2]: Leaving directory `/data3/dbt2-0.40'
Making all in src
make[2]: Entering directory `/data3/dbt2-0.40/src'
gcc -

max_connections is dynamic, so you can change it w...

2007-09-14T16:24:00.000-07:00

max_connections is dynamic, so you can change it whilst the database is up.

SET GLOBAL MAX_CONNECTIONS = 1000;

Hi,
I am trying to change my.cnf file so that...

2007-09-14T13:59:00.000-07:00

Hi,
I am trying to change my.cnf file so that I can increase the max_connections variable. But, this doesn't seem to change as I can still see the default connection. Can you please let me know how do I change some parameters and get that effective.

Thanks,
Harita

Comments on DBA Dojo: MySQL DBT2 Benchmark on EC2 part 1

Thanks for the useful dbt2 post.Just to add that i...

after editing my.cnf mysql restart is very necessa...

Thanks for the post

Thanks Jenny for the comment.I will have t...

It would need to set delay=0 to run the dbt2, by u...

Also DBT have a mailing list as well for specific ...

Could be an issue with the PATH to the mysql libra...

Hi,I got an error in 'make' stage,...

max_connections is dynamic, so you can change it w...

Hi, I am trying to change my.cnf file so that...

Thanks Jenny for the comment.

I will have t...

Hi,

I got an error in 'make' stage,

...

Hi,
I am trying to change my.cnf file so that...