Re: MySQL optimization for testing purpose

2018-04-04 Thread 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

Re: MySQL optimization for testing purpose

2018-04-03 Thread 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

MySQL optimization for testing purpose

2018-04-03 Thread 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

Re: MySQL Enterprise Monitor Testing

2012-11-11 Thread 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 Enterprise Monitor Testing

2012-11-11 Thread 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

RE: Question about testing memcmp()

2012-06-25 Thread Stillman, Benjamin
l.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/mys

Re: Question about testing memcmp()

2012-06-25 Thread 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()

2012-06-24 Thread 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

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

2011-02-24 Thread 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 --

Re: unauthenticated user | while load testing

2011-01-05 Thread Carsten Pedersen
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

2011-01-04 Thread 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?

2010-05-31 Thread 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

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

2009-04-28 Thread 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

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

2008-10-27 Thread 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

Re: Corrupting MySQL on purpose for testing

2007-11-07 Thread 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

Re: Corrupting MySQL on purpose for testing

2007-11-07 Thread 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

Re: Corrupting MySQL on purpose for testing

2007-11-06 Thread 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 a

Re: Corrupting MySQL on purpose for testing

2007-11-06 Thread 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

Re: Corrupting MySQL on purpose for testing

2007-11-06 Thread 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

Corrupting MySQL on purpose for testing

2007-11-06 Thread 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

RE: Testing Email

2006-08-25 Thread Nicholas Vettese
: 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 V

Re: Testing Email

2006-08-25 Thread 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:

Re: Testing Email

2006-08-25 Thread 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

2006-08-25 Thread 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

2006-08-07 Thread 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). Altho

Transactions and testing an Insert statement

2006-08-07 Thread 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 dir

Re: Replicating queries to testing server

2006-06-14 Thread Dan Trainor
i, 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 imp

Re: Replicating queries to testing server

2006-06-14 Thread 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

Re: Replicating queries to testing server

2006-06-13 Thread 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 li

Re: Replicating queries to testing server

2006-06-13 Thread 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 [sem

Re: Replicating queries to testing server

2006-06-13 Thread 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

Re: Replicating queries to testing server

2006-06-13 Thread 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

Re: Replicating queries to testing server

2006-05-24 Thread 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

Re: Replicating queries to testing server

2006-05-24 Thread 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

Re: Replicating queries to testing server

2006-05-24 Thread 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

Replicating queries to testing server

2006-05-24 Thread 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

[off-topic] testing mailing list

2006-05-23 Thread 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

2006-02-01 Thread 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 i

Re: Testing Concurrent Insert on InnoDB

2006-01-31 Thread 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_in

Re: Testing Concurrent Insert on InnoDB

2006-01-31 Thread 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 tabl

Re: Testing Concurrent Insert on InnoDB

2006-01-30 Thread 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

Re: Testing Concurrent Insert on InnoDB

2006-01-30 Thread 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

Testing Concurrent Insert on InnoDB

2006-01-30 Thread 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

Re: [MySQL] Testing

2006-01-07 Thread 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 Dir

Testing

2006-01-07 Thread 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.mys

Re: testing for connectivity to database

2006-01-05 Thread 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

testing for connectivity to database

2005-12-31 Thread 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 caus

Re: High Load testing

2005-05-04 Thread 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

High Load testing

2005-05-04 Thread 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

Re: Upgrading to MySQL 5 (for testing)

2004-12-20 Thread Gleb Paharenko
lation 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.m

Upgrading to MySQL 5 (for testing)

2004-12-17 Thread 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

Re: just testing, sorry.

2004-10-19 Thread 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 E

just testing, sorry.

2004-10-18 Thread 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

2004-09-28 Thread 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

2004-08-25 Thread 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--

Re: Testing for the existence of an index

2004-08-24 Thread 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 mi

Re: Testing for the existence of an index

2004-08-23 Thread 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 kee

Re: Testing for the existence of an index

2004-08-23 Thread 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 P

RE: Testing for the existence of an index

2004-08-23 Thread 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 bu

Testing for the existence of an index

2004-08-23 Thread 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 pos

Re: R: Large sample data sets for testing

2004-05-22 Thread mos
rge 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

R: Large sample data sets for testing

2004-05-22 Thread 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

Re: Large sample data sets for testing

2004-05-21 Thread Dan Nelson
t;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 examp

Large sample data sets for testing

2004-05-21 Thread Greg Willits
gh, 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 l

MySQL testing programs

2004-04-19 Thread 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 p

MySQL Testing Problems

2003-12-20 Thread 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

MySQL Testing Problems

2003-12-16 Thread 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

No testing server running (OS X + DW MX)

2003-12-08 Thread Lost Idols
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. Wh

Re: stress testing

2003-12-02 Thread Gabriel Ricard
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, afte

stress testing

2003-12-02 Thread 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 availab

Testing again

2003-09-05 Thread 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

2003-09-05 Thread 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

2003-08-14 Thread Binay Agarwal
Testing ..Please ignore this email

just testing

2003-08-14 Thread Binay Agarwal
Testing ..Please ignore this email

Testing Blocking

2003-07-28 Thread 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

2003-07-19 Thread 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

Help required on testing MySQL with Open SSL

2003-06-23 Thread 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.mysq

Re: Post-installation Testing

2003-06-19 Thread 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

Post-installation Testing

2003-06-19 Thread 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: 'Acce

Re: Fw: 2 questions about indexing and testing speed

2003-06-10 Thread 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

Re: Fw: 2 questions about indexing and testing speed

2003-06-10 Thread 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

Fw: 2 questions about indexing and testing speed

2003-06-09 Thread 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 sp

testing concurrent connections

2003-06-05 Thread 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

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

2003-03-28 Thread 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=ensit

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

2003-03-28 Thread 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

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

2003-03-28 Thread Egor Egorov
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 bej

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

2003-03-27 Thread 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 informati

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

2003-03-27 Thread 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 informati

Testing thr list

2003-02-10 Thread 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 consu

Testing

2003-02-10 Thread 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,

Testing the Server Load

2002-12-22 Thread 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

re: Testing New Install

2002-10-01 Thread 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>

Testing New Install

2002-09-30 Thread 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-pass

testing mysql

2002-07-03 Thread 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 --

Re: Debian (Woody/Testing) version of MySql

2002-07-02 Thread 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

Debian (Woody/Testing) version of MySql

2002-07-02 Thread 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

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

2002-02-28 Thread Amandeep Jawa
r-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 ent

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

2002-02-13 Thread 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

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

2002-02-13 Thread Brian P. Austin
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 &g

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

2002-02-12 Thread Chris Mulcahy
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, > > >

  1   2   >