ignore
On 6/18/2015 1:25 PM, AZ 9901 wrote:
Hello,
I only get SPAM answers when I try to post to this list so here is a simple
message…
Sorry…
Marc.
your message came through on gmane.comp.db.mysql.general just fine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Hello,
I only get SPAM answers when I try to post to this list so here is a simple
message…
Sorry…
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Thanks a lot, Eric!
Yes, unfortunately, I'm trying to use them to do some specific testing.
One thing bugged me is that even testing on a clean mysqld with the default
configuration, some "--extern" test fails. I guess it is because these test
cases are not supported.
By the
t be
used with tests that start or stop mysqld servers like the replication
tests.
On Sat, Nov 24, 2012 at 12:16 AM, Tianyin Xu wrote:
> Hi, all,
>
> I wanna test my running MySQL server. According to the README in the
> "mysql-test" directory, "If you want to use an al
Hi, all,
I wanna test my running MySQL server. According to the README in the
"mysql-test" directory, "If you want to use an already running MySQL server
for specific tests, use the --extern option to mysql-test-run".
For example, mysql-test-run --extern alias
But the REA
Looks like your test succeeded and you win!!!
On Thu, May 19, 2011 at 9:41 AM, Adarsh Sharma wrote:
>
> Hi all,
>
> Thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?
Hi all,
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
t; [[...]]
> From: root
> [[...]]
> main.information_schema_chmod [ fail ]
> Test ended at 2010-09-11 14:14:46
> CURRENT_TEST: main.information_schema_chmod
> ---
> /usr/local/mysql-5.1.50-linux-i686-glibc23/mysql-test/r/information_schema_$
> +++
> /usr/local/mysql-5.1.50-linux-i686-g
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [Failed on test 761, perl mysql-test-run.pl]
>Description
i said: ignore!
But did it work?
;-)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelo
i said: ignore!
--
hartmut
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi all,
I'm new to mysql and I'm looking into some bug cases of mysql.
I tried to reproduce some bugs and the reports referred to the
mysql-test-extra-6.0 branch. I also found that this branch is renamed to
mysql-test-extra.
The problem is, when I try to use bazaar to get this bra
guys don't simulate realistic workload in benchmark just
do sysbench or something like that? If there were a tool for that (which can
handle data generation, initial database generation, and query generation,
maybe it's output will be a jmeter test case) would you do so?
Peter
petya
,
> maybe it's output will be a jmeter test case) would you do so?
>
> Peter
>
>
> petya wrote:
>
>> I use jmeter too, but it can't generate the test dataset (if I have to
>> write this, I plan that it will create a jmeter test case with the generated
>&g
ation, initial database generation, and query generation,
> maybe it's output will be a jmeter test case) would you do so?
>
> Peter
>
>
> petya wrote:
>
>> I use jmeter too, but it can't generate the test dataset (if I have to
>> write this, I plan
Anyone else? You guys don't simulate realistic workload in benchmark
just do sysbench or something like that? If there were a tool for that
(which can handle data generation, initial database generation, and
query generation, maybe it's output will be a jmeter test case) would
I use jmeter too, but it can't generate the test dataset (if I have to
write this, I plan that it will create a jmeter test case with the
generated test data). Usually my ad-hoc script generates csv files (to
load initial data) and jmeter test cases.
Michael Dykman wrote:
On Wed, Jun 3,
Hi,
We have lots of mysql servers, master-slave and sharded databases. A
recurring task when a new feature/application comes in to test the
database with real workload. This needs test data and test query
generation. Until now I did this with ad-hoc scripts, I looked for tools
to do this, so
How to Create a Test Case
http://forge.mysql.com/wiki/How_to_Create_a_Test_Case
This Thursday (April 2nd, 14:00 UTC), Patrick Crews will give a MySQL
University session on How to Create a Test Case. This is an updated
session of a talk we had in 2007, but this time it will be recorded
(slides and
Hi,
For mysql stress test suite (mysql-stress-test.pl) to execute, it requires
--stress-tests-file to be provided which contains the list of tests to be
executed. As per the documentation the default name of the file is
stress-test.txt and it will be located under ./mysql-test directory.
But I
Hi Alex, all!
Alex Katebi wrote:
> Any information on how to run the test scripts for the embedded client.
Call the test script, "mysql-test-run.pl", and pass it the option
--embedded-server
It does not support replication or cluster, so you should add
--skip-rpl --sk
Any information on how to run the test scripts for the embedded client.
Thanks,
-Alex
Test E-mail
Mikhail Berman
hope this helps
bb
-Original Message-
From: Brown, Charles [mailto:[EMAIL PROTECTED]
Sent: Tue 3/27/2007 12:17 PM
To: mysql@lists.mysql.com
Subject: a Linux -csh script to refresh test with production
Hello all.
Does anyone out there (in mysql world) have a Linux -csh script to
refresh
If test and production are supposed to be identical, then use this:
mysqldump -h -u... -p... --triggers --routines |
mysql -h -u... -p... -A -D
If you havn't noticed, you do not dump the data to a file and ftp or scp
anything anywhere !!!
This will actually pipe all mysqldump com
Hello all.
Does anyone out there (in mysql world) have a Linux -csh script to
refresh test with production data.
My developers would like their test database to be refreshed nightly
with production data. The production and test mysql servers do not run
in the same box. They run on different
Sent: Friday, February 23, 2007 10:48:27 AM (GMT-0500) Auto-Detected
Subject: copy data from prod to test - when database name is not the same name
Hello All, We have two mysql environment PROD and TEST. I would like to
copy data from PROD to TEST. The PROD database name is Mysql_prod and
the TEST d
Hello All, We have two mysql environment PROD and TEST. I would like to
copy data from PROD to TEST. The PROD database name is Mysql_prod and
the TEST database name is mysql_TEST. Using mysqldump or any applicable
utility can someone show me how to migrate my production data from prod
to test
Sorry, but I haven't gotten any emails from the list and I'm trying to
determine if there is a blockages. Sorry to disturb the list.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archive
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking "return type of sprintf"... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
Hi !
Any clue will be appriciated.
I have following problem while cross compiling for powerpc. (Configure)
checking "return type of sprintf"... configure: error: cannot run test
program while cross compiling
This occurs when makefile is generated with the following configure option.
urce.
http://www.mysqlperformanceblog.com/category/hardware/
On 7/27/06, Vahric MUHTARYAN <[EMAIL PROTECTED]> wrote:
Hello ,
I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron
platforms for looking differents which one is better then other !
I found something but I want to asl to
Hello ,
I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron
platforms for looking differents which one is better then other !
I found something but I want to asl to list , is there anybody have an
experiance about this type tests !
Regards
Vahric MUHTARYAN
Sistem
On Sunday 23 July 2006 10:26 pm, ali asghar torabi parizy wrote:
> while ((row = mysql_fetch_row(res_set)) != NULL) {
while (row = mysql_fetch_row(res_set))
would do the same thing, NULL check shouldn't be necessary.
> for (i=0; i
hi to all.
thanks luiz and mike for response.
my code is compiled when i use -lmysqlclient option and executable file is now
exist but when i try to execute this file it prompts "Segmentation fault"
.what's the meaning of it and what i have to do?
##
gcc -o test -
e is as fillows:
***
#include
#include
#define host "localhost"
#define username "mysql"
#define password ""
#define database "test"
MYSQL *conn;
int main() {
conn = mysql_init(NULL);
my
/mysql/mysql/scripts/mysql_install_db --user=mysql
After that I started the mysql server: /opt/mysql/mysql/bin/mysqld -u mysql &
At this point I run the command "mysqlshow" in order the check the granted
databases: I can see both the "information_schema" and "test&q
Hi Jenny
Jenny Chen wrote:
> Hi,
>
> Recently, I built mysql5.0 on Solaris 10 amd64, but when running "make
> test", the bundled "sp" test failed
> with the following error:
>
> mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thr
Hi,
Recently, I built mysql5.0 on Solaris 10 amd64, but when running "make
test", the bundled "sp" test failed
with the following error:
mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun: 186944 bytes used of a 262144 byte stack
MySQL is shipped with a set of test cases and programs for running them.
These tools constitute the MySQL test framework that provides a means
for verifying that MySQL Server and its client programs operate
according to expectations. That's handy for anybody developing MySQL or
contributing
Well I tried removing -lmtmalloc from the LIBS line. Like before, I was
able to make but not make test. This time I just get a different error
after "test".
I could look into solving this error, but is this just treating the symptoms
though?
Ideas welcome,
TIA,
F
# /usr/local/bin
gt;
>> On 12/7/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
>> >
>> > Since I didn't get a response from the perl list, and since Daryn
>> > received
>> > some responses to his similar question I thought I might see if you guys
>> > had
ll of the referenced objects are loading fine
>
> On 12/7/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
> >
> > Since I didn't get a response from the perl list, and since Daryn
> > received
> > some responses to his similar question I thought I might s
Since I didn't get a response from the perl list, and since Daryn received
some responses to his similar question I thought I might see if you guys had
any ideas on why I can't make test for DBD::mysql on Solaris.
TIA,
F
-- Forwarded message --
From: Jake Peavy <[EM
>
> > | 1 |
> >
> > +-+
> >
> >
> >
> > mysql> select '91a1' regexp '^[1-9]*$';
> >
> > +--+
> >
> > | '91
"C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
>
> Hi everybody,
> I looked for a function to test whether a string is numeric (having
> characters 0..9 only). I found in the 5.0 manual Cast() and Convert(), but
> I don't think these do what I need. Any suggestio
;^[1-9]*$' |
>
> +--+
>
> |0 |
>
> +--+
>
>
>
>
>
>
>
> "C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
>
> >Hi everybody,
>
> >I l
+
"C.R.Vegelin" <[EMAIL PROTECTED]> wrote:
>Hi everybody,
>I looked for a function to test whether a string is numeric (having characters
>0..9 only).
>I found in the 5.0 manual Cast() and Convert(), but I don't think these do
>what I
Hi everybody,
I looked for a function to test whether a string is numeric (having characters
0..9 only).
I found in the 5.0 manual Cast() and Convert(), but I don't think these do what
I need.
Any suggestion what function to use ?
Thanks in advance, Cor
AIX server use 64 bits kernel and Enhanced
Journal File System (JFS2). It also have 1 GB of RAM and 35 GB Hard
Disk. I remembered that running this test is require to make sure MySQL
work properly and can handle the workload with the machine. So, I typed
the mysql-test-run command and here
ed
Journal File System (JFS2). It also have 1 GB of RAM and 35 GB Hard
Disk. I remembered that running this test is require to make sure MySQL
work properly and can handle the workload with the machine. So, I typed
the mysql-test-run command and here's what I got.
--
George,
is the utilization of both CPUs only 10 %? How big it is in the test with MS
SQL Server?
The workload is very much disk-bound if CPU usage is only 10 %.
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: ""yanghaifeng"" <[EMAIL
Heikki,
We thanks vary much for your response.
The CPU usage is avg 10% during the test.
We think if you need we will give you our test source code.
Best regards,
george
age during the test?
Regards,
Heikki
Oracle/Innobase
...
Dear Heikki,
we change the system's environment. now we use RAID0 disk to store the
InnoDB data file,and other disk to store log file.
follow is system's information:
CPU: 4X2.8GHz
RAM: 1G
Disk: 4X36G
the SHOW INNID
ueries in queue
6 read views open inside InnoDB
Main thread id 2268, state: sleeping
Number of rows inserted 170029, updated 319443, deleted 11947, read 12318619
257.92 inserts/s, 462.22 updates/s, 16.25 deletes/s, 16958.19 reads/s
END OF INNODB MONITOR OUTPUT
======
George,
can you please post a few typical
SHOW INNODB STATUS\G
outputs during the stress test.
Best regards,
Heikki
Oracle/Innobase
- Original Message -
From: "yang george" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 24, 2005 1:50
dear sir:
we develop a TPC-C test progrom,this program use mysql ODBC3.51 to
connect mysql server, and use microsoft sqlserver odbc to connect
sqlserver2000.
we suppose you are know well the TPC-C.
we use InnoDB as mysql's store engine.
follow is the os and hardware information:
Hi, joerg
Thanks for your patient answer!
I hope that we will have the ability to run the test suite on windows
system early.
Best regards
luming
_
与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL
Hi!
lu ming wrote:
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured [[...]]
I can just repeat:
This script is still under construction, and adaptions are still needed
to make tests work correctly on Windows platforms.
If you run it, you are on yo
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured as following output info:
" C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl
mysql-test-run: *** ERROR: Could not find
C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_t
Hi!
[EMAIL PROTECTED] wrote:
"lu ming" <[EMAIL PROTECTED]> wrote on 10/14/2005 12:20:19 AM:
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script
about
mysql server's test in the mysql-test
subdirectory(/mysql-test/m
"lu ming" <[EMAIL PROTECTED]> wrote on 10/14/2005 12:20:19 AM:
> Hi, joerg
>
> Thank you very much!
> But i want to know more about this problem. I find a perl script
about
> mysql server's test in the mysql-test
> subdirectory(/mysql-test/mysq
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written by perl what could replace the shell
script(/mysql-test/mysql
Hi !
lu ming wrote:
The test system that is included in MySQL Server's Unix source
distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to
run a test against to the MySQL Server. But these tests only can be run
on Unix(linux). If you want to run the tests on Windows
The test system that is included in MySQL Server's Unix source
distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run
a test against to the MySQL Server. But these tests only can be run on
Unix(linux). If you want to run the tests on Windows, you must use the
C
I run a test against to the MySQL Server with the test tool of the
binary distribution in Linux OS(red hat 9.0). But many of the test cases
failed. My test method and the output results are following:
1.batch test command
mysqltest -h localhost -u root -R r/alias.result test <
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
lu ming wrote:
>Who can tell me how to use the MySQL's test tool ("\MySQL\MySQL
> Server 5.0\bin\mysqltest.exe") ?I want to test the mysql server, and
> i find the te
Who can tell me how to use the MySQL's test tool ("\MySQL\MySQL Server
5.0\bin\mysqltest.exe") ?
I want to test the mysql server, and i find the test tool in the
directory "\MySQL\MySQL Server 5.0\bin\" (my os is Windows2000), but it can
not be executed directl
On Fri, 9 Sep 2005, Michael Stassen wrote:
With mysql 4.1.12, `make -n test` reveals
cd mysql-test; ./mysql-test-run && ./mysql-test-run --ps-protocol
For the record, here's what I got on Solaris 9 for 4.1.13
neelix hgs 18 %> cd mysql-test && ./mysql-test-run
Hi Hugh, all,
sorry about the delay.
Hugh Sasse wrote:
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
"The tool to run the test suite does not r
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
"The tool to run the test suite does not run as it should."
I understand that
eport what I've found so far.
Ok, thanks for this report, which is in plenty of detail, even if it
is "so far" :-)
The test suite is broken.
Who guards the guards? :-)
The archive test is meant to test the archive table engine, but the archive
engine is not built into mysql by
Hugh,
I get the same thing on Mac OS X 10.3.9. My thinking was that rather than
replying with an unhelpful "Me too", I would do some digging and then reply
with what I found. I realize now that left you hanging (sorry), so I'll
report what I've found so far.
The
I've see no reply to this and I checked the archives, so please
excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but
4.0.x?
Thank you,
Hugh
On Wed, 7 Sep 2005, Hugh Sasse wrote:
Attempts to do make test prior to installation, to check that I'm
insta
Attempts to do make test prior to installation, to check that I'm
installing something workable, give:
neelix hgs 63 %> gmake test
cd mysql-test; perl mysql-test-run.pl && perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Remo
com/doc/mysql/en/perl-support-problems.html
"Joeffrey Betita" <[EMAIL PROTECTED]> wrote:
> hello
> i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then
> try typing the command perl run-all-test
> when this is error message came up. below
hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then
try typing the command perl run-all-test
when this is error message came up. below is the error message.
install_driver(mysql) failed: Can't load
'/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-mult
Hello.
I'm not sure about 'myPHPadmin', but if it uses LOAD DATA INFILE
you should use \N in the data file, if you want to insert a NULL value
in the column. See:
http://dev.mysql.com/doc/mysql/en/problems-with-null.html
>where I would supply the number (would it start with 0 (zero)
Hello.
I'm creating my first database and would prefer populating the tables using a
text file I'll create in Notepad (not that it makes and difference). In case
it matters, I'm using myPHPadmin provided by my web hosting service.
I'm a little confused about the format of the data in the text
> password: NO)' when connecting to
> DBI:mysql:database=test;host=localhost with user: '' password: ''
> -
Sorry I didn't read the file README in the sql-bench directory before asking
the questi
I "cd /usr/local/mysql/sql-bench" and "perl run_all_tests", just to get the
following error:
-
Got error: 'Access denied for user 'root'@'localhost' (using password: NO)'
when connect
IGNORE: test only since I did not get my last posting.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Petr,
Thanks for the reply!
> I think you are looking for --extern option of the test suite. I
> corrected the README file. The changes should be propagated to the
> public repository soon, but you could check the commit mail for more
> details right now:
> http://lists.mysql.com/
Hello David,
I think you are looking for --extern option of the test suite. I
corrected the README file. The changes should be propagated to the
public repository soon, but you could check the commit mail for more
details right now:
http://lists.mysql.com/internals/26266
Petr
On Tue, 2005-06-21
According to the README, mysql-test-run supports an --external option:
db1 mysql-test # grep -a1 external README
If you want to run the test with a running MySQL server use the --external
option to mysql-test-run.
However it doesn't actually support it:
db1 mysql-test # ./mysql-tes
Just a test - thanks
<><><><><><><><><><><><><><><><><><><><><>
"There are no problems, only solutions."
Gabe Tucker
Bloomberg LP
(609) 750 6668 - P
(646) 268
Mikhail Berman
On Wed, 25 May 2005 11:09:06 -0700 (PDT)
Kathir Velu <[EMAIL PROTECTED]> wrote:
> "openssl_1" and "rpl_openssl" are skipped eventhough i
> have compiled with OpenSSL.
>
> So I have rerun these tests alone as,
>
> ./mysql-test-run --with-openssl o
/mysql
--enable-thread-safe-client
--with-named-thread-libs=/usr/lib/libpthread.1
--with-zlib-dir=/usr/local --with-vio
--with-openssl=/opt/openssl
Compiler used is gcc version 3.4.3 and OpenSSL
version is 09.07e.
When I tried to run the tests inside mysql-test
directory after the gmake
on one level, the test database is there just have something to log into
after intall to prove it's working.. some init.d startup scripts (I'm
thinking RedHat here) try to log into the database as an authenticated
user after each start up and when doing a 'status' call ju
Okay, so MySQL is now installed and running. It looks like a database
named "test" was created with no tables. Is this just used for
installation purposes? Can it now be deleted or is there a reason to
keep it? Or does it have some magical purpose like the "mysql"
data
After building, I ran "make test". The func_group test failed.
Here is the output:
func_group [ fail ]
Errors are (from
/mnt/raid/download/computer/software/mysql/mysql-5.0.2-alpha/mysql-test/var/log/mysqltest-time)
:
/mnt/raid/download/computer/software/mysql/m
t your users
> can know immediately if they have rights to edit the record or not.
That's an interesting way to do it, actually - it'll be abit of work but I
think its not bad at all. I was just curious about whether you could
"test" for a lock in InnoDB - it'd s
l), I think
you'll see what's wrong with your statement. If you fix that, I think your
table will be created correctly.
Rhino
- Original Message -
From: "Philipp Snizek" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, February 22, 2005 11:08 AM
Subject: RE: InnoDB Row Lock
Hi
I must be blind. Please help a DB-Newbie. What's wrong here:
create table users (
email varchar (80) unique not null,
ownerdomain int not null,
foreign key (ownerdomain) references domains on delete cascade
) type=innodb;
MySQL sais: ERROR 1005: Can't create table './postfix/users.frm'
Begumisa Gerald M <[EMAIL PROTECTED]> wrote on 02/22/2005 02:03:43 AM:
> Hi,
>
> I'm writing an application that uses InnoDB tables to provide
> transactional integrity. The front-end is a web-based interface.
>
> I'd like to know - is there a way one ca
1 - 100 of 421 matches
Mail list logo