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

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

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: 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

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

RE: Question about testing memcmp()

2012-06-25 Thread Stillman, Benjamin
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

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:

[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 -- MySQL

Re: unauthenticated user | while load testing

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

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-06-01 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,

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

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

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

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 test cases?

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

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: 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]

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: mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:31 PM Subject: Re: Testing Email Nicholas Vettese wrote: I have been having

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: mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:31 PM Subject: Re: Testing Email Nicholas Vettese wrote: I have been

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

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

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-14 Thread Dan Trainor
- 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

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

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 doing something

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 [semi]real-world

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 live MySQL server, to a testing server at the office

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

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

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

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

[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

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

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

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: 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'

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',

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:

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 mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT

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

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

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

Re: Upgrading to MySQL 5 (for testing)

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

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

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--it

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

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

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 bulk-loading

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

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 keep

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 Anyone know

Re: R: Large sample data sets for testing

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

Large sample data sets for testing

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

Re: Large sample data sets for testing

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

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 we received and also attached are the logs. Chris Installing

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

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 available

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, after all

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]

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]

just testing

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

Just testing please ignore

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

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.mysql.com

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: 'Access denied for user

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 shutdown ./bin/mysqladmin: connect

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 want to

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 to

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

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: [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: 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

[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 information on this topic

[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 information

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, e-mail

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

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

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

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

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

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

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

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

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 I have finished

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

2002-02-12 Thread SDiZ (UHome)
* 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

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

2002-02-12 Thread Jeremy Zawodny
which processes the logged data. I have tested it extensively, and it has passed all of my tests. However, as we all know, field testing tends to find nasty bugs that have not been caught in regression tests and visual code examination. Excellent. I'm ready to test... Testing the new code

Request for help in testing new replication code in 4.0.2

2002-02-12 Thread Sasha Pachev
, and it has passed all of my tests. However, as we all know, field testing tends to find nasty bugs that have not been caught in regression tests and visual code examination. So I need your help with field testing of my code. For those of you who are wondering why you should - this will help us

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

2002-02-12 Thread Fournier Jocelyn [Presence-PC]
10:20 PM Subject: Re: Request for help in testing new replication code in 4.0.2 On Sat, Feb 09, 2002 at 09:41:25PM -0700, Sasha Pachev wrote: Dear MySQL users, I have just pushed my latest changes in the replication code in our 4.0 development tree, which change the slave to use two

  1   2   >