Re: MySQL optimization for testing purpose

[Sebastien FLAESCH]

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 lot of data, but we create and drop a lot of test 
tables.

We have concurrency tests (processes locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, 
sometimes
it takes only 15 seconds...


In fact this tests creates and drops ~150 times the same table, having a single 
column
using different types each time.

I can clearly see that sometimes table creations are fast, but from time to 
time it
slows down to about a second to create a table.



How can this happen?

Any log I could enable and provide here?

Thanks in advance!
Seb






FYI, have tried following settings, but it did not help:

innodb_stats_auto_recalc=0
innodb_file_per_table=0
innodb_stats_persistent=0

I have recreated my database after restarting the server.

Server version: 8.0.4-rc-log MySQL Community Server (GPL)

Seb

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL optimization for testing purpose

[Sebastien FLAESCH]

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 
tables.

We have concurrency tests (processes locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, 
sometimes
it takes only 15 seconds...


In fact this tests creates and drops ~150 times the same table, having a single 
column
using different types each time.

I can clearly see that sometimes table creations are fast, but from time to 
time it
slows down to about a second to create a table.



How can this happen?

Any log I could enable and provide here?

Thanks in advance!
Seb




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

MySQL optimization for testing purpose

[Sebastien FLAESCH]

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 locking rows), so this feature matters.

Are there some InnoDB params to enable or disable to speed up our tests?

Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, 
sometimes
it takes only 15 seconds...

How can this happen?

Any log I could enable and provide here?

Thanks in advance!
Seb

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Enterprise Monitor Testing

[Claudio Nanni]

Hi,
If things are still as before,
you get MEM only if you have a support contract with Oracle,
so it would make more sense to ask Oracle.
They make that product, they know better how it works, they can help you
better, and you are entitled to get that help.
Consider that the users of the Community MySQL version do not have MEM,
so you will find a very small percentage of people that used that (I am in
this small percentage).

Cheers

Claudio



2012/11/11 Bheemsen Aitha 

> Hi list,
>
> I just installed MySQL Enterprise Monitor (MEM) to monitor our MySQL NDB
> cluster. Per our company policies, I need to test all MEM advisors for all
> metrics. Did anyone do this before? Any there any tools to test the
> advisors in MEM? I appreciate if anyone can share their experiences with
> MEM.
>
> Thanks
> BA
>



-- 
Claudio

MySQL Enterprise Monitor Testing

[Bheemsen Aitha]

Hi list,

I just installed MySQL Enterprise Monitor (MEM) to monitor our MySQL NDB
cluster. Per our company policies, I need to test all MEM advisors for all
metrics. Did anyone do this before? Any there any tools to test the
advisors in MEM? I appreciate if anyone can share their experiences with
MEM.

Thanks
BA

RE: Question about testing memcmp()

[Stillman, Benjamin]

By recent security breach, do you mean the issue with passwords? If so: 
http://www.dbasquare.com/2012/06/11/a-security-flaw-in-mysql-authentication-is-your-system-vulnerable/

for i in `seq 1 2000`; do mysql -u USERNAME --password=INCORRECTPASSWORD -h 
HOSTNAME ; done

If you get in using that, you're vulnerable.

But as Harald said, why not just update? Always better to be patched and 
up-to-date.


Ben Stillman
bstill...@limitedbrands.com


-Original Message-
From: Sabika Makhdoom [mailto:sabika.makhd...@gmail.com]
Sent: Monday, June 25, 2012 12:17 AM
To: mysql@lists.mysql.com
Subject: Question about testing memcmp()

I want to test our memcmp() binaries to see if we have the mysql binaries that 
are impacted by the recent security breach. How do I test it?

Thanks


Life was meant to be mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql




Notice: This communication may contain privileged and/or confidential 
information. If you are not the intended recipient, please notify the sender by 
email, and immediately delete the message and any attachments without copying 
or disclosing them. LBI may, for any reason, intercept, access, use, and 
disclose any information that is communicated by or through, or which is stored 
on, its networks, applications, services, and devices.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Question about testing memcmp()

[Reindl Harald]

Am 25.06.2012 06:17, schrieb Sabika Makhdoom:
> I want to test our memcmp() binaries to see if we have the mysql binaries 
> that are impacted by the recent security breach. How do I test it?

why do you simply not update?



signature.asc
Description: OpenPGP digital signature

Question about testing memcmp()

[Sabika Makhdoom]

I want to test our memcmp() binaries to see if we have the mysql binaries that 
are impacted by the recent security breach. How do I test it?

Thanks


Life was meant to be mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

[X-POST] Free sample data (US & Canada) for testing

[Brian Dunning]

Hey all -

I've just uploaded some free Canada sample data to complement the US data that 
was already available. Testing apps with a representation amount of sample data 
is crucial to evaluate performance. Download the data here:

http://www.briandunning.com/sample-data/

Enjoy,
- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: unauthenticated user | while load testing

[Carsten Pedersen]

Usually this is caused by DNS-based authentication, where the 
reverse-DNS lookups are hanging for one reason or another.


If you can, switch to IP-based authentication and use --skip-name-resolve.

/ Carsten

On 05.01.2011 08:26, Yogesh Kore wrote:

Hi,

What is unauthenticated user seen in mysql processlist ?

I am doing load testing and at a single time more than 1000 users are coming
to mysql server.

Do any one have idea about it?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

unauthenticated user | while load testing

[Yogesh Kore]

Hi,

What is unauthenticated user seen in mysql processlist ?

I am doing load testing and at a single time more than 1000 users are coming
to mysql server.

Do any one have idea about it?

Replication testing?

[Machiel Richards]

Hi All

 

One of the managers requested me to find out about the
replication testing on MySQL as one of our clients need this to be done
soon.

 

Basically what they want to do is the following:

 

. Currently a master slave replication is in place.

. Testing will entail the following:

o   Stop master database 

o   Switch over to Slave database and confirm everything is working as
should and all Data is available.

o   Switch back to master database after it has been restored 

o   Confirm that all is working again and that all data are available on
both databases.

 

I am not yet to this part of my studying as I am fairly new to MySQL and I
am hoping someone can perhaps provide me with some info / resources on where
to get this info from.

 

Machiel Richards

MySQL DBA

Relational Database Consulting 

 

RDC_Logo

 

MySQL University session on April 30: Testing multiple servers with MySQL

[Stefan Hinz]

Testing multiple servers with MySQL
http://forge.mysql.com/wiki/Testing_Multiple_Servers_With_MySQL_Sandbox

This Thursday (April 30th, 14:00 UTC), Giuseppe Maxia will give a MySQL
University session on Testing Multiple Servers With MySQL Sandbox.
Giuseppe is the creator of MySQL Sandbox, and has recently announced a
new Sandbox version and other interesting changes, for example the
--query-analyzer option to make_sandbox (but note the date when this was
announced!).

For MySQL University sessions, point your browser to this page:

http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity

You need a browser with a working Flash plugin. You may register for a
Dimdim account, but you don't have to. (Dimdim is the conferencing
system we're using for MySQL University sessions. It provides integrated
voice streaming, chat, whiteboard, session recording, and more.)

MySQL University is a free educational online program for
engineers/developers. MySQL University sessions are open to anyone, not
just Sun employees. Sessions are recorded (slides and audio), so if you
can't attend the live session you can look at the recording anytime
after the session.

Here's the schedule for the upcoming weeks:

* April 30, 2009: Testing Multiple Servers With MySQL Sandbox (Giuseppe
Maxia)
* May 7, 2009: MySQL Replication: Walk-through of the new 5.1 and 6.0
features (Lars Thalmann)
* May 14, 2009 (tentative): Programming Towards Multi-Core CPUs (Mikael
Ronström)
* May 21, 2009: No session scheduled
* May 28, 2009: No session scheduled
* June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning
(Giuseppe Maxia)
* June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
* June 18, 2009:  Architecture of MySQL Backup (Lars Thalmann)
* July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial
(Roland Bouman)

The schedule is not engraved in stone at this point. Please visit
http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the
up-to-date list. On that page, you can also find the starting time for
many time zones.

Cheers,

Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.de/mysql  mailto: stefan.h...@sun.com

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

MySQL University session on October 30: Quick and Easy Testing With MySQL Sandbox

[Stefan Hinz]

The next MySQL University session will take place this Thursday, 30th
October. Giuseppe Maxia will get you up to speed with using MySQL
Sandbox for quick and easy testing of MySQL.

This session will start at 15:00 Central European Time (14:00 UTC, 14:00
BST).

MySQL University is an educational program run virtually on the 'net.
Sessions are open to anyone. MySQL University focuses on MySQL internals
and on Sun technology that can be used in connection with MySQL, but
we're open to hear your suggestions for other topics.

We'll be using the Dimdim conferencing system for this session. Dimdim
has integrated voice streaming and chat. To attend, you need a browser
with a recent Flash plugin. You may register a Dimdim account but you
don't have to.

The virtual meeting room will be opened about 15 minutes before the
hour. Point your browser to this address:
http://webmeeting.dimdim.com/portal/[EMAIL PROTECTED]


Related URLs:
- MySQL University: http://forge.mysql.com/wiki/MySQL_University
- http://forge.mysql.com/wiki/Quick_and_Easy_Testing_With_MySQL_Sandbox

-Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.de/mysql  mailto: [EMAIL PROTECTED]

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Corrupting MySQL on purpose for testing

[Russell E Glaue]

Try putting the data directory on a small partition and let it get filled 100%
with a single update that does not get fully committed due to disk full, then
turn the power off to the computer so there is no attempt for a nice shutdown.
You should also get a corruption in the master binary logs, if binary logging is
turned on.

If you use VMWare (vmware server is free) to virtualize a test OS with small
drives, it will be easier to do this.

-RG


Richard Edward Horner wrote:
> Hi,
> 
> I'm working on a program that will run in the event that tables are
> crashed or corrupt. Can anyone recommend a good method for crashing my
> tables or corrupting them so I have some test cases? I'm mostly
> interested in MyISAM and InnoDB table types.
> 
> I was thinking I would just start an infinite loop with an UPDATE
> statement in it and then kill -9 the mysqld process.
> 
> Any better ideas?
> 
> Thanks, Rich(ard)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Corrupting MySQL on purpose for testing

[mos]

At 05:22 PM 11/6/2007, you wrote:

Hi David,

Thanks for your reply. This helped greatly.

Yeah, I supposed I could just randomly flip bits in the MySQL files
and that would do the trick.

The program I'm writing does first attempt to repair the tables with
MySQL's utilities if they're MyISAM but InnoDB tables don't support
repair and this program is actually meant to be a potential stop-gap
solution in the event of hardware errors in a non-failover situation
which can do really horrible things like corrupt InnoDB inodes thus
rendering tables unusable to keep clients seeing SOMETHING (even if
it's stale data) until the hardware can be swapped out.

Speaking of which, can anyone think of a reason that InnoDB tables
would corrupt aside from hardware problems or a bug in the storage
engine?


David,
Bad network cards could corrupt the data or flaky memory.

Here are a few links that deal with InnoDb corruption.

http://www.mysqlperformanceblog.com/2006/07/30/mysql-crash-recovery/
http://www.mysqlperformanceblog.com/2007/05/22/magic-innodb-recovery-self-healing/
http://www.google.ca/search?hl=en&q=innodb+corruption+causes&btnG=Search&meta=

Mike




On Nov 6, 2007 6:04 PM, David T. Ashley <[EMAIL PROTECTED]> wrote:
> On 11/6/07, mos <[EMAIL PROTECTED]> wrote:
> >
> > At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
> > >Hi,
> > >
> > >I'm working on a program that will run in the event that tables are
> > >crashed or corrupt. Can anyone recommend a good method for crashing my
> > >tables or corrupting them so I have some test cases? I'm mostly
> > >interested in MyISAM and InnoDB table types.
> > >
> > >I was thinking I would just start an infinite loop with an UPDATE
> > >statement in it and then kill -9 the mysqld process.
> > >
> > >Any better ideas?
>
>
> Well, there are different types of corruption.  Here are a few that come to
> mind:
>
> a)Corruption of a MySQL file, perhaps not repairable (disk hardware 
problem,

> OS crash, server power supply failure).
>
> b)Corruption in a way that is repairable by a MySQL utility (index file
> corrupted).
>
> c)Application corruption (bad application doesn't handle mutual exclusion
> correctly, has logical errors, etc.).
>
> Hopefully database repair utilities that come with MySQL will map (a) and
> (b) to be indistinguishable from (c).  (But I don't know that--I'm barely a
> MySQL user.)
>
> The most even-handed way to do it would seem to be:
>
> a)Write a program that will create a random number of distributed and block
> corruptions distributed randomly in the MySQL files.  (Such a program would
> take very little time to execute--well under half a second, I'm guessing.)
> You might want to throw in truncations and blocks added at the end of 
files,

> too.
>
> b)See how far the MySQL utilities (if there are any) followed by your
> software will go towards repair.
>
> Doesn't seem like an easy thing to test.
>



