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 can issue a query to test whether a
particular set of rows (or row) has already been locked by another session
- rather than
Our mail server has been stopping emails to the list.
This is a test message to see if it bounces again.
Please ignore (and accept my apology for generating noise).
David.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hey.
The code that I'm trying to get to work is as follows. The problem is
with the 7th, 8th, and 9th lines...
html
head
titleTest MySQL/title
body
!-- mysql_up.php --
?php
$host=;
$user=;
$password= ;
mysql_connect($host,$user,$password);
$sql=show status;
$result = mysql_query($sql);
if
Aaron,
You aren't trapping errors on mysql_connect().
Try this:
mysql_connect($host,$user,$password)
or die(mysql_error());
-Eric
On Mon, 6 Dec 2004 19:13:49 +0100, Aaron Ford [EMAIL PROTECTED] wrote:
Hey.
The code that I'm trying to get to work is as follows. The problem is
with
execute select
from 50.000 records. I have a test that retrieve page by page
(20 records per page) all data from a table. It means I'm executing
2500 selects in the cycle for retrieving each page and I'm retrieving
also time duration of some of this selects. When I retrieve records
that were inserted
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Juleni wrote:
Hello Brent,
Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS
within my SELECT query (and I also didn't use SELECT COUNT(*) ... query).
But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of
Hello Mark,
Thanks for your short response. I have checked it again. I have
restarted MySQL first. When I executed command
select SQL_CALC_FOUND_ROWS
BF_USER.LOGIN_NAME,
BF_USER.EMAIL,
BF_USER.ID,
BF_USER.MODIFICATION_DATE,
BF_USER.SUPER_USER,
BF_USER.GUEST_ACCESS_ENABLED,
Hello,
I have a problem with poor performance when I execute select
from 50.000 records. I have a test that retrieve page by page
(20 records per page) all data from a table. It means I'm executing
2500 selects in the cycle for retrieving each page and I'm retrieving
also time duration of some
have a problem with poor performance when I execute select
from 50.000 records. I have a test that retrieve page by page
(20 records per page) all data from a table. It means I'm executing
2500 selects in the cycle for retrieving each page and I'm retrieving
also time duration of some
I'm posting to test a new newsgroup client. Please post several replies.
Thanx,
Robb
Hope it works
John B
-Original Message-
From: Robb Kerr [mailto:[EMAIL PROTECTED]
Sent: 14 November 2004 17:35
To: [EMAIL PROTECTED]
Subject: Test post to test new client
I'm posting to test a new newsgroup client. Please post several replies.
Thanx,
Robb
--
MySQL General
Really hope it works
John B
-Original Message-
From: Robb Kerr [mailto:[EMAIL PROTECTED]
Sent: 14 November 2004 17:35
To: [EMAIL PROTECTED]
Subject: Test post to test new client
I'm posting to test a new newsgroup client. Please post several replies.
Thanx,
Robb
--
MySQL
Here's is your test reply.
Wishing you complete success...
Ken
Sugar Creek
- Original Message -
From: Robb Kerr [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:34 AM
Subject: Test post to test new client
I'm posting to test a new newsgroup client. Please
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote:
I'm posting to test a new newsgroup client. Please post several replies.
Does it work with mysql?
Just curious.
Jeff
--
===
Jabber: tradergt@(smelser.org|jabber.org
their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org
-Original Message-
From: Kenneth Wagner [mailto:[EMAIL PROTECTED]
Posted At: Sunday, November 14, 2004 2:28 PM
Posted To: mysql.general
Conversation: Test post to test new client
Subject: Re: Test post to test new client
Am a new member of the list.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Haitao Jiang [EMAIL PROTECTED] wrote:
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool that enable us sending a list of
queries over HTTP or JDBC repeatedly and gather/display the
statistics?
Honetsly, it's almost always better to write
Hi Haitao.
I'm in the process of developing one of these for the company I work for.
Feel Free to drop me a line and we'll see how we can get it going for you.
Regards
Ian
Haitao Jiang wrote:
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool that enable us sending a list of
queries over HTTP or JDBC repeatedly and gather/display the
statistics?
Thanks
HT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi all,
still building 4.1.3
I am now getting an error in make test like this:
ERROR: ... At line 136: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
---
*** r
On Tue, 2004-08-10 at 16:59, sean c peters wrote:
Hi all,
still building 4.1.3
I am now getting an error in make test like this:
ERROR: ... At line 136: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results
UPDATE:
I modified the grant_cache.result file to the expected output and got past the
test. It looked like the incorrect query was being issued, or in any case
that make test was doing something different than what the grant_Cache.result
file expected
On Tuesday 10 August 2004 15:59, sean c
Hi, I use BK to download a snap shot of mysql-4.1. On make test, it said failed at
ps_2myisam. What am I doing wrong?
I am using the BUILD/compile-pentinum-max script to build mysql. I change the setting
to disable openssl and berkeley-db and change prefix to /usr/local/mysql-cluster
Best
This is a follow-up to my original post from yesterday. I've narrowed down
the problem to the test-connect script.
C:\mysql\benchperl test-connect --user=root --password=tops3cr3t
Testing server 'MySQL 4.0.20a nt' at 2004-07-26 13:01:26
Testing the speed of connecting to the server and sending
Have done a fresh install of 4.0.20 and am getting some odd errors when
running as root when I peform the tests:
***
C:\mysql\benchperl run-all-tests --user=root --password=tops3cr3t
Benchmark DBD suite: 2.15
Date of test:2004-07-25 22:11:28
Running
Brad Waddell [EMAIL PROTECTED] wrote:
does anyone have a stress test for mysql? i want to give my box a
workout before deploying on the web. Maybe a PHP page which runs
forever, creating, finding and deleting thousands of records? Maybe I
can run it in several browsers at the same time
hi
does anyone have a stress test for mysql? i want to give my box a
workout before deploying on the web. Maybe a PHP page which runs
forever, creating, finding and deleting thousands of records? Maybe I
can run it in several browsers at the same time? thanks!
brad
--
MySQL General Mailing
super-smack: http://jeremy.zawodny.com/mysql/super-smack/
Or for stress testing the box itself checkout bonnie++ or
http://people.redhat.com/dledford/memtest.html which isn't a memtest
script but more
of a general i/o cpu test.
-Eric
On Sat, 17 Jul 2004 00:07:12 -0700, Brad Waddell [EMAIL
Jeff Smelser wrote:
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is my configure
command:
Whoa
Michael Stassen wrote:
I always run `make test` when I build from source. It can catch
problems. For example, mysql 4.0.17 built with gcc in Mac OS X 10.2
passed all tests and ran flawlessly for me. On the other hand, mysql
4.0.18 and 4.1.1 built on Mac OS X 10.3 seemed to build fine
Hello,
I'm trying to build the current source (fetched via bitkeeper) to have
access to ndb/clusters. I am building successfully but get errors with
'make test'. I have been cycling through this exersize for 4 days,
fetching the daily patches and getting a clean build every time (various
Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded
to). The compile runs smoothly, but make test fails. Here is my
configure command:
$ ./configure --prefix=/usr/local/mysql-4.0.20 --enable
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is my configure
command:
$ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-assembler
--enable
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here
Hi, once again!
\I tend to get on and off this list.
I have myCC and I was wondering what this means in my CREATE file.
) TYPE=MyISAM;
Could somebody please translate this into English?
I am interested in the UNIQUE property.
Would making my replies to survey subject to UNIQUE make thej less
Hi, once again!
\I tend to get on and off this list.
I have myCC and I was wondering what this means in my CREATE file.
) TYPE=MyISAM;
Could somebody please translate this into English?
Please read: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
I am interested in the UNIQUE property.
- Original Message -
From: Gloria L. McMillan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 11:16 AM
Subject: Test greeting question
Hi, once again!
\I tend to get on and off this list.
I have myCC and I was wondering what this means in my CREATE file
Testing the MySQL mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing another time the mailing list.
Regards,
Heikki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dan Brown [EMAIL PROTECTED] wrote:
Will the number of databases being handled by MySQL affect it's speed
regardless of the actual load being put on MySQL or should I look farther
into OS issues which could be causing system hangups and slowdowns?
Yes, investigate the OS.
The age
of the
I have three machines which I'm working with a specific database on.
One is a development server, the second a production server, and the third a
testing server for when code may cause the development server to crash
(which is the development server for numerous applications and sites so this
is
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I was running the test-select under the /usr/local/mysql/sql-bench dir and was
wondering if someone could help break it down for me ( Or at least the Testing big
selects on the table section ) Thanks :
[EMAIL PROTECTED] sql-bench]# perl test-select --password='d
'. The make appears to completes fine. When I run
'make test', I receive the following error:
[...]
Starting Tests
TEST RESULT
--
[... all passed or skipped up to this point]
count_distinct2[ pass ]
create
had no mysql list mail for a while
just testing please ignore
mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test disregard
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |[EMAIL
test
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
This is a test amil, please ignore
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA
Test Email - Please Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Successfully disregarded !
-Ursprüngliche Nachricht-
Von: Kevin Carpenter [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 15. März 2004 19:33
An: [EMAIL PROTECTED]
Betreff: Test Email - Please Disregard
Test Email - Please Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
Description:
After pulling the 4.1 version from
bk-internal.mysql.com:/home/bk/mysql-4.1,
I compiled with BUILD/compile-pentium-debug and startet tests with
make test. This failed with the gis test.
I try to follow the instructions given at the end
TEST EMAIL - Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Test Email - Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Test Email - Disregard
-:Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
then went to CPAN to get DBI, DBD::mysql, and CGI, but ran into many
problems, mostly with make test and make install.
Any advice would be truly appreciated. Should I not use CPAN?
Here's briefly the log (Note : I cancelled a previous cpan install
Bundle::CPAN with Ctrl-C, which probably caused
Warning: This message has had one or more attachments removed
Warning: (doc.zip).
Warning: Please read the VirusWarning.txt attachment(s) for more information.
test
This is a message from the MailScanner E-Mail Virus Protection Service
Our product, although written in .NET can be used to create anything, stored
procedures, data objects, business object that map database tables to
properties and so on. We support MySql, Microsoft SQL, DB2, Oracle and
Access. We are very interested in supporting the MySql community and plan
Title: Test!!!Please ignore this message
Hi fellows,
...just a test.Please ignore this message.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL
* Bob Ramsey [EMAIL PROTECTED] [2004-01-18 22:54 +0100]:
So how reflective of the real test is the sample test at mysql.com?
They've got sample questions for the core certification only. Their
level looks similar, but the real exam offers answers like none of the
above and all of the above
On Sun, 2004-01-18 at 20:51, Johannes Franken wrote:
* Marc Dver [EMAIL PROTECTED] [2004-01-18 18:30 +0100]:
1. What is the format of the test questions? I.e., are they multiple
choice, free answer, essay, etc.?
They are multiple-choice (but very tricky) and fill-in-the-gaps
Carsten Pedersen wrote:
I have heard from some candidates that they regard the Core exam as
being more of a memorization exam than Professional. Which only goes
to show, once again, that perceptions differ quite a bit as people come
out of the testing room.
Carsten,
Do you know when the
1. What is the format of the test questions? I.e., are they multiple
choice, free answer, essay, etc.? Are they theory based or is it fact
based, i.e., memorize the books to pass?
2. Upon the recommendation of someone on this list, I purchased two
books, one entitled, MySQL by Paul Dubois
In the Certification section of the mysql web site there is a short sample
test which shows the types of questions. There's a lot of information there
too including the broad topics covered in each test. According to
amazon.com Paul Dubois will have a MySQL Certification study book coming out
At 14:27 -0500 1/18/04, Jeremy March wrote:
In the Certification section of the mysql web site there is a short
sample test which shows the types of questions. There's a lot of
information there too including the broad topics covered in each
test. According to amazon.com Paul Dubois will have
* Marc Dver [EMAIL PROTECTED] [2004-01-18 18:30 +0100]:
1. What is the format of the test questions? I.e., are they multiple
choice, free answer, essay, etc.?
They are multiple-choice (but very tricky) and fill-in-the-gaps.
For example:
Assume a column in a MyISAM table has type VARCHAR
So how reflective of the real test is the sample test at mysql.com?
Normally the little sample tests are easier than the real thing, but I'm
curious. I got 8 out of 10.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
test
Karl James
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
When I enter this query select * from books, it gives me this error message: Error
1146: Table test.1 doesn't exist. What does that mean? This is MySQL 5.0 and I just
installed today. How can I solve this problem?
Thanks in advance.
Jacklty
Hi All,
Please pardon the test as I have received no messages from the list in a few
days
Allen
USE test;
DROP TABLE IF EXISTS relvar_a;
CREATE TABLE relvar_a
(
#PK
SSNCHAR(9) NOT NULL,
#FK
SUPERSSN CHAR(9),
DNOINT NOT NULL DEFAULT 1,
PRIMARY KEY (SSN),
INDEX (SUPERSSN),
INDEX (DNO)
)ENGINE = INNODB;
SHOW WARNINGS;
DESCRIBE relvar_a;
DROP TABLE IF EXISTS relvar_b
Hello,
please help me solve this problem,
ON DELETE SET DEFAULT should be supported,
==
USE test;
DROP TABLE IF EXISTS relvar_a;
CREATE TABLE relvar_a
(
#PK
SSNCHAR(9) NOT NULL,
#FK
SUPERSSN CHAR(9),
DNOINT NOT NULL DEFAULT 1,
PRIMARY KEY (SSN),
INDEX (SUPERSSN
This is 4.0.1.7 and it happens on both Solaris and Mandrake. This is
just after finishing a make. Should this work at this stage, even?
-Greg G
# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld
In previous installs, I've never been able to do it 'right'
but fresh install (4.1.1), new machine. So I'd like to set it up
so perl Makefile.PL on modules will install without having to pass special
parameters to build process.
First. mysql_install_db sets up the test db so
hi!
i have 2 machines.
both of them running mysql daemon.
i want to check the speed difference, and i am looking for a method how can i do this ?
is there an official tool for this thing ?
Vaso
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
test
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
test
Karl James
[EMAIL PROTECTED]
http://www.theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is a test e-mail for Karl. Please disregard it.
Thanks,
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
Thanx for both your replies, until recently I was doing the intelligent stuff outside
MySql ie in the Perl/PHP.
I'm learning to think database!!
Best Regards
David Rayner MSc CEng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello Serge,
Serge E. Yakubovich wrote:
Description:
First of all I want to thank you for your excelent bug report and apologize for
delayed responce.
The same test script I've submitted today to [EMAIL PROTECTED],
which demonstrates improper(?) behaviour of UPDATE statement on
4.0.12
Hi Y'All
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
zzapper
--
vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?
http://www.vim.org
On Monday 24 November 2003 03:25 pm, zzapper wrote:
Hi Y'All
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
SELECT DISTINCT txtName from tbl_addresses;
--
MySQL General Mailing List
On Nov 24, 2003, at 6:25 PM, zzapper wrote:
I need to test if any values in a column are the same (or are unique)
eg (my made up syntax Unique)
SELECT * from tbl_addresses WHERE txtName is UNIQUE;
How should this be done???
To get a list of all 'txtName' values that appear only once
that by itself to see what it returns. If the select gives
more rows you'll have to find some other way of inserting the data into
the test table.
The only way it should return only one row is if you have only one row
in the source data, if you have two rows it should be four lines
returned, and so
about 1500 records. I would like to create a test
table (i.e. users_test) with 10,000 records based on random data from the
first table (i.e. random first name combined with a random last name,
etc...). Is it possible to do this via a MySQL query?
Luis R. Lebron
Sigmatech, Inc
--
MySQL General
Thanks for the help. I tried your suggestion but only got 1 row inserted in
the test table.
Luis
-Original Message-
From: Olof Tjerngren [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 3:01 AM
To: Luis Lebron
Cc: Mysql (E-mail)
Subject: Re: Creating random data in a test table
I have an users table for a php application that I am programming. The
current users table has about 1500 records. I would like to create a test
table (i.e. users_test) with 10,000 records based on random data from the
first table (i.e. random first name combined with a random last name,
etc
Description:
The same test script I've submitted today to [EMAIL PROTECTED],
which demonstrates improper(?) behaviour of UPDATE statement on
4.0.12 server under FreeBSD, on 4.0.15 server under Alt Linux causes
segmentation fault.
Below is messages from /var/log/mysql/info
Sorry folks, just wondering about my email provider
-Jakob
--
To Unix or not to Unix. That is the question whether 'tis nobler in the
mind to suffer slings and arrows of vast documentation or to take arms
against a sea of buggy OS and by raping the support lines end then? ;
--
MySQL General
is it work?
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias - USP
Sao Paulo - Brasil
Tel/fax : 55-11-3091-7436
---
--
MySQL General Mailing List
For list
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
MASTER_RUNNING=1
I guess I could
On Thu, Sep 11, 2003 at 04:10:21PM -0400, Pierre-Luc Soucy wrote:
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
Hi,
I'm trying to compile MySQL 4.0.14 on a server which was previously
using RPMs, and although the ./configure (with no arguments) and make
steps went fine, make test does not want to work. The error I am getting
is :
/home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid
I downloaded version 5.0 on 30/08/03,
everything went fine until I did make test
it failed with an error in derived,
/root/mysql5.0/mysql-5.0/client/.libs/mysqltest: At line 97: Result content mismatch
see output and attached.
I then tried make test --force as suggested, but --force
sorry this is only a test.
query MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone know how or better still can point me in the right direction on testing a
newly install MySQL application server. We would like to run some tests to see what
needs tweaking if any.
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
At 12:20 +1000 7/23/03, Daniel Kasak wrote:
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
I'm currently testing it by doing:
if(abs(left(field,locate(' ', field))0),'Numeric bit at front', 'Not
Numeric bit at front')
It seems to work.
Well it kinda works. If 'field
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits followed by a space? If so, field REGEXP
101 - 200 of 407 matches
Mail list logo