--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Corrupting MySQL on purpose for testing

[Richard Edward Horner]

Hi David,

Thanks for your reply. This helped greatly.

Yeah, I supposed I could just randomly flip bits in the MySQL files
and that would do the trick.

The program I'm writing does first attempt to repair the tables with
MySQL's utilities if they're MyISAM but InnoDB tables don't support
repair and this program is actually meant to be a potential stop-gap
solution in the event of hardware errors in a non-failover situation
which can do really horrible things like corrupt InnoDB inodes thus
rendering tables unusable to keep clients seeing SOMETHING (even if
it's stale data) until the hardware can be swapped out.

Speaking of which, can anyone think of a reason that InnoDB tables
would corrupt aside from hardware problems or a bug in the storage
engine?

Thanks, Rich(ard)

On Nov 6, 2007 6:04 PM, David T. Ashley <[EMAIL PROTECTED]> wrote:
> On 11/6/07, mos <[EMAIL PROTECTED]> wrote:
> >
> > At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
> > >Hi,
> > >
> > >I'm working on a program that will run in the event that tables are
> > >crashed or corrupt. Can anyone recommend a good method for crashing my
> > >tables or corrupting them so I have some test cases? I'm mostly
> > >interested in MyISAM and InnoDB table types.
> > >
> > >I was thinking I would just start an infinite loop with an UPDATE
> > >statement in it and then kill -9 the mysqld process.
> > >
> > >Any better ideas?
>
>
> Well, there are different types of corruption.  Here are a few that come to
> mind:
>
> a)Corruption of a MySQL file, perhaps not repairable (disk hardware problem,
> OS crash, server power supply failure).
>
> b)Corruption in a way that is repairable by a MySQL utility (index file
> corrupted).
>
> c)Application corruption (bad application doesn't handle mutual exclusion
> correctly, has logical errors, etc.).
>
> Hopefully database repair utilities that come with MySQL will map (a) and
> (b) to be indistinguishable from (c).  (But I don't know that--I'm barely a
> MySQL user.)
>
> The most even-handed way to do it would seem to be:
>
> a)Write a program that will create a random number of distributed and block
> corruptions distributed randomly in the MySQL files.  (Such a program would
> take very little time to execute--well under half a second, I'm guessing.)
> You might want to throw in truncations and blocks added at the end of files,
> too.
>
> b)See how far the MySQL utilities (if there are any) followed by your
> software will go towards repair.
>
> Doesn't seem like an easy thing to test.
>



-- 
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Corrupting MySQL on purpose for testing

[David T. Ashley]

On 11/6/07, mos <[EMAIL PROTECTED]> wrote:
>
> At 02:18 PM 11/6/2007, Richard Edward Horner wrote:
> >Hi,
> >
> >I'm working on a program that will run in the event that tables are
> >crashed or corrupt. Can anyone recommend a good method for crashing my
> >tables or corrupting them so I have some test cases? I'm mostly
> >interested in MyISAM and InnoDB table types.
> >
> >I was thinking I would just start an infinite loop with an UPDATE
> >statement in it and then kill -9 the mysqld process.
> >
> >Any better ideas?


Well, there are different types of corruption.  Here are a few that come to
mind:

a)Corruption of a MySQL file, perhaps not repairable (disk hardware problem,
OS crash, server power supply failure).

b)Corruption in a way that is repairable by a MySQL utility (index file
corrupted).

c)Application corruption (bad application doesn't handle mutual exclusion
correctly, has logical errors, etc.).

Hopefully database repair utilities that come with MySQL will map (a) and
(b) to be indistinguishable from (c).  (But I don't know that--I'm barely a
MySQL user.)

The most even-handed way to do it would seem to be:

a)Write a program that will create a random number of distributed and block
corruptions distributed randomly in the MySQL files.  (Such a program would
take very little time to execute--well under half a second, I'm guessing.)
You might want to throw in truncations and blocks added at the end of files,
too.

b)See how far the MySQL utilities (if there are any) followed by your
software will go towards repair.

Doesn't seem like an easy thing to test.

Re: Corrupting MySQL on purpose for testing

[mos]

At 02:18 PM 11/6/2007, Richard Edward Horner wrote:

Hi,

I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases? I'm mostly
interested in MyISAM and InnoDB table types.

I was thinking I would just start an infinite loop with an UPDATE
statement in it and then kill -9 the mysqld process.

Any better ideas?


Sure, power off the computer or throw the breakers when doing updates to 
simulate a power failure. That's sure to work. :)


Mike  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Corrupting MySQL on purpose for testing

[Richard Edward Horner]

Hi,

I'm working on a program that will run in the event that tables are
crashed or corrupt. Can anyone recommend a good method for crashing my
tables or corrupting them so I have some test cases? I'm mostly
interested in MyISAM and InnoDB table types.

I was thinking I would just start an infinite loop with an UPDATE
statement in it and then kill -9 the mysqld process.

Any better ideas?

Thanks, Rich(ard)
-- 
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Testing Email

[Nicholas Vettese]

Who knew this list had so many funny people.  And I came here for the
serious folks.  Take me off this list!  ;)

Thanks for all the help peoples

-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 25, 2006 10:46 AM
To: mysql@lists.mysql.com
Subject: Re: Testing Email

INSERT INTO a VALUES (NOW()) ?


Regards,
Chris.

- Original Message - 
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc: 
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email


> Nicholas Vettese wrote:
>> I have been having problems with my email, and I wanted to test to
this
>> list.
>
> Will let you know when I receive it...
>
> --renato
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Email

[Chris Knipe]

INSERT INTO a VALUES (NOW()) ?


Regards,
Chris.

- Original Message - 
From: "Renato Golin" <[EMAIL PROTECTED]>

To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc: 
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email



Nicholas Vettese wrote:

I have been having problems with my email, and I wanted to test to this
list.


Will let you know when I receive it...

--renato

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Email

[Renato Golin]

Nicholas Vettese wrote:

I have been having problems with my email, and I wanted to test to this
list.


Will let you know when I receive it...

--renato

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing Email

[Nicholas Vettese]

I have been having problems with my email, and I wanted to test to this
list.

 

Thanks,

nick

Re: Transactions and testing an Insert statement

[Chris]

Chris W. Parker wrote:

Hello,

Me again. Excuse for sending two questions so closely together.

I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter).

Although I haven't found a direct answer, my searching usually points me
to transactions in InnoDB. Is this what I will need to use to do what I
want?

I'm preparing to import a bunch of data that is coming from an Excel
file from one the vendors we deal with and I want to find out what
manual data preparation I need to do. I'm using PHP's
mysql_real_escape_string as well as some other custom functions but I
need to find out if this is enough.

As I imagine it in my head: 


TEST INSERT INTO `table` VALUES ('value', 'value');


You can't "test" an insert like this but you could do:

begin;
insert into table values(value1, value2);
rollback;

which does mean you need innodb tables. That will rollback any changes 
that the insert does, however I'm not sure what happens to an 
auto_increment field in that situation (ie does the value get rolled 
back or is it left incremented).


The mysql_query function in php returns a resource or failure, so you 
could do:


$result = mysql_query($my_query);
if (!$result) {
  echo "Query ${my_query} failed: " . mysql_error() . "";
} else {
  echo "Query ${my_query} worked!";
}

see php.net/mysql_query for more info.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Transactions and testing an Insert statement

[Chris W. Parker]

Hello,

Me again. Excuse for sending two questions so closely together.

I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter).

Although I haven't found a direct answer, my searching usually points me
to transactions in InnoDB. Is this what I will need to use to do what I
want?

I'm preparing to import a bunch of data that is coming from an Excel
file from one the vendors we deal with and I want to find out what
manual data preparation I need to do. I'm using PHP's
mysql_real_escape_string as well as some other custom functions but I
need to find out if this is enough.

As I imagine it in my head: 

TEST INSERT INTO `table` VALUES ('value', 'value');

And then get back a success or fail error code.

Using MySQL 4.1.


Thank you for your time,
Chris.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

Atle Veka wrote:

Replicating a live setup, especially one running on the web is extremely
difficult if not near impossible. Assuming you don't have the freedom to
stop/start your mysqld for tuning/tweaking, here are some things you can
do:
- Enable slow-query-log
- Enable query log
- Query processlist periodically and save results where queries have been
processing for X amount of time

With this information you can profile your queries and use 'EXPLAIN
' to optimize where needed, aka adding indexes, etc.

I simply haven't found it worth it to replicate live setups in order to
look for bottlenecks. It's much easier and less time consuming to do
things like above and generally being in tune with your system. Setting up
performance graphs based on your system or mysqld performance is worth the
time.


Atle
-
Flying Crocodile Inc, Unix Systems Administrator



Hi, Atle -

This is pretty much what I've been doing here.  I am running queries 
which appear to be "slow" from the live machine to the testing machine. 
 Although mundane, it gives me a pretty good idea of what I'm up against.


I think, however, I'll see a major speed improvement when moving from 
MySQL 3.23.58 to 5.0.22, no? :)  This current server is a bit dated, 
which is the reason why I'm about to rip it apart.


I'll also go ahead and plug your service here, as I'm sure you won't 
mind.  I've used one of your sister companies in the past, and it has 
helped me out a lot.


Thanks
-dant


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Atle Veka]

Replicating a live setup, especially one running on the web is extremely
difficult if not near impossible. Assuming you don't have the freedom to
stop/start your mysqld for tuning/tweaking, here are some things you can
do:
- Enable slow-query-log
- Enable query log
- Query processlist periodically and save results where queries have been
processing for X amount of time

With this information you can profile your queries and use 'EXPLAIN
' to optimize where needed, aka adding indexes, etc.

I simply haven't found it worth it to replicate live setups in order to
look for bottlenecks. It's much easier and less time consuming to do
things like above and generally being in tune with your system. Setting up
performance graphs based on your system or mysqld performance is worth the
time.


Atle
-
Flying Crocodile Inc, Unix Systems Administrator

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Scott Tanner]

On Tue, 2006-06-13 at 19:04, Dan Trainor wrote:
> Jake Peavy wrote:
> > On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 
> > wrote:
> > 
> > Hi -
> > 
> > I would like to be able to replicate all queries from a live MySQL
> > server, to a testing server at the office.
> > 
> > The reason for doing this is to test load under [semi]real-world
> > conditions with the new server.  I think that by doing something like
> > this, I would be able to fine-tune the new server in preparation for
> > replacing the original server.
> > 
> > So what I can't figure out right now is how to set up a situation like
> > this, where the live server would replicate every one of it's
> > queries to
> > the testing machine, and have the testing machine not respond with
> > anything - just simply mow through the queries.
> > 
> > The testing server will have a snapshot of the live database, so I will
> > ahve data to work with.  However, the testing machine is on a private
> > internal subnet, and I don't see how this type of setup would work from
> > a logical MySQL standpoint.
> > 
> > Keeping all this in mind, also remember that I cannot change any of the
> > code which references the MySQL server.  I need to be able to do this
> > using some native MySQL function.
> > 
> > Any feedback would be greatly appreciated.  I look forward to all your
> > responses.
> > 
> > Thanks!
> > -dant
> > 
> > 
> > Big Dan T?
> > 
> > I haven't done it, but I think what you need to do is
> > 
> >1. enable binlog on the live DB
> >2. transfer the binlogs from some period of time over to your test server
> >3. pipe the queries contained in the binlog into your test server,
> >   something along the lines of:   $ mysqlbinlog
> >   bin_file_from_live_db.0001 | mysql
> > 
> > HTH,
> > 
> > -- 
> > -jp
> 
> Hi, Jake -
> 
> This would certainly work.  However, I'd like to do all of this as close 
> to real-time as I possibly can.  I don't think that I can get an 
> accurate representation of load if I just throw it on the new machine 
> that way.
> 
> Thanks though!
> -dant

The binlog would only give you the changes (updates, inserts, and
deletes). The general log (--log) would be a better representation of
the server, since it logs all actions, when they started, and from which
host.
 The issue is in making the play-back real-time. I dont believe
mysqlbinlog takes the start time into consideration, so the playback
would be one single serial thread with no delays between transactions.
Not realistic. A little scripting and parsing would create what your
looking for though.

 You could also do a tcpdump at the DB server, only capturing the
incoming mysql statements (providing your not doing SSL encapsulation).
This would also give you the timing and all transactions, but I'm not
sure how the server would handle TCP playback.

 In trying to do the same thing, we ended up creating a java based
stress testing tool to mimic our DB traffic, using the basic info from
TCP dumps as a model.

Regards,
Scott


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

Jake Peavy wrote:

On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

Hi -

I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.

The reason for doing this is to test load under [semi]real-world
conditions with the new server.  I think that by doing something like
this, I would be able to fine-tune the new server in preparation for
replacing the original server.

So what I can't figure out right now is how to set up a situation like
this, where the live server would replicate every one of it's
    queries to
the testing machine, and have the testing machine not respond with
anything - just simply mow through the queries.

The testing server will have a snapshot of the live database, so I will
ahve data to work with.  However, the testing machine is on a private
internal subnet, and I don't see how this type of setup would work from
a logical MySQL standpoint.

Keeping all this in mind, also remember that I cannot change any of the
code which references the MySQL server.  I need to be able to do this
using some native MySQL function.

Any feedback would be greatly appreciated.  I look forward to all your
responses.

Thanks!
-dant


Big Dan T?

I haven't done it, but I think what you need to do is

   1. enable binlog on the live DB
   2. transfer the binlogs from some period of time over to your test server
   3. pipe the queries contained in the binlog into your test server,
  something along the lines of:   $ mysqlbinlog
  bin_file_from_live_db.0001 | mysql

HTH,

--
-jp


Hi, Jake -

This would certainly work.  However, I'd like to do all of this as close 
to real-time as I possibly can.  I don't think that I can get an 
accurate representation of load if I just throw it on the new machine 
that way.


Thanks though!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Jake Peavy]

On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.

The reason for doing this is to test load under [semi]real-world
conditions with the new server.  I think that by doing something like
this, I would be able to fine-tune the new server in preparation for
replacing the original server.

So what I can't figure out right now is how to set up a situation like
this, where the live server would replicate every one of it's queries to
the testing machine, and have the testing machine not respond with
anything - just simply mow through the queries.

The testing server will have a snapshot of the live database, so I will
ahve data to work with.  However, the testing machine is on a private
internal subnet, and I don't see how this type of setup would work from
a logical MySQL standpoint.

Keeping all this in mind, also remember that I cannot change any of the
code which references the MySQL server.  I need to be able to do this
using some native MySQL function.

Any feedback would be greatly appreciated.  I look forward to all your
responses.

Thanks!
-dant



Big Dan T?

I haven't done it, but I think what you need to do is

  1. enable binlog on the live DB
  2. transfer the binlogs from some period of time over to your test
  server
  3. pipe the queries contained in the binlog into your test server,
  something along the lines of:   $ mysqlbinlog bin_file_from_live_db.0001 |
  mysql

HTH,

--
-jp


Filming on location for Walker: Texas Ranger, Chuck Norris brought a
stillborn baby lamb back to life by giving it a prolonged beard rub. Shortly
after the farm animal sprang back to life and a crowd had gathered, Chuck
Norris roundhouse kicked the animal, breaking its neck, to remind the crew
once more that Chuck giveth, and the good Chuck, he taketh away.

Re: Replicating queries to testing server

[Dan Trainor]

nigel wood wrote:

Dan Trainor wrote:


Dan Trainor wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.



Hi -

So I was thinking about this more, and then it dawned on me.  This is 
simple MySQL replication.


Sorry for wasting the time.


No, it isn't. Selects aren't replicated nor is the timing true to catch 
contention problems.  I've done this recently and whilst I don't have 
time now I'll post my solution tomorrow. Assuming:


A) Your using *nux
B) Your application(s) and database are hosted on different machines
C) You have root access on one of the boxes
D) You can take a live db snapshot

It will let you record and playback your database server's load.

HTH

Nigel



Hi, Nigel -

Were you ever able to take a moment to respond?  I had not seen a 
response yet.


If time allows, I would certainly appreciate it.

Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

nigel wood wrote:

Dan Trainor wrote:


Dan Trainor wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.




Hi -

So I was thinking about this more, and then it dawned on me.  This is 
simple MySQL replication.


Sorry for wasting the time.



No, it isn't. Selects aren't replicated nor is the timing true to catch 
contention problems.  I've done this recently and whilst I don't have 
time now I'll post my solution tomorrow. Assuming:


A) Your using *nux
B) Your application(s) and database are hosted on different machines
C) You have root access on one of the boxes
D) You can take a live db snapshot

It will let you record and playback your database server's load.

HTH

Nigel



Hi, Nigel -

My situation does meet the above requirements, and I would be very 
greatful if you were to spend a moment on this tomorrow when you get 
time.  I look forward to your reply.


Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[nigel wood]

Dan Trainor wrote:


Dan Trainor wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.



Hi -

So I was thinking about this more, and then it dawned on me.  This is 
simple MySQL replication.


Sorry for wasting the time.


No, it isn't. Selects aren't replicated nor is the timing true to catch 
contention problems.  I've done this recently and whilst I don't have 
time now I'll post my solution tomorrow. Assuming:


A) Your using *nux
B) Your application(s) and database are hosted on different machines
C) You have root access on one of the boxes
D) You can take a live db snapshot

It will let you record and playback your database server's load.

HTH

Nigel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

Dan Trainor wrote:

Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.  I think that by doing something like 
this, I would be able to fine-tune the new server in preparation for 
replacing the original server.


So what I can't figure out right now is how to set up a situation like 
this, where the live server would replicate every one of it's queries to 
the testing machine, and have the testing machine not respond with 
anything - just simply mow through the queries.


The testing server will have a snapshot of the live database, so I will 
ahve data to work with.  However, the testing machine is on a private 
internal subnet, and I don't see how this type of setup would work from 
a logical MySQL standpoint.


Keeping all this in mind, also remember that I cannot change any of the 
code which references the MySQL server.  I need to be able to do this 
using some native MySQL function.


Any feedback would be greatly appreciated.  I look forward to all your 
responses.


Thanks!
-dant



Hi -

So I was thinking about this more, and then it dawned on me.  This is 
simple MySQL replication.


Sorry for wasting the time.

Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replicating queries to testing server

[Dan Trainor]

Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.  I think that by doing something like 
this, I would be able to fine-tune the new server in preparation for 
replacing the original server.


So what I can't figure out right now is how to set up a situation like 
this, where the live server would replicate every one of it's queries to 
the testing machine, and have the testing machine not respond with 
anything - just simply mow through the queries.


The testing server will have a snapshot of the live database, so I will 
ahve data to work with.  However, the testing machine is on a private 
internal subnet, and I don't see how this type of setup would work from 
a logical MySQL standpoint.


Keeping all this in mind, also remember that I cannot change any of the 
code which references the MySQL server.  I need to be able to do this 
using some native MySQL function.


Any feedback would be greatly appreciated.  I look forward to all your 
responses.


Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[off-topic] testing mailing list

[Victor Medina]

this is just a test, please ignore

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Concurrent Insert on InnoDB

[Gleb Paharenko]

Hello.

> The table should not be locked, right :D

Most probably it will be locked.  If you are not running in strict SQL
mode, any column not explicitly given a value is set to its default
(explicit or implicit) value. For example, if you specify a column list
that does not name all the columns in the table, unnamed columns are set
to their default values.  For an AUTO_INCREMENT column, the default
value is the next value in the sequence. So your insert will put an
AUTO-INC lock on the table.







Ady Wicaksono wrote:
> Hi Gleb
> 
> Thanx a lot for explanation, make sense.
> I haven't try with INSERT INTO Y (t_y_time,and so on) SELECT
> (t_x_time, ... and so on) FROM X
> excluding t_y_id
> 
> The table should not be locked, right :D
> 
> Thx
> 
> 
> Gleb Paharenko wrote:
> 
>> Hello.
>>
>> It seems that the problem is in the t_y_id auto_increment field. InnoDB
>> puts special AUTO-INC table lock, and prevent other threads from
>> inserting into Y. See:
>> http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
>>
>>
>>
>> Ady Wicaksono wrote:
>>  
>>
>>> Below is the SQL to create table Y
>>>
>>> CREATE TABLE `Y` (
>>> `t_y_id` int(11) NOT NULL auto_increment,
>>> `t_y_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
>>> `t_y_dest` varchar(16) NOT NULL default '',
>>> `t_y_msg` varchar(160) NOT NULL default '',
>>> `t_y_status` tinyint(2) NOT NULL default '0',
>>> `t_y_type` varchar(16) NOT NULL default '',
>>> `t_y_trx_id` varchar(40) NOT NULL default '',
>>> `t_y_trx_date` varchar(33) NOT NULL default '',
>>> `t_y_serviceid` varchar(20) NOT NULL default '',
>>> `t_y_pin` varchar(15) NOT NULL default '',
>>> `t_y_key` varchar(20) NOT NULL default '',
>>> `t_y_ans` varchar(160) NOT NULL default '',
>>> `in_sms_message_id` varchar(22) NOT NULL default '',
>>> `in_sms_time` datetime NOT NULL default '-00-00 00:00:00',
>>> `t_y_city` varchar(50) NOT NULL default '',
>>> PRIMARY KEY  (`t_y_id`),
>>> KEY `t_idx01` (`t_y_type`(3)),
>>> KEY `t_idx02` (`t_y_key`(3)),
>>> KEY `t_idx03` (`t_y_ans`(8)),
>>> KEY `t_idx04` (`t_y_dest`(7)),
>>> KEY `t_idx05` (`t_y_dest`(13),`t_y_key`(15),`t_y_ans`(10)),
>>> KEY `t_idx06` (`t_y_time`),
>>> KEY `t_idx07` (`t_y_time`,`t_y_key`(6)),
>>> KEY `t_idx08` (`t_y_trx_id`(8)),
>>> KEY `t_idx09` (`t_y_trx_id`(10),`t_y_dest`(6)),
>>> KEY `t_idx10` (`t_y_status`,`t_y_type`(3)),
>>> KEY `t_idx11` (`in_sms_time`),
>>> KEY `t_idx12` (`t_y_time`,`t_y_type`(3)),
>>> KEY `t_idx13` (`t_y_city`(7))
>>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>>>
>>>   
>>
>>
>>
>>
>>  
>>
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Concurrent Insert on InnoDB

[Ady Wicaksono]

Hi Gleb

Thanx a lot for explanation, make sense.
I haven't try with INSERT INTO Y (t_y_time,and so on) SELECT 
(t_x_time, ... and so on) FROM X

excluding t_y_id

The table should not be locked, right :D

Thx


Gleb Paharenko wrote:


Hello.

It seems that the problem is in the t_y_id auto_increment field. InnoDB
puts special AUTO-INC table lock, and prevent other threads from
inserting into Y. See:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html



Ady Wicaksono wrote:
 


Below is the SQL to create table Y

CREATE TABLE `Y` (
`t_y_id` int(11) NOT NULL auto_increment,
`t_y_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`t_y_dest` varchar(16) NOT NULL default '',
`t_y_msg` varchar(160) NOT NULL default '',
`t_y_status` tinyint(2) NOT NULL default '0',
`t_y_type` varchar(16) NOT NULL default '',
`t_y_trx_id` varchar(40) NOT NULL default '',
`t_y_trx_date` varchar(33) NOT NULL default '',
`t_y_serviceid` varchar(20) NOT NULL default '',
`t_y_pin` varchar(15) NOT NULL default '',
`t_y_key` varchar(20) NOT NULL default '',
`t_y_ans` varchar(160) NOT NULL default '',
`in_sms_message_id` varchar(22) NOT NULL default '',
`in_sms_time` datetime NOT NULL default '-00-00 00:00:00',
`t_y_city` varchar(50) NOT NULL default '',
PRIMARY KEY  (`t_y_id`),
KEY `t_idx01` (`t_y_type`(3)),
KEY `t_idx02` (`t_y_key`(3)),
KEY `t_idx03` (`t_y_ans`(8)),
KEY `t_idx04` (`t_y_dest`(7)),
KEY `t_idx05` (`t_y_dest`(13),`t_y_key`(15),`t_y_ans`(10)),
KEY `t_idx06` (`t_y_time`),
KEY `t_idx07` (`t_y_time`,`t_y_key`(6)),
KEY `t_idx08` (`t_y_trx_id`(8)),
KEY `t_idx09` (`t_y_trx_id`(10),`t_y_dest`(6)),
KEY `t_idx10` (`t_y_status`,`t_y_type`(3)),
KEY `t_idx11` (`in_sms_time`),
KEY `t_idx12` (`t_y_time`,`t_y_type`(3)),
KEY `t_idx13` (`t_y_city`(7))
) ENGINE=InnoDB DEFAULT CHARSET=latin1

   





 





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Concurrent Insert on InnoDB

[Gleb Paharenko]

Hello.

It seems that the problem is in the t_y_id auto_increment field. InnoDB
puts special AUTO-INC table lock, and prevent other threads from
inserting into Y. See:
 http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html



Ady Wicaksono wrote:
> Below is the SQL to create table Y
> 
> CREATE TABLE `Y` (
>  `t_y_id` int(11) NOT NULL auto_increment,
>  `t_y_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
>  `t_y_dest` varchar(16) NOT NULL default '',
>  `t_y_msg` varchar(160) NOT NULL default '',
>  `t_y_status` tinyint(2) NOT NULL default '0',
>  `t_y_type` varchar(16) NOT NULL default '',
>  `t_y_trx_id` varchar(40) NOT NULL default '',
>  `t_y_trx_date` varchar(33) NOT NULL default '',
>  `t_y_serviceid` varchar(20) NOT NULL default '',
>  `t_y_pin` varchar(15) NOT NULL default '',
>  `t_y_key` varchar(20) NOT NULL default '',
>  `t_y_ans` varchar(160) NOT NULL default '',
>  `in_sms_message_id` varchar(22) NOT NULL default '',
>  `in_sms_time` datetime NOT NULL default '-00-00 00:00:00',
>  `t_y_city` varchar(50) NOT NULL default '',
>  PRIMARY KEY  (`t_y_id`),
>  KEY `t_idx01` (`t_y_type`(3)),
>  KEY `t_idx02` (`t_y_key`(3)),
>  KEY `t_idx03` (`t_y_ans`(8)),
>  KEY `t_idx04` (`t_y_dest`(7)),
>  KEY `t_idx05` (`t_y_dest`(13),`t_y_key`(15),`t_y_ans`(10)),
>  KEY `t_idx06` (`t_y_time`),
>  KEY `t_idx07` (`t_y_time`,`t_y_key`(6)),
>  KEY `t_idx08` (`t_y_trx_id`(8)),
>  KEY `t_idx09` (`t_y_trx_id`(10),`t_y_dest`(6)),
>  KEY `t_idx10` (`t_y_status`,`t_y_type`(3)),
>  KEY `t_idx11` (`in_sms_time`),
>  KEY `t_idx12` (`t_y_time`,`t_y_type`(3)),
>  KEY `t_idx13` (`t_y_city`(7))
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing Concurrent Insert on InnoDB

[Ady Wicaksono]

Below is the SQL to create table Y

CREATE TABLE `Y` (
 `t_y_id` int(11) NOT NULL auto_increment,
 `t_y_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
 `t_y_dest` varchar(16) NOT NULL default '',
 `t_y_msg` varchar(160) NOT NULL default '',
 `t_y_status` tinyint(2) NOT NULL default '0',
 `t_y_type` varchar(16) NOT NULL default '',
 `t_y_trx_id` varchar(40) NOT NULL default '',
 `t_y_trx_date` varchar(33) NOT NULL default '',
 `t_y_serviceid` varchar(20) NOT NULL default '',
 `t_y_pin` varchar(15) NOT NULL default '',
 `t_y_key` varchar(20) NOT NULL default '',
 `t_y_ans` varchar(160) NOT NULL default '',
 `in_sms_message_id` varchar(22) NOT NULL default '',
 `in_sms_time` datetime NOT NULL default '-00-00 00:00:00',
 `t_y_city` varchar(50) NOT NULL default '',
 PRIMARY KEY  (`t_y_id`),
 KEY `t_idx01` (`t_y_type`(3)),
 KEY `t_idx02` (`t_y_key`(3)),
 KEY `t_idx03` (`t_y_ans`(8)),
 KEY `t_idx04` (`t_y_dest`(7)),
 KEY `t_idx05` (`t_y_dest`(13),`t_y_key`(15),`t_y_ans`(10)),
 KEY `t_idx06` (`t_y_time`),
 KEY `t_idx07` (`t_y_time`,`t_y_key`(6)),
 KEY `t_idx08` (`t_y_trx_id`(8)),
 KEY `t_idx09` (`t_y_trx_id`(10),`t_y_dest`(6)),
 KEY `t_idx10` (`t_y_status`,`t_y_type`(3)),
 KEY `t_idx11` (`in_sms_time`),
 KEY `t_idx12` (`t_y_time`,`t_y_type`(3)),
 KEY `t_idx13` (`t_y_city`(7))
) ENGINE=InnoDB DEFAULT CHARSET=latin1

And this is mySQL System Variables

NameValue
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /
bdb_cache_size 8388600
bdb_home /var/lib/mysql/
bdb_log_buffer_size 1049088
bdb_logdir 
bdb_max_lock 1

bdb_shared_data OFF
bdb_tmpdir /tmp/
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 5
datadir /var/lib/mysql/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
div_precision_increment 4
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive YES
have_bdb YES
have_blackhole_engine YES
have_compress YES
have_crypt YES
have_csv YES
have_example_engine YES
have_federated_engine YES
have_geometry YES
have_innodb YES
have_isam NO
have_ndbcluster DISABLED
have_openssl NO
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
init_connect 
init_file 
init_slave 
innodb_additional_mem_pool_size 62914560

innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 1073741824
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path
/data1/ibdata1:2000M;/data1/ibdata2:2000M;/data1/ibdata3:2000M;/data1/ibdata4:2000M;/data2/ibdata5:2000M;/data2/ibdata6:2000M;/data2/ibdata7:2000M;/data2/ibdata8:2000M;/data3/ibdata9:2000M;/data3/ibdata10:2000M;/data3/ibdata11:2000M;/data3/ibdata12:2000M;
innodb_data_home_dir 
innodb_doublewrite ON

innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method 
innodb_force_recovery 0

innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir /data1
innodb_log_archive OFF
innodb_log_buffer_size 8388608
innodb_log_file_size 104857600
innodb_log_files_in_group 2
innodb_log_group_home_dir /data1
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks OFF
innodb_thread_concurrency 20
innodb_thread_sleep_delay 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 402653184
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /usr/share/mysql/english/
large_files_support ON
large_page_size 0
large_pages OFF
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_bin OFF
log_bin_trust_routine_creators OFF
log_error 
log_slave_updates OFF

log_slow_queries OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_

Re: Testing Concurrent Insert on InnoDB

[Gleb Paharenko]

Hello.

According to:
  http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html

INSERT ... SELECT set a non-next-key lock on each row. So in most cases
you should be able to insert the record into Y. Please, provide
the CREATE statement for table Y and the output of 'show variables'
statement. In my opinion, the problem could be in keys, if they're
present in the table. Include the output of SHOW PROCESSLIST and
SHOW INNODB STATUS as well.



Ady Wicaksono wrote:
> I use MySQL 5.0.15
> 
> I have about 5 billion rows in table X, i create another table Y with
> the same stucture with X
> CREATE TABLE Y LIKE X;
> 
> Both X and Y is the InnoDB table, since i believe that both work on the
> "row locking" models
> 
> I try to initiate 2 session
> 
> First session try to INSERT all of data from X to Y like this
> 
> INSERT INTO Y SELECT *  FROM X;
> 
> After a while (i need a long time to finish this Query), i start my
> second session and try
> to insert a data into Y
> 
> What happened later make me confuse, because
> 
> INSERT INTO Y VALUES (something) is just hang on, seems waiting another
> operation to be finished
> 
> Why concurrent insert is not working?
> 
> FYI, i use standar configuration from MySQL
> 
> Any explanation?
> 
> Thx
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing Concurrent Insert on InnoDB

[Ady Wicaksono]

I use MySQL 5.0.15

I have about 5 billion rows in table X, i create another table Y with 
the same stucture with X

CREATE TABLE Y LIKE X;

Both X and Y is the InnoDB table, since i believe that both work on the 
"row locking" models


I try to initiate 2 session

First session try to INSERT all of data from X to Y like this

INSERT INTO Y SELECT *  FROM X;

After a while (i need a long time to finish this Query), i start my 
second session and try

to insert a data into Y

What happened later make me confuse, because

INSERT INTO Y VALUES (something) is just hang on, seems waiting another 
operation to be finished


Why concurrent insert is not working?

FYI, i use standar configuration from MySQL

Any explanation?

Thx



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MySQL] Testing

[Ashley M. Kirchner]

Mike Blezien wrote:


is the list still working ?


   Would you believe me if I said, "No."?

--
W | It's not a bug - it's an undocumented feature.
 +
 Ashley M. Kirchner    .   303.442.6410 x130
 IT Director / SysAdmin / Websmith . 800.441.3873 x130
 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
 http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing

[Mike Blezien]

is the list still working ?

--
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com/
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: testing for connectivity to database

[Gleb Paharenko]

Hello.



> I'm trying to initialize to a database



Does this mean that you're unable to connect to MySQL Server?  What

error message does mysql command line client report ? You  said you were

able to telnet to 3307 port - have you seen the MySQL protocol messages

(usually seems like a garbage for ordinary people :). See:

  http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html







Jon Miller wrote:

> I'm trying to initialize to a database on another server from a mail server.  
> I can telnet to it but cannot initialize the database.

> The account and user exists in the database and the paasword as I've tried it 
> from the mysql server.

> Is there another test I can do to find out exactly what is causing the 
> problem?  The firewall is set to allow port 3307 (it the port mysql listens 
> on).

> 

> Thanks

> 

> 

> 

> 

> 

> 

> 

> 

> 

> I'm trying to initialize to a database on another server from a mail 

> server.š I canštelnet to it but cannot initialize the database.

> The account and user exists in the database and the paasword as I've 
> tried 

> it from the mysql server.

> Is there another test I can do to find out exactly what is causing the 

> problem?š The firewall is set to allow port 3307 (it the port mysql listens 

> on).

> š

> Thanks

> 

> 

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

testing for connectivity to database

[Jon Miller]

I'm trying to initialize to a database on another server from a mail server.  I 
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it 
from the mysql server.
Is there another test I can do to find out exactly what is causing the problem? 
 The firewall is set to allow port 3307 (it the port mysql listens on).

Thanks





I'm trying to initialize to a database on another server from a mail 
server.  I can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried 
it from the mysql server.
Is there another test I can do to find out exactly what is causing the 
problem?  The firewall is set to allow port 3307 (it the port mysql 
listens 
on).
 
Thanks


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: High Load testing

[Jigal van Hemert]

From: "Chris Knipe"
> I found super-smack (which tests 100% what I want), but the problem now is

Maybe you can use Jeremy Zawodny's "MyBench"?
http://jeremy.zawodny.com/mysql/mybench/
It requires a bit of programming skills to get your logic in the Perl script
(plus DBI, DBD::mysql and Time::HiRes installed), but you probably have Perl
running on the FreeBSD machine anyway...

Regards, Jigal.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

High Load testing

[Chris Knipe]

Hi,
I used sql-bench, but that is testing things we already know.  We want to 
establish how many concurrent connections / queries our database server can 
handle before it starts getting into trouble (no, a different one from the 
email of last night).  This system is a dual proc with 4GB ram and over 
500GB on a RAID 5 setup

I found super-smack (which tests 100% what I want), but the problem now is 
that it does not compile on FreeBSD, and the few (literally not even 3) 
linux boxes we have cannot handle the load to stress our DB server to the 
max. This I know because iostat on the FreeBSD DB Server shows that the 
entire box is virtually idle (the load averages confirms) while the tests on 
super-smack run.  The worse I got was a load of 0.5 on the DB server with 
close to 800 threads running

Any ideas please???
--
Chris. 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Upgrading to MySQL 5 (for testing)

[Gleb Paharenko]

Hello.



Yes, if you have one of the last releases of MySQL, you can try to test

the fifth version. But some features will be unavailable. See:

  http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.1.html





"Jonathan Villa" <[EMAIL PROTECTED]> wrote:

> I have an installation of 4.1 and 5 running on the same test server... I

> want to start using 5 for testing but still want to use the same test data

> I had before... Is it possible to simply point MySQL 5 to the old 4 data

> dir?

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Upgrading to MySQL 5 (for testing)

[Jonathan Villa]

I have an installation of 4.1 and 5 running on the same test server... I
want to start using 5 for testing but still want to use the same test data
I had before... Is it possible to simply point MySQL 5 to the old 4 data
dir?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: just testing, sorry.

[Egor Egorov]

tibyke <[EMAIL PROTECTED]> wrote:

> pls delete it

Done, deleted from my computer. :-)) 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

just testing, sorry.

[tibyke]

pls delete it

regards,
tibyke

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

testing

[Karl James]

Testing 
Karl James
(TheSaint)
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
http://theufl.com/<http://theufl.com/>

Re: Testing for the existence of an index

[Jesse Sheidlower]

On Tue, Aug 24, 2004 at 11:57:05AM +0200, Thomas Spahni wrote:
> Jesse,
> 
> mysql> SHOW INDEX FROM mytable;
> 
> gives you all indexes for `mytable`; you can process the results with
> perl.

Thanks very much. This works fine, and since I don't care about the
return value--just that there is one--it becomes trivial.

Jesse Sheidlower

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing for the existence of an index

[Thomas Spahni]

Jesse,

mysql> SHOW INDEX FROM mytable;

gives you all indexes for `mytable`; you can process the results with
perl.

Thomas Spahni

On Mon, 23 Aug 2004, Jesse Sheidlower wrote:

> I have a database where, most of the time, I'm bulk-loading
> data into new tables from an external source, several million
> rows at a time. For this purpose, I create the tables without
> indexes, and then add all my indexes after the load is done,
> for efficiency purposes.
>
> I'd now like to add the possibility of adding some data to the
> existing database. In this case, the indexes exist, and then
> the new data will be indexed as it goes in (which is OK given
> the relatively small amount of data to be processed this way).
>
> I'd like to be able to test for the existence of an index, so
> that after the bulk-load, I can see if there are indexes,
> there won't be any, and I can create them; but after an
> addition to an existing database, there will be indexes, and I
> won't create them.
>
> How do I do this? It wasn't clear from the manual, and I'm
> away from my books now so can't look there for advice. I'm
> using Perl to process the data, if there's a Perlish way of
> doing things that would be easier than SQL.
>
> Jesse Sheidlower
>
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing for the existence of an index

[Jesse Sheidlower]

On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote:
> Why don't you disable the indexes before the load and enable the indexes
> after the data load? 

If I'm bulk-loading a fresh install of data, then I'll be using
un-indexed tables and index them afterwards. Otherwise, I want
to keep the indexes on the table, and index as I go along (so
that when I'm done I don't have to re-index from scratch).

In response to the other poster, who suggested opening the table
up in some utility: it's not a problem for _me_ to determine if
I'm bulk-loading a new batch, or adding to an existing database.
I want my loading program to be able to determine this without
any input from me.

Thanks.

Jesse Sheidlower

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Testing for the existence of an index

[EWA Goodson-Wickes]

Why don't you download navicat or use php admin and then just open the table
up in design view? You can then see if it has an index or not and add one if
you need?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Testing for the existence of an index

[Victor Pendleton]

Why don't you disable the indexes before the load and enable the indexes
after the data load? 

-Original Message-
From: Jesse Sheidlower
To: [EMAIL PROTECTED]
Sent: 8/23/04 3:33 PM
Subject: Testing for the existence of an index


I have a database where, most of the time, I'm bulk-loading
data into new tables from an external source, several million
rows at a time. For this purpose, I create the tables without
indexes, and then add all my indexes after the load is done,
for efficiency purposes.

I'd now like to add the possibility of adding some data to the
existing database. In this case, the indexes exist, and then
the new data will be indexed as it goes in (which is OK given
the relatively small amount of data to be processed this way).

I'd like to be able to test for the existence of an index, so
that after the bulk-load, I can see if there are indexes,
there won't be any, and I can create them; but after an
addition to an existing database, there will be indexes, and I
won't create them.

How do I do this? It wasn't clear from the manual, and I'm
away from my books now so can't look there for advice. I'm
using Perl to process the data, if there's a Perlish way of
doing things that would be easier than SQL.

Jesse Sheidlower


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing for the existence of an index

[Jesse Sheidlower]

I have a database where, most of the time, I'm bulk-loading
data into new tables from an external source, several million
rows at a time. For this purpose, I create the tables without
indexes, and then add all my indexes after the load is done,
for efficiency purposes.

I'd now like to add the possibility of adding some data to the
existing database. In this case, the indexes exist, and then
the new data will be indexed as it goes in (which is OK given
the relatively small amount of data to be processed this way).

I'd like to be able to test for the existence of an index, so
that after the bulk-load, I can see if there are indexes,
there won't be any, and I can create them; but after an
addition to an existing database, there will be indexes, and I
won't create them.

How do I do this? It wasn't clear from the manual, and I'm
away from my books now so can't look there for advice. I'm
using Perl to process the data, if there's a Perlish way of
doing things that would be easier than SQL.

Jesse Sheidlower


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: R: Large sample data sets for testing

[mos]

At 09:55 AM 5/22/2004, you wrote:
Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html
It generates random data for you.
> -Messaggio originale-
> Da: Greg Willits [mailto:[EMAIL PROTECTED]
> Inviato: venerdi 21 maggio 2004 21.17
> Cc: MySql
> Oggetto: Large sample data sets for testing
>
>
> Anyone know of some large sample data sets available for free or < $100?
>
> "Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or so,
> something on the order of a couple hundred megabytes.
>
> "Sample Data" = I don't really care what it is (text based though, no
> need for BLOB), just something to use for testing. Maybe an old news
> feed archive or something?
>
> I'm sure I could cope with just about any common exchange format.
> Always wanted to test the performance and scaling of some setups I have
> and things I've written, but I've never located a big (to me) data set
> to play with.
>
> -- greg willits
>
>

Greg,
EMS has a MySQL data generator for $39 that runs on Windows. See 
http://www.ems-hitech.com/mysqlutils.

Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

R: Large sample data sets for testing

[Leonardo Francalanci]

Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html

It generates random data for you.

> -Messaggio originale-
> Da: Greg Willits [mailto:[EMAIL PROTECTED]
> Inviato: venerdi 21 maggio 2004 21.17
> Cc: MySql
> Oggetto: Large sample data sets for testing
> 
> 
> Anyone know of some large sample data sets available for free or < $100?
> 
> "Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or so, 
> something on the order of a couple hundred megabytes.
> 
> "Sample Data" = I don't really care what it is (text based though, no 
> need for BLOB), just something to use for testing. Maybe an old news 
> feed archive or something?
> 
> I'm sure I could cope with just about any common exchange format. 
> Always wanted to test the performance and scaling of some setups I have 
> and things I've written, but I've never located a big (to me) data set 
> to play with.
> 
> -- greg willits
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Large sample data sets for testing

[Dan Nelson]

In the last episode (May 21), Greg Willits said:
> Anyone know of some large sample data sets available for free or < $100?
> 
> "Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or
> so, something on the order of a couple hundred megabytes.
> 
> "Sample Data" = I don't really care what it is (text based though, no
> need for BLOB), just something to use for testing. Maybe an old news
> feed archive or something?

How about mailinglist archives?  http://gcc.gnu.org/ml/gcc/ has links
about 30MB worth of mbox files, for example.

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Large sample data sets for testing

[Greg Willits]

Anyone know of some large sample data sets available for free or < $100?
"Large" = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or so, 
something on the order of a couple hundred megabytes.

"Sample Data" = I don't really care what it is (text based though, no 
need for BLOB), just something to use for testing. Maybe an old news 
feed archive or something?

I'm sure I could cope with just about any common exchange format. 
Always wanted to test the performance and scaling of some setups I have 
and things I've written, but I've never located a big (to me) data set 
to play with.

-- greg willits
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL testing programs

[Alan Williamson]

First of all, thank you for providing a really informative list.  I have 
 listened to many of the suggestions going back and forth and have 
learnt a lot in the past few months.

I have a question.

We have a fresh MySQL installation on a new box, and we want to 
basically start tuning it to our particular application.  Can some 
advise what tools we could use to basically send shed loads of 
[differing] queries to it in a predictable/repeatable manner.

Would like a tool that produces some statistics on the results of each 
test.  Allowing us to tune/tweek, and rerun to see the effect of our 
results.

thanks

alan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Testing Problems

[Michael Widenius]

Hi!

>>>>> "Chris" == Chris Man <[EMAIL PROTECTED]> writes:

Chris> Hi,
Chris> We have just installed MySQL 3.23.53 on Solaris 9. We were going through the 
Chris> testing stages and it had produced an error.

Chris> Pasted below is the error that we received and also attached are the logs. 

Chris> Installing Test Databases
Chris> Removing Stale Files
Chris> Installing Master Databases
Chris> Installing Slave Databases
Chris> Starting MySQL daemon
Chris> Loading Standard Test Databases
Chris> Starting Tests



Chris> --- r/rpl15.reject   Tue Dec 16 18:46:27 2003
Chris> ***
Chris> *** 1,7 
Chris>   File   PositionBinlog_do_dbBinlog_ignore_db
Chris>   master-bin.001 73  
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter
Chris> !0   0   0   No  0  
 
Chris>  0
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter
Chris>   127.0.0.1  test999860  4   No 
 
Chris> 00
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter
Chris> --- 1,7 
Chris>   File   PositionBinlog_do_dbBinlog_ignore_db
Chris>   master-bin.001 73  
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter
Chris> ! 127.0.0.1  root93061   4   No 
 
Chris> 00
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter
Chris>   127.0.0.1  test999860  4   No 
 
Chris> 00
Chris>   Master_HostMaster_User Master_Port Connect_retry   Log_File   
 
Chris> Pos  Slave_Running   Replicate_do_db Replicate_ignore_db 
Chris> Last_errno   Last_error  Skip_counter

The above is a timing error that only influences the test suite.
you can safely skip this.

In MySQL 4.0, we have done some changes to the test suite to avoid the
above problem.

Regards,
Monty

-- 
Michael Widenius <[EMAIL PROTECTED]>
MySQL AB, CTO
Helsinki, Finland

Are you MySQL certified?  www.mysql.com/certification

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Testing Problems

[Chris Man]

Hi,


We have just installed MySQL 3.23.53 on Solaris 9. We were going through the 
testing stages and it had produced an error.


Pasted below is the error that we received and also attached are the logs. 


Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave Databases
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests


 TEST 
USER   SYSTEM  ELAPSED    RESULT

rpl15 
     [ fail ]


Below are the diffs between actual and expected results:
---
*** r/rpl15.result Fri Nov  1 12:04:39 2002
--- r/rpl15.reject Tue Dec 16 18:46:27 2003
***
*** 1,7 
  FilePositionBinlog_do_db   Binlog_ignore_db
  master-bin.00173
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
!   0  0  0  No   0  0
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
  127.0.0.1test  9998604  No   0  0
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
--- 1,7 
  FilePositionBinlog_do_db   Binlog_ignore_db
  master-bin.00173
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
! 127.0.0.1root  93061  4  No   0  0
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
  127.0.0.1test  9998604  No   0  0
  Master_Host   Master_User Master_Port Connect_retry   Log_File   Pos  Slave_Running Replicate_do_db   Replicate_ignore_db Last_errnoLast_errorSkip_counter
---
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.


Aborting. To continue, re-run with '--force'.


Ending Tests
Shutting-down MySQL daemon


Master shutdown finished
Slave shutdown finished




Please could you shed some light on what has gone wrong.


Many Thanks


Chris Man
Business Systems International 
BSI House,
59 Markham Street,
London SW3 3NR 
Tel: 020 7352 7007 
Fax: 020 7352 7423 
www.e-business.com
email: [EMAIL PROTECTED]



The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

    File information ---
 File:  mysql-log.zip
 Date:  16 Dec 2003, 17:35
 Size:  2358 bytes.
 Type:  ZIP-archive


mysql-log.zip
Description: Zip archive
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

No testing server running (OS X + DW MX)

[Lost Idols]

Setting up MySQL and PHP on my Mac OS X 10.2
Just made it work... well, at least I now have a databse
that I created and a table with two things inserted.
I can also see them when I do a SELECT...
So, since I know it's working, I started my DW MX
to try to work from there, but I just get an error.
I've been setting up the database with all the info
and when I want to select from the list of databases
I just get the following message:
HTTP Error Code 404 File Not Found.
Here are some possible reasons for the problem:
1) There is no testing server running on the server machine.

What's wrong? Any clues here in this list?

Staffan

PS. I'm a newbie, so please write in newbie language ;-)

_
Hitta rätt köpare på MSN Köp & Sälj http://www.msn.se/koposalj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: stress testing

[Gabriel Ricard]

On Dec 2, 2003, at 3:48 PM, Ari Davidow wrote:

We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB 
RAM and a few gig of hard disk space. We're running Solaris 2.8.
Why are you using an old version of MySQL? MySQL4.0 is the recommend 
production version currently.


We seem to be clueless (I am certainly clueless) about testing various 
configuration options so that we are reasonably optimizing the 
resources available to this server. We ran through (approximately) the 
four configuration files included with the MySQL distro, and then 
added more memory (we had, after all, 1GB).

We set up a script to repeated parse some common documents with lots 
of queries. Then we tried the sort of exercise where we'd create 
temporary tables and copy back and forth. Finally, we ran a load of 
SELECTs using full-text search (3 explicitly joined tables).

We did not record statistically significant results.

In truth, we have just begun using MySQL, and don't know what our 
pattern of usage is. Is there an idealized generalized configuration 
model and a tool or method available to test our server against that 
ideal? The online reference doesn't say much about optimization, and 
it is surely messier when we don't really know what we are optimizing 
for (or how to test, assuming we did know).

Any suggestions? stress testers that have matched up against specific 
types of configuration?


If you're interested in seeing how it stacks up with a multi-threaded 
client, or just want to test how efficiently it works with various 
numbers of threads running, you can use the mysqlsyseval utility, which 
is part of a tarball available at this site:

http://www.wiley.com/legacy/compbooks/pachev/

You can modify the mysqlsyseval.c source to add different types of 
queries to test.

- Gabriel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

stress testing

[Ari Davidow]

We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB RAM 
and a few gig of hard disk space. We're running Solaris 2.8.

We seem to be clueless (I am certainly clueless) about testing various 
configuration options so that we are reasonably optimizing the resources 
available to this server. We ran through (approximately) the four 
configuration files included with the MySQL distro, and then added more 
memory (we had, after all, 1GB).

We set up a script to repeated parse some common documents with lots of 
queries. Then we tried the sort of exercise where we'd create temporary 
tables and copy back and forth. Finally, we ran a load of SELECTs using 
full-text search (3 explicitly joined tables).

We did not record statistically significant results.

In truth, we have just begun using MySQL, and don't know what our pattern 
of usage is. Is there an idealized generalized configuration model and a 
tool or method available to test our server against that ideal? The online 
reference doesn't say much about optimization, and it is surely messier 
when we don't really know what we are optimizing for (or how to test, 
assuming we did know).

Any suggestions? stress testers that have matched up against specific types 
of configuration?

ari

Ari Davidow
[EMAIL PROTECTED]
http://www.ivritype.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing again

[Tam, Michael]

Sorry for the waste of bandwidth.  I need to make sure my autoreply doesn't
send to the list.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing

[Tam, Michael]

Testing my autoreply.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Just testing please ignore

[Binay Agarwal]

Testing ..Please ignore this email

just testing

[Binay Agarwal]

Testing ..Please ignore this email

Testing Blocking

[Charles Cantrell]

My posts have been blocked. Testing simple email. 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Load Testing MySQL

[Michael Weiner]

I know this is quite a bit off topic, but i was wondering if anyone else 
out there had any experience with Segue's Silk Performer load testing 
tools. More specifically, i am trying to compile a test script to allow 
me to perform some transactional database testing to load test a MySQL 
4.0.13 database server running behind some apache webservers. I have 
obtained an ODBC driver from MySQL and have some specific queries i 
would like to use in the test. I am have used SP to load test the 
webservers specifically, but i am not 100% sure how to run this against 
a database server now.

If anyone has any experience they can share, please feel free to email 
me off list.

Thank you in advance

--
Michael B. Weiner, Linux+, Linux+ SME
Systems Administrator/Partner
The UserFriendly Network (UFN)
--
Linux Registered User #94900Have you been counted?
http://counter.li.org


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help required on testing MySQL with Open SSL

[Prasad Budim Ram]

Hi,

 I'm looking for information on testing  MySQL server with Open SSL
using any client(JDBC/ODBC). Please let me know how to test using a
MySQL client for SSL. I was able to compile mysql with using open SSL

Thanks
Ram

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Post-installation Testing

[Greg Klaus]

On Thu, Jun 19, 2003 at 01:57:25PM -0400, Mazhar Malik wrote:
> Hi guys
>
> I have just installed MySQL 4.0.13-standard on Mac OS X 10.2.6 for
> the first time. While doing post-installation testing I got access
> denied error. e.g
>
>
> Shell > ./bin/mysqladmin -u root shutdown
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
run: ./bin/mysqladmin -u root -p shutdown

It will prompt you for the password you used during setup.

> Similarly I got an error when I did this test
>
>
> Shell > ./bin/mysqlshow mysql
> ./bin/mysqlshow: Access denied for user: '@localhost' to database
> 'mysql'

./bin/mysqlshow -u root -p mysql

You must provide a username to connect to the mysql server with. The
'-p' option says to prompt for and use a password in order to connect.


> Before these tests, I had used following commands to setup password
>
> /usr/local/mysql/bin/mysqladmin -u root password 
> /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
> 
>
--
Greg Klaus
-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-
Nec Mors, Nec Requies. Carpe Noctum!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Post-installation Testing

[Mazhar Malik]

Hi guys

I have just installed MySQL 4.0.13-standard on Mac OS X 10.2.6 for 
the first time. While doing post-installation testing I got access 
denied error. e.g

Shell > ./bin/mysqladmin -u root shutdown
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Similarly I got an error when I did this test

Shell > ./bin/mysqlshow mysql
./bin/mysqlshow: Access denied for user: '@localhost' to database 'mysql'
Before these tests, I had used following commands to setup password

/usr/local/mysql/bin/mysqladmin -u root password 
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password 
Thanks for the help

Mazhar
--
Instructional Technology Database Developer
Electronic Instructional Services
Georgia College & State University
478-445-2520

Re: Fw: 2 questions about indexing and testing speed

[rich johnson]

"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have 
been retreived. So if I run a query two times, the second time will be 
faster. How can I temporarly stop this service? because I want to run 
different queries and compare their speed and find the best solution for a 
problem.
In newer versions of mysql (4.0.3+), you can issue

   set global query_cache_limit=0;

in older versions, you need to set the value in my.cnf, then restart the 
server.

> 2) A table has 2 fields, Active CHAR(1), and Company CHAR(40). Sometimes 
I want to search a company name and sometimes I want to search an active 
company. For faster searching, do I need to create two index like these:
> CREATE INDEX active ON customer (CONCAT(active, company));
No need to specify "concat"

 CREATE INDEX ative ON customer (active, company)

should do.

> CREATE INDEX company ON customer (company);
>
> If I create just the first index, do I still have a fast searching on 
company name ( without mentioning Active )?  like this:
> SELECT * FROM customer WHERE company = 'my test company';

Nope. If you have index only on (active, company), it will not be used in 
the above query.
True.

- Rich

_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: 2 questions about indexing and testing speed

[Victoria Reznichenko]

"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
> 
> 1) As I know, MySQL has a buffer to keep the last records which have been retreived. 
> So if I run a query two times, the second time will be faster. How can I temporarly 
> stop this service? because I want to run different queries and compare their speed 
> and find the best solution for a problem.
> 
> 2) A table has 2 fields, Active CHAR(1), and Company CHAR(40). Sometimes I want to 
> search a company name and sometimes I want to search an active company. For faster 
> searching, do I need to create two index like these:
> CREATE INDEX active ON customer (CONCAT(active, company));
> CREATE INDEX company ON customer (company);
> 
> If I create just the first index, do I still have a fast searching on company name ( 
> without mentioning Active )?  like this:
> SELECT * FROM customer WHERE company = 'my test company';

Nope. If you have index only on (active, company), it will not be used in the above 
query.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fw: 2 questions about indexing and testing speed

[Mojtaba Faridzad]

Hi,

I'm learning MySQL and I got two question:

1) As I know, MySQL has a buffer to keep the last records which have been retreived. 
So if I run a query two times, the second time will be faster. How can I temporarly 
stop this service? because I want to run different queries and compare their speed and 
find the best solution for a problem.

2) A table has 2 fields, Active CHAR(1), and Company CHAR(40). Sometimes I want to 
search a company name and sometimes I want to search an active company. For faster 
searching, do I need to create two index like these:
CREATE INDEX active ON customer (CONCAT(active, company));
CREATE INDEX company ON customer (company);

If I create just the first index, do I still have a fast searching on company name ( 
without mentioning Active )?  like this:
SELECT * FROM customer WHERE company = 'my test company';

Thanks

testing concurrent connections

[my5ql _]

Hi,

Does anyone know of a program/good way to test the number of concurrent 
connections a MySQL server can handle?

I get errors building super smack (and I've also tried an old script called 
mysql-con_stress (by Sascha) with similar results...)

Can anyone help?
I'm using SuSE 8.2, gcc version 3.3 20030226 (prerelease) on a Intel Xeon 
system.
I'm also getting the same errors on a Gentoo Linux system (gcc version 
3.2.2)

Super-smack errors:

c++ -DHAVE_CONFIG_H -I. -I. -I..   -I/usr/local/mysql4/include/mysql  -g -O2 
-c client.cc
In file included from client.h:15,
from client.cc:1:
dictionary.h:15: error: `string' was not declared in this scope
dictionary.h:15: error: 'vector' is used as a type, but is not defined as a
  type.
dictionary.h:17: error: 'string' is used as a type, but is not defined as a
  type.
dictionary.h:59: error: 'string' is used as a type, but is not defined as a
  type.
dictionary.h: In constructor `Unique_dictionary::Unique_dictionary()':
dictionary.h:65: error: class `Unique_dictionary' does not have any field 
named
  `templ'
dictionary.h: In member function `void Unique_dictionary::set_template(const
  char*)':
dictionary.h:71: error: 'class Unique_dictionary' has no member named 
'templ'
In file included from client.h:16,
from client.cc:1:
query.h: At global scope:
query.h:14: error: 'string' is used as a type, but is not defined as a type.
query.h:15: error: 'string' is used as a type, but is not defined as a type.
query.h:16: error: 'string' is used as a type, but is not defined as a type.
query.h: In constructor `Query::Query()':
query.h:20: error: class `Query' does not have any field named `query'
query.h:20: error: class `Query' does not have any field named `name'
query.h:20: error: class `Query' does not have any field named `type_name'
query.h: In member function `Query& Query::operator=(const Query&)':
query.h:33: error: `query' undeclared (first use this function)
query.h:33: error: (Each undeclared identifier is reported only once for 
each
  function it appears in.)
query.h:33: error: 'const class Query' has no member named 'query'
query.h:34: error: `name' undeclared (first use this function)
query.h:34: error: 'const class Query' has no member named 'name'
query.h:35: error: 'const class Query' has no member named 'type_name'
query.h: At global scope:
query.h:109: error: `string' was not declared in this scope
query.h:109: error: `less' was not declared in this scope
query.h:109: error: `string' was not declared in this scope
query.h:109: error: syntax error before `>' token
query.h:136: error: 'vector' is used as a type, but is not defined as a 
type.
query.h:137: error: 'vector' is used as a type, but is not defined as a 
type.
query.h:144: error: 'vector' is used as a type, but is not defined as a 
type.
query.h:171: error: `string' was not declared in this scope
query.h:171: error: parse error before `)' token
query.h:200: error: `string' was not declared in this scope
query.h:201: error: variable declaration is not allowed here
query.h:201: error: syntax error before `{' token
query.h:205: error: semicolon missing after declaration of `Query_barrel'
query.h: In member function `int Query_barrel::num_query_charges()':
query.h:154: error: `qc' undeclared (first use this function)
query.h: In member function `void Query_barrel::add_query_charge(Query&, 
int)':
query.h:161: error: `actions' undeclared (first use this function)
query.h:162: error: 'class Query_report' has no member named 'type_reports'
query.h:162: error: 'class Query' has no member named 'type_name'
query.h:163: error: 'class Query_report' has no member named 'type_reports'
query.h:163: error: 'class Query' has no member named 'type_name'
query.h: In member function `void Query_barrel::update_report(...)':
query.h:173: error: `q_time' undeclared (first use this function)
query.h: At global scope:
query.h:205: error: ISO C++ forbids defining types within return type
query.h:205: error: two or more data types in declaration of `get_run_time'
query.h:205: error: semicolon missing after declaration of `class 
Query_barrel'
query.h: In function `int get_run_time()':
query.h:205: error: `qr' undeclared (first use this function)
query.h: At global scope:
query.h:206: error: parse error before `}' token
In file included from client.h:17,
from client.cc:1:
val.h:8: error: 'string' is used as a type, but is not defined as a type.
val.h:12: error: parse error before `&' token
val.h: In constructor `Val::Val()':
val.h:11: error: class `Val' does not have any field named `strval'
val.h: At global scope:
val.h:13: error: ISO C++ forbids defining types within return type
val.h:13: error: semicolon missing after declaration of `struct Val'
val.h: In function `int Val(const char*)':
val.h:13: error: `set' undeclared (first use this function)
val.h: At global scope:
val.h:14: error: ISO C++ forbids declaration of `Val' with no type
val.h:15: error: ISO C++ forbi

re: Re: [OT] destructive / negative / pathology testing *help, help!*

[Egor Egorov]

On Friday 28 March 2003 11:53, Henning Heil wrote:

> Does anyone have more 'phantasies' on that?

I think, there are no solutions that are ready for that kind of job. Maybe you 
better make a 'test suite' by yourself? 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT] destructive / negative / pathology testing *help, help!*

[Henning Heil]

Egor, all, in addition to my first posting and to clear things up a bit:

I am a little step further at the moment, in general you can say 
negative testing is going beyond the borders of normal (load, stress, 
fail-over, UAT, etc.) testing. Some aspects of negative testing in my 
(just reached and incomplete) sense would now be:

- intercepting & faking post/get/http headers
- inserting SQL-statements into the application forms to corrupt 
databases / tables / etc
- creating queries exceeding max execution time or max number of results 
can be handled
- manually creating / inserting datasets which make the application 
collapse when being read again (by one of the above ways?)
- reverse engineering of java clients, writing your own client and using 
the original client's server connection to do bad things similar to the 
above mentioned (this case would maybe definetly go beyond the point we 
would call 'hacking')
- and also manipulating any kind of software (the JVM?) to reach one or 
more of the following effects

this all leads / should lead the application to stop / shut down / break 
in not a planned way, e.g. without being able to write logs or showing 
readable error messages to the user, stopping the server or doing other 
unattractive things like killing all sessions or throwing all users out.

I mainly concentrate on webapps, but also have to take a look at 
java-clients.
I do not cover destroying hardware (disks ...) or things like that.

Does anyone have more 'phantasies' on that?

Thanks for your posting(s) & your attention again,

Henning



 Egor Egorov wrote on 28.03.2003 09:53 

On Thursday 27 March 2003 14:35, Henning Heil wrote:

Is the crash-me software what are you looking for? 

Check these links: 
http://www.mysql.com/information/crash-me.php
http://www.mysql.com/doc/en/Custom_Benchmarks.html

From the latest link, a cite: 
To avoid problems like this, you should put some effort into benchmarking   
your whole application under the worst possible load! You can use Super Smack 
for this, and it is available at: 
http://www.mysql.com/Downloads/super-smack/super-smack-1.0.tar.gz. As the 
name suggests, it can bring your system down to its knees if you ask it, so 
make sure to use it only on your development systems.

Try it. 

 

Hi all together!

Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
topic (I wouldn't ask here if not).
Does anyone have web-links, pdf or other files and can provide those to
me? Topics of interest might be a test strategy for "negative testing"
or _even_more_ concrete samples of test cases! Most documents if found
say that one can convert existing test cases to negative test cases BUT
how?
Focused on databases "negative testing" could mean sth like submitting
SQL-statements which cause destructive behaviour inserted into search
forms or similar. Something similar would be to intercept post-string or
modify http-headers. Any more ideas?
Any help will be welcome - thanks a lot!

Rgds,

Henning Heil

P.S.: This must not necessarily go over the list, PM will be fine.
P.P.S.: If anyone is interested in I can provide the material I found so
far
filters?
sql, query, mysql
   

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: [OT] destructive / negative / pathology testing *help, help!*

[Egor Egorov]

On Thursday 27 March 2003 14:35, Henning Heil wrote:

Is the crash-me software what are you looking for? 

Check these links: 
http://www.mysql.com/information/crash-me.php
http://www.mysql.com/doc/en/Custom_Benchmarks.html

>From the latest link, a cite: 

To avoid problems like this, you should put some effort into benchmarking   
your whole application under the worst possible load! You can use Super Smack 
for this, and it is available at: 
http://www.mysql.com/Downloads/super-smack/super-smack-1.0.tar.gz. As the 
name suggests, it can bring your system down to its knees if you ask it, so 
make sure to use it only on your development systems.

Try it. 

> Hi all together!
>
> Meanwhile I found out that what I am looking for is best known as
> "negative testing", trying to break an application puckish, to make it
> fail more or less serious by going bejond the borders. I am really
> really in a hurry (and stuck at the moment) getting information on this
> topic (I wouldn't ask here if not).
>
> Does anyone have web-links, pdf or other files and can provide those to
> me? Topics of interest might be a test strategy for "negative testing"
> or _even_more_ concrete samples of test cases! Most documents if found
> say that one can convert existing test cases to negative test cases BUT
> how?
>
> Focused on databases "negative testing" could mean sth like submitting
> SQL-statements which cause destructive behaviour inserted into search
> forms or similar. Something similar would be to intercept post-string or
> modify http-headers. Any more ideas?
>
> Any help will be welcome - thanks a lot!
>
> Rgds,
>
> Henning Heil
>
>
> P.S.: This must not necessarily go over the list, PM will be fine.
> P.P.S.: If anyone is interested in I can provide the material I found so
> far
>
>
> filters?
> sql, query, mysql




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[OT] destructive / negative / pathology testing *help, help!*

[Henning Heil]

Hi all together!

Meanwhile I found out that what I am looking for is best known as 
"negative testing", trying to break an application puckish, to make it 
fail more or less serious by going bejond the borders. I am really 
really in a hurry (and stuck at the moment) getting information on this 
topic (I wouldn't ask here if not).

Does anyone have web-links, pdf or other files and can provide those to 
me? Topics of interest might be a test strategy for "negative testing" 
or _even_more_ concrete samples of test cases! Most documents if found 
say that one can convert existing test cases to negative test cases BUT how?

Focused on databases "negative testing" could mean sth like submitting 
SQL-statements which search forms or similar. Any more ideas?

Any help will be welcome - thanks a lot!

Rgds,

Henning Heil

P.S.: This must not necessarily go over the list, PM will be fine.
P.P.S.: If anyone is interested in I can provide the material I found so far
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[OT] destructive / negative / pathology testing *help, help!*

[Henning Heil]

Hi all together!

Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
topic (I wouldn't ask here if not).
Does anyone have web-links, pdf or other files and can provide those to
me? Topics of interest might be a test strategy for "negative testing"
or _even_more_ concrete samples of test cases! Most documents if found
say that one can convert existing test cases to negative test cases BUT how?
Focused on databases "negative testing" could mean sth like submitting
SQL-statements which cause destructive behaviour inserted into search 
forms or similar. Something similar would be to intercept post-string or 
modify http-headers. Any more ideas?

Any help will be welcome - thanks a lot!

Rgds,

Henning Heil

P.S.: This must not necessarily go over the list, PM will be fine.
P.P.S.: If anyone is interested in I can provide the material I found so far
filters?
sql, query, mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Testing thr list

[Ahmed S K Anis]

>>> Francesco Leonetti <[EMAIL PROTECTED]> Sunday, February 09, 2003
5:43:45 AM >>>
Dear list,

I've been searching the archives before posting this request since it 
is about something you've already discussed. But I didn't find the 
solution, so here it comes my question.

It is about RAM consuming.

I'm running a PHP/mysql application on a redhat 8.1 - kernel 2.4-18 - 
512 MB RAM system.
I'm using mysql 3.23.54a mysql-server and PHP 4.2.2.

I understand that mysqld won't steal too much RAM as long as it is well

tuned.
I'm not sure I succeeded in tuning the mysqld so here it follows the 
relavant part of my.cnf, the values are calculated by logging the 
mysqld status:

set-variable= key_buffer=16M
set-variable= max_allowed_packet=1M
set-variable= table_cache=100
set-variable= sort_buffer=512k
set-variable= net_buffer_length=8K
set-variable= myisam_sort_buffer_size=8M
set-variable= max_connections=200
set-variable= max_user_connections=200
set-variable= wait_timeout=300
skip-innodb
skip-bdb

While there are 23 threads running and 100 opened tables, I see from 
the "top" tool that a great amount of RAM is allocated as "cached". 
Typically from 200 to 350 MB, leaving the rest to the processes. This 
leads very soon to a degradation of the system performance (the swap 
memory increases dramatically). In some other posts of this list I 
found out that this couldn't be neccessarily related to mysqld 
activities but to some other linux kernel matters (I didn't understand

which one precisely).

Well, I have another server, configured exactly as the previous one. 
This is a sort of backup server ready to be used in case the main one 
crashes. No one but me is accessing this second server.
I notice that the amount of RAM allocated as "cached" is pretty low 
(around 80MB). But at the time I start browsing some web pages 
(involving mysql queries) the RAM used as "cached" increases quickly.

Am I wrong in thinking that there must be some relationship between 
mysql queries and kernel cache memory? (maybe filesystem caching 
related to index and tables files??)
I cannot find out how to prevent the kernel from caching so much
memory.
The only thing I've been  able to do for now is just rebooting the 
system.
Of course I cannot keep doing that.

What is wrong? Is something that I have to fix on the mysql side or on

the linux side?

This is driving me crazy so any help would be precious and
appreciated.

Thank you.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Testing

[C. Reeve]

Testing - Mysql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Testing the Server Load

[Sankaranarayanan Mahadevan]

Dear All,

we have developed a web-based application for a client
and now in its testing phase by next week...
It uses Linux/PHP 4/MySQL 3.23

As the volume of user will be more, we are very much
concerned about the server efficiency and our
application efficiency/performance...

Following are the one we need to database server...
1. server performance
2. the database load
3. efficiency query
4. execution time 
5. how many inserts/updates taking place
6. volume of data involved
and so on...

Is there any tools available for this?
Any idea about testing the mysql server?

Thanks a lot.

Shankar


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Testing New Install

[Egor Egorov]

DeNewbie,
Monday, September 30, 2002, 9:36:03 PM, you wrote:
D> I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake 
running mysql_install_db and afterwards running the commands;

D> /usr/bin/mysqladmin -u root  password 'new-password'

D> mysqladmin -u pazin1 sqlpass

D> and;

D> /usr/bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'

D> mysqladmin -u pazin1 -h hostpass

D> After inputting these passwords as I was told by mysql_install_db was this 
absolutely necessary or did I make my life more difficult as a newbie. Anyway after 
doing that I followed more
D> instructions from p.115 of my MySQL Reference manual written by Mr.Widenius. From 
your advice I was able to get some results for the mysqlshow command; I don't know 
where the test database came
D> from I did not see it from the result in my Reference Manual;

Database 'test' is created by default. If you don't need the one, you
can drop it.

[skip]

D> then when I enter what one person told me to enter I get this;


D> cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass
D> Enter password:
D> mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES)
D> cords-orj86jfje:/usr/bin #

D> (regardless of what password I entered I was continously kicked out)

But you didn't set up password for user 'pazin1'.

  D> mysqladmin -u pazin1 sqlpass

The above isn't correct for setting up password.

D> I would also like use the mysqladmin version command to see what pops up but I 
simply get no results no matter what I type in;

D> cords-orj86jfje:/usr/bin # mysqladmin version
D> cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass
D> cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1
D> cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass
D> cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass

"no results" means that you didn't get any errors, any output etc,
right?

D> I would also like to know how to shut down the mysql server,how do i do this, it 
does not seem to want to shut down;

D> cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown
D> cords-orj86jfje:/usr/bin # safe_mysqld &
D> [1] 1404
D> cords-orj86jfje:/usr/bin # A mysqld process already exists

As I understand you didn't create user 'pazin1'. By default MySQL
gives permissions to user 'root' and anonymous user. Anonymous user
means that any user can connect to the MySQL server, but it has
permissions only on the database 'test' and doesn't have permissions
to shutdown MySQL server. So, MySQL still is running.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Testing New Install

[DeNewbie]

I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running 
mysql_install_db and afterwards running the commands;

/usr/bin/mysqladmin -u root  password 'new-password'

mysqladmin -u pazin1 sqlpass

and;

/usr/bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'

mysqladmin -u pazin1 -h hostpass

After inputting these passwords as I was told by mysql_install_db was this absolutely 
necessary or did I make my life more difficult as a newbie. Anyway after doing that I 
followed more instructions from p.115 of my MySQL Reference manual written by 
Mr.Widenius. From your advice I was able to get some results for the mysqlshow 
command; I don't know where the test database came from I did not see it from the 
result in my Reference Manual;

cords-orj86jfje:/usr/bin # mysqlshow -u pazin1
+---+
| Databases |
+---+
| mysql |
| test  |
+---+
cords-orj86jfje:/usr/bin # mysqlshow -u sqlpass
+---+
| Databases |
+---+
| mysql |
| test  |
+---+
cords-orj86jfje:/usr/bin # mysqlshow -u hostpass
+---+
| Databases |
+---+
| mysql |
| test  |
+---+

then when I enter what one person told me to enter I get this;


cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass
Enter password:
mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES)
cords-orj86jfje:/usr/bin #

(regardless of what password I entered I was continously kicked out)



I would also like use the mysqladmin version command to see what pops up but I simply 
get no results no matter what I type in;

cords-orj86jfje:/usr/bin # mysqladmin version
cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass
cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1
cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass
cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass



I would also like to know how to shut down the mysql server,how do i do this, it does 
not seem to want to shut down;

cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown
cords-orj86jfje:/usr/bin # safe_mysqld &
[1] 1404
cords-orj86jfje:/usr/bin # A mysqld process already exists




Thanks, DeNewbie

P.S. I am using SuSe Linux 7.3 and I am using the latest MySQL binary rpm downloads 
ver 3.23 .





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

testing mysql

[Nicholas Stuart]

Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.


 TEST USER   SYSTEM  ELAPSEDRESULT

alias      [ fail ]

/home/nstuart/mysql-3.23.49/bin/mysqltest: Failed in mysql_real_connect():
Can't connect to local MySQL server through socket
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)
Command exited with non-zero status 1 real 0.01 user 0.01 sys 0.01
Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

/home/nstuart/mysql-3.23.49/bin/mysqladmin: connect to server at
'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)'
Check that mysqld is running and that the socket:
'/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' exists!
Master shutdown finished

I would like to simply run the test on the server that is running but
apparently it doesn't want to do that. I thought I changed the correct
settings in the mysql-test-run but apparently not. Also tried the
mysql-test-run --local but that do anything different.
Also, I dont want to run the slave test either but again the --skip-rpl
seems to do nothing.
Thanks for all the help!
-Nick



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Debian (Woody/Testing) version of MySql

[Jeremy Zawodny]

On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote:
> Hi
> 
> We have just moved out test server from RedHat to Debian.
> 
> We have used the backup tapes to recover the data, and all went well to until 
> we tried to connect via a host name.
> 
> For example
> 
> mysql test -utest_user -ptest_passwd
> 
> works fine, but
> 
> mysql -hserver -utest_user -ptest_passwd
> 
> reports the error
> 
> ERROR 2003: Can't connect to MySQL server on 'server' (111) 
> 
> The grants in the user/db tables are all ok, and worked on the RedHat box 
> (3.23-49). 
> 
> Any ideas what is happening with Debian version, also (3.23-49)

Remove the skip-networking option from the my.cnf file on your
server.  It's documented in the Debian MySQL docs. :-)

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.51: up 33 days, processed 740,610,078 queries (254/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Debian (Woody/Testing) version of MySql

[Simon Windsor]

Hi

We have just moved out test server from RedHat to Debian.

We have used the backup tapes to recover the data, and all went well to until 
we tried to connect via a host name.

For example

mysql test -utest_user -ptest_passwd

works fine, but

mysql -hserver -utest_user -ptest_passwd

reports the error

ERROR 2003: Can't connect to MySQL server on 'server' (111) 

The grants in the user/db tables are all ok, and worked on the RedHat box 
(3.23-49). 

Any ideas what is happening with Debian version, also (3.23-49)

Simon

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Here is a Servlet for Testing Servlet-JDBC Connections & JDBCDrivers

[Amandeep Jawa]

Hi folks -

Here is my thank you for everyone's help getting PostgreSQL/mySQL and
various JDBC drivers running on Linux/ NT/ & MacOSX.
---

Servlet Container / JDBC / HTTPD Validation Application

http://www.worker-bee.com/projects/servlet_validate/index.html


This is a simple Java Servlet based Web Application I wrote to help
developers confirm that their HTTPD Server / Servlet Container & JDBC
compliant databases are all working properly. It is also useful for testing
JDBC drivers. 

It is written entirely in Java & all source code & make files are included
(for MacOS X/Linux/Windows). It should run on any Java Servlet 2.0 compliant
servlet container.

It comes preconfigured for use with:

*PostgreSQL
*mySQL
*MS SQL Server

However, adding the ability to test other databases is TRIVIAL. I
preconfigured it for every major database that I had an installation of & a
free driver for. If you have a free driver for another database & an
installation of that database I could test against, let me know & maybe I'll
have time to add it


Installation is simple if you are familiar with the Java Servlet 2.0
specification: 

1.Download the WAR file from the link above.
2.Copy it to your servlet container's webapps directory (i.e.
$TOMCAT_HOME/webapps)
3.Restart your servlet container.
4.Restart your HTTPD server (if you have one)
5.Access the web app at http://localhost:8080/Servlet_JDBC_Validate/ (if
no HTTPD server) or http://localhost/Servlet_JDBC_Validate/ (if you are
running both an HTTPD Server & a Servlet Container)


Let me know if you find this to be useful & if you need more detailed usage
notes - maybe I'll write some up. Also feel free to modify & improve the
source code.

'deep


--
Amandeep Jawa
Worker Bee Software
--
[EMAIL PROTECTED]
225A Dolores St.
San Francisco, CA 94103-2202

Home: 415 255 6257 (ALL MALP)

professional: http://www.worker-bee.com
personal: http://www.deeptrouble.com
political: http://www.sflcv.org





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Request for help in testing new replication code in 4.0.2

[Steven Roussey]

That would be great. Thanks!

Sincerely,
Steven Roussey
http://Network54.com/?pp=e

> -Original Message-
> From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 10:45 pm
> Subject: RE: Request for help in testing new replication code in 4.0.2
> 
> I have finished a script that takes the bit keeper sources and makes
> MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well.  I can put
> these
> up on our site for download if you want.  They might get others trying
the
> code out.
> 
> I use the spec file included with the source code.
> I'll put it up if it's something you might find useful.
> 
> -Original Message-
> From: Steven Roussey [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 12:41 PM
> To: 'Sasha Pachev'
> Cc: 'Mysql'
> Subject: Re: Request for help in testing new replication code in 4.0.2
> 
> 
> > >  * If you want to do it this very moment, read the instructions at
> > >http://www.mysql.com/doc/I/n/Installing_source_tree.html and
> install a
> > > pre-release 4.0.2 MySQL on your test server. You may also wait
until
> 4.0.2 is
> > > released, but in that case, replication in 4.0.2 may have a bug
you
> could
> > > have caught on your system and it will not be fixed until 4.0.3.
> >
> > Is that possible to provide a binary snapshot of the pre-release?
> > This can be done with some simple shell scripting, I think.
> > I always found the one I build myself is about 30-50% slower
> > then the official binary. I think that's related to the debian
patched
> > glibc-2.95 I am using.
> 
> Hi,
> 
> I have to agree with this. I don't want to have to factor in RedHat's
> 7.2 compiler oddities (which one to use?). Some software projects have
a
> machine to do regular builds on a schedule. This would be ideal. You
> would find more people testing it. You might just do it in special
cases
> like this one.
> 
> > Testing the new code is relatively easy, and does not require
risking
> the
> > stability of your application by running alpha code.
> 
> Yes and no. Taking down a server and copying gigs of data can take
down
> a service for a long time (moving gigs of data just is never fast, and
> the machine I'm going to use has lots of power but no RAID).
> 
> I don't have time to download and install gcc, bitkeeper, autoconf
2.13,
> automake 1.4, libtool, m4, and mysql today, but I'll try and get to it
> this week. Taking down the server will have to wait until maintenance
> windows over the weekend anyhow.
> 
> Our test plan for MySQL 4 is as follows:
> 
> 1. Serialized writes (i.e. replication slave) for two weeks (or about
1
> billion insert/update/delete type queries) with no crashes.
> 
> 2. Everything. We will have the app send duplicates of all queries to
> the mysql 4 server, but will automatically halt when mysql 4 crashes.
We
> will keep trying this until mysql doesn't crash for a week.
> 
> 3. Check that the two servers hold the same information and return the
> same results from queries.
> 
> With the type and volume of queries that we have, mysql alpha versions
> either fail within minutes/hours/days or they don't fail at all. We
> certainly are not the biggest user of mysql, but historically, we have
> been able to push it hard enough to crash. Not the stable version
> though. Thankfully, that takes a licking and keeps on ticking. :)
> 
> Eventually (spring/summer), we will move the main server to v4 and
keep
> the slave around as a live backup. I've been wanting such a slave for
a
> long time. Stopping the slave to make a backup would be great. Not to
> mention faster fulltext and order by DESC.
> 
> Sincerely,
> Steven Roussey
> http://Network54.com/?pp=e
> 
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Request for help in testing new replication code in 4.0.2

[Brian P. Austin]

I have finished a script that takes the bit keeper sources and makes
MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well.  I can put these
up on our site for download if you want.  They might get others trying the
code out.

I use the spec file included with the source code.
I'll put it up if it's something you might find useful.

-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:41 PM
To: 'Sasha Pachev'
Cc: 'Mysql'
Subject: Re: Request for help in testing new replication code in 4.0.2


> >  * If you want to do it this very moment, read the instructions at
> >http://www.mysql.com/doc/I/n/Installing_source_tree.html and
install a
> > pre-release 4.0.2 MySQL on your test server. You may also wait until
4.0.2 is
> > released, but in that case, replication in 4.0.2 may have a bug you
could
> > have caught on your system and it will not be fixed until 4.0.3.
>
> Is that possible to provide a binary snapshot of the pre-release?
> This can be done with some simple shell scripting, I think.
> I always found the one I build myself is about 30-50% slower
> then the official binary. I think that's related to the debian patched
> glibc-2.95 I am using.

Hi,

I have to agree with this. I don't want to have to factor in RedHat's
7.2 compiler oddities (which one to use?). Some software projects have a
machine to do regular builds on a schedule. This would be ideal. You
would find more people testing it. You might just do it in special cases
like this one.

> Testing the new code is relatively easy, and does not require risking
the
> stability of your application by running alpha code.

Yes and no. Taking down a server and copying gigs of data can take down
a service for a long time (moving gigs of data just is never fast, and
the machine I'm going to use has lots of power but no RAID).

I don't have time to download and install gcc, bitkeeper, autoconf 2.13,
automake 1.4, libtool, m4, and mysql today, but I'll try and get to it
this week. Taking down the server will have to wait until maintenance
windows over the weekend anyhow.

Our test plan for MySQL 4 is as follows:

1. Serialized writes (i.e. replication slave) for two weeks (or about 1
billion insert/update/delete type queries) with no crashes.

2. Everything. We will have the app send duplicates of all queries to
the mysql 4 server, but will automatically halt when mysql 4 crashes. We
will keep trying this until mysql doesn't crash for a week.

3. Check that the two servers hold the same information and return the
same results from queries.

With the type and volume of queries that we have, mysql alpha versions
either fail within minutes/hours/days or they don't fail at all. We
certainly are not the biggest user of mysql, but historically, we have
been able to push it hard enough to crash. Not the stable version
though. Thankfully, that takes a licking and keeps on ticking. :)

Eventually (spring/summer), we will move the main server to v4 and keep
the slave around as a live backup. I've been wanting such a slave for a
long time. Stopping the slave to make a backup would be great. Not to
mention faster fulltext and order by DESC.

Sincerely,
Steven Roussey
http://Network54.com/?pp=e




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Request for help in testing new replication code in 4.0.2

[Chris Mulcahy]

It could also have been fixed by changing the:
  DBUG_POP();
to:
  DBUG_POP()

Notice the ; on the end effectively terminating the if statement.

Happy coding.
Chris

> -Original Message-
> From: Jeremy Zawodny [EMAIL PROTECTED] 
> [mailto:X]
> Sent: Sunday, February 10, 2002 3:28 PM
> To: 
> Subject: Re: Request for help in testing new replication code in 4.0.2
> 
> 
> On Sun, Feb 10, 2002 at 10:24:30PM +0100, Fournier Jocelyn 
> [Presence-PC] wrote:
> > Hi,
> > 
> > In myisamchk.c replace the following line :
> > 
> >if (argument && *argument == '0')
> >   DBUG_POP();
> > else
> >   DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
> > 
> > by
> > 
> > if (argument && *argument == '0')
> > {
> >   DBUG_POP();
> > }
> > else
> > {
> >   DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
> > }
> > 
> > Like this it works perfectly for me :)
> 
> Yeah, that works.  I had just commented out that bit and moved on.
> Worked fine after that.
> 
> Since I didn't know if it was just a typo or the result of an
> incomplete commit, I didn't want to try and "fix" it.
> 
> But I'll probably use you solution until a fix is pushed.
> 
> Thanks,
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
> 
> MySQL 3.23.47-max: up 3 days, processed 113,132,847 queries 
> (396/sec. avg)
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php