In the last episode (Aug 27), Osman Omar said:
below is my tables properties,
and my last record id is 127;
mysql desc emcs;
++-+--+-+++
| Field | Type| Null | Key | Default| Extra |
Hello
First bug: The contact address is no longer existing:
BUGs can be reported by email to [EMAIL PROTECTED]
Second bug: perl does not substitute the '~' char to the home directory:
--- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200
+++ /usr/bin/mysqlaccess
It's work
thanks
On Tue, 2002-08-27 at 14:24, Dan Nelson wrote:
In the last episode (Aug 27), Osman Omar said:
below is my tables properties,
and my last record id is 127;
mysql desc emcs;
++-+--+-+++
| Field |
Hi
I would like to have a SQL query to couple all the five tables to
accomplish my need.
This is a search page and the user will be searching using the don_id
Presently I am using a simple equi join which works fine if all the five
tables contain data for user_id
But if any of the tables have
You need a combo of cron jobs (man crontab) and use either mysqldump or
mysqlhotcopy.
cron:
* 3 * * * path_to_your_script
script
./mysqldump --opt -A path_to_output_sql_file -u username
this is just one of the many ways.
- Original Message -
From: Ilyas Keser [EMAIL PROTECTED]
To:
Hi all,
I would like to create an index to speed up the following query:
SELECT Account, Status, count(*) From MessageStatus WHERE sentDate
'(variable)' AND sentDate '(variable)' GROUP BY Account,Status ORDER BY
Account
sentDate is a timestamp(14), Account and Status are both varchars.
The
I compile the source code of mysql-3.23.51 on a system of solaris 8. The
following error information was produced:
make[2]: Entering directory `/user1/mals/chensong/share/mysql-3.23.51/libmysql'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_CURSES_H
Hi all,
I tried to use config. variable 'bind-address' for MySQL 4.0.2a
(mysqld-max-nt) to assign a particular ip for the server. However, I got
the following error:
E:\mysql4.0.2a\binmysqld-max-nt --help
Unknown suffix '.' used for variable 'bind-address' (value '192.168.0.176')
Hello,
I have a small(hopefully) sql-query problem.
I have 2 table like this:
Table member:
Id number,
Namevarchar,
Table member_points:
Id number
Member__id number (fk from member_table)
Round number
Points number
Now one example:
In table one is a
Hi all,
I've discovered that we have a select query that blocked all others query to
this table.
99% of query used indexs, no join ...
But this one is a problem :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR
select
m.Name,
mp1.Points as Round1,
mp2.Points as Round2,
mp3.Points as Round3,
mp4.Points as Round4,
mp5.Points as Round5
from
member m,
member_points mp1,
member_points mp2,
member_points mp3,
member_points mp4,
member_points mp5
where
m.Id = mp1.Member__id
and m.Id =
As first step, try to optimize table with help of
OPTIMIZE TABLE MyTable
command.
Any progress?
Best regards,
Mikhail.
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 12:34 PM
Subject: Slow select query, need some clues to
Michael,
Tuesday, August 27, 2002, 12:40:31 PM, you wrote:
MTI tried to use config. variable 'bind-address' for MySQL 4.0.2a
MT (mysqld-max-nt) to assign a particular ip for the server. However, I got
MT the following error:
MT E:\mysql4.0.2a\binmysqld-max-nt --help
MT Unknown suffix '.'
ME As first step, try to optimize table with help of
ME OPTIMIZE TABLE MyTable
ME command.
ME Any progress?
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
David
sql,query
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
And? No result?
Mikhail.
P.S. Can you send a copy to mysql-list, please.
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Sent:
Check the query plan
EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR
Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
Mikhail.
- Original Message -
From: David Bordas [EMAIL
DB Already done something like optimize :
DB myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
ME And? No result?
Some good result but nothing enough good :(
I'll have a look to fulltext search, perhaps i'll find something good.
I know that fulltext search only search for full word
Can I create an integer field which automaticly look after in two
tables to have the biggest id from this tables and increment this
maxid and store it?
thanks
ilyas
filter: mysql
-
Before posting, please check:
From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED]
KF an Index wouldnt help much , because of the 'LIKE %... '.
KF If a wildcart is at the beginning of the search-string , an Index
KF cannot help much.
Ok as i thought, index text field is a bad thing ...
KF You have to think about why are there
From: Andrew Izsof [EMAIL PROTECTED]
DB I know that '(Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR Field5
LIKE
DB '%John')' part is the problem.
AI The formula : '%John%' always sweeps through all of the records, because
it
AI can't utilize any indexes, sorting, etc. But if you leave the
* Mylin Campos
I'm a newbie with mysql. I have a few question and would really
appreciate it if you can help me. I'm creating a database for a
payroll system. I actually finish with my entity relationship
diagram. What should be the next step? I know I should create
the database already but
Hello,
sorry for a late answer, but here it comes.
On Tue, 27 Aug 2002, Mylin Campos wrote:
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram.
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME Check the query plan
ME EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
ME MyTable WHERE
ME Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
ME Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
| table
Pada Tue, 27 Aug 2002 12:34:32 +0200
David BORDAS [EMAIL PROTECTED] menulis :
Hi all,
I've discovered that we have a select query that blocked all others query to
this table.
99% of query used indexs, no join ...
But this one is a problem :
SELECT
I need to run the following query:
SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre,
WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1,
WRK_ImplDisp_1.DaAggregare, -1 AS Espr2
FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON
Hallo all
I am setting up replication.
Now I am sure my servers can connect but I still have a problem.
I setup my slave server to only replicate one table
The error I get is copy'd underneath here.
I am sure it is easey to solve I have just started thinking in loops now
Tnx
Mozzi
Can you send result of the query, please:
select * from MyTable PROCEDURE ANALYSE();
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 2:13 PM
Subject: Re: Slow select query,
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME Can you send result of the query, please:
ME select * from MyTable PROCEDURE ANALYSE();
Here you are :
mysql select * from MyTable PROCEDURE ANALYSE();
- Original Message -
From: Dicky Wahyu Purnomo [EMAIL PROTECTED]
DB SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
DB Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
DB Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
DWP have you
Hi,
I am using a query that returns around 13000 records from a mysql database.
The problem i am facing is, if i want to add any more columns in the query,
mysql does not return all the records. It returns only around 8000 records.
I somehow feel that it has something to do with the number of
IMHO the problem is in this condition
...Field5 LIKE '%John'...
Can you remove it from query and try again?
Mikhail.
- Original Message -
From: David Bordas [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 2:49 PM
Subject:
Hi,
i still have a little problem. When i do multiple connections to
my database over network (via mysql) then i get strange errors. I don't
know how to explain this so i'll give you an example.
(it is part of my real prog so it isn't probably the simplest one)
CREATE TABLE TR_TEMP
Your query overloads expendituredate.
Mysql now has to scqan the whole table to see if the new expenditure
date will
meet the where clause ( which it never will )
try DATE_FORMAT(expendituredate,%F=%b-%Y) as expdate
and see what happens.
kamesh jayachandran wrote:
Hi all,
I have a table
Mozzi schrieb:
Hallo all
I am setting up replication.
Now I am sure my servers can connect but I still have a problem.
I setup my slave server to only replicate one table
The error I get is copy'd underneath here.
I am sure it is easey to solve I have just started thinking in loops now
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME IMHO the problem is in this condition
ME ...Field5 LIKE '%John'...
ME Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%',
but Field5 LIKE '%John' and Field5 LIKE '%John%' don't change query
speed at all except about
Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,%d-%b-%Y) as expdate,sum(amount) as
amount from expenditure where userid=11 and expendituredate between
'2002-8-01' and '2002-8-31' group by expendituredate order by
expendituredate;
which is not overriding the
As I understand...
After removing Field5 LIKE '%John' condition the query works much faster.
But it is different query... :)
I mean that queries return different results.
On other hand you can't change type of Field5 because you have a row with
51723 symbols in Filed5. :(
So...
question: Do you
Can I also use a select statement in a create statement. Something like this:
create table mytable
(
id int not null primary key (select max(id) from mytable2),
name varchar(255)
);
is this possible or is there an other way to do something like this?
ilyas
filter: mysql
Hi,
I have a database which a few tables which have a few fields set with
auto_increment and i'm having alot of trouble restoring the backup because
the backup recreates the table with the auto_increment field, but when it
tries to enter the data back into the table it cant because it is trying
Can I also use a select statement in a create statement. Something like this:
create table mytable
(
id int not null primary key (select max(id) from mytable2),
name varchar(255)
);
is this possible or is there an other way to do something like this?
ilyas
filter:
Hi,
try this:
create table mytable select max(id),space(1) name from mytable2
and then this:
alter table mytable modify name varchar(255)
Danilo Maurizio
-Messaggio originale-
Da: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Inviato: martedì 27 agosto 2002 15.56
A: [EMAIL PROTECTED]
From: Mikhail Entaltsev [EMAIL PROTECTED]
As I understand...
After removing Field5 LIKE '%John' condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
But it is different query... :)
I mean that queries return different results.
Yep ...
On other
Brad,
Tuesday, August 27, 2002, 7:59:19 AM, you wrote:
BB is this tee or \T command supposed to still work in mysql 4.x?
[skip]
BB should work similarly. but this is what happens:
BB mysql tee /tmp/log.txt
BB No outfile specified!
BB the --tee=filename argument to the mysql client works
Andrew,
Tuesday, August 27, 2002, 4:21:29 AM, you wrote:
Stuart Low wrote:
Have had continuing issues with trying to actually get LOAD LOCAL INFILE
commands working
At 11:45 26/08/02 +0300, Victoria Reznichenko wrote:
Did you specified local-infile=1 for client, too?
AM Hi,
AM I'm a
Mylin,
Tuesday, August 27, 2002, 8:17:13 AM, you wrote:
MC I'm a newbie with mysql. I have a few question and would really appreciate
MC it if you can help me. I'm creating a database for a payroll system. I
MC actually finish with my entity relationship diagram. What should be the
MC next
Ilyas,
Tuesday, August 27, 2002, 4:55:45 PM, you wrote:
IK Can I also use a select statement in a create statement. Something like this:
IK create table mytable
IK (
IK id int not null primary key (select max(id) from mytable2),
IK name varchar(255)
IK );
Nope.
IK is this
Ilyas,
Tuesday, August 27, 2002, 2:45:12 PM, you wrote:
IK Can I create an integer field which automaticly look after in two
IK tables to have the biggest id from this tables and increment this
IK maxid and store it?
Nope.
--
For technical support contracts, goto
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the getGeneratedKeys() method.
Thanks.
Mike
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
The server that has the mysql DB, has a control panel adding and
removing new mysql databases and mysql users all of the time. Is there
any possible way to have one global grant table for all of the users
coming from 192.168.1.%? I believe I attempted this a while ago, but I
used an INSERT
As I understand...
After removing Field5 LIKE '%John' condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
:( That's strange. You removed condition (which can only _increase_ number
of records in resultset)
and query works much slower...
May be
Hi:
If my MySQL server updates a table, does the ability exist to inform a
client or clients (observers) that a table has changed. I do not want to
replicate the data, I just want to know the name or names of the tables that
have been updated.
Thank you
Phil Willemann
Which Operating Systems limit MySQL to a 2GB table size?
-
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
When will MySQL 4.0 be released as a stable version?
-
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
ME In this case...
ME Can you try again?
Sure.
query 1 :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR Field5 LIKE
'% John%' ) ORDER BY Field6 LIMIT 0,20;
query 2:
SELECT
Ben
It would appear that the deletion of rows may be a problem.
After deleting rows older than 6 months, do you optimize the
table?
As I understand it, mysql does not delete delete, only marks
a bit for every row thats deleted. That way, delete speed is
fast. However, it slows down queries and
Try to remove two 'LIKE' conditions.
query 3:
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
Field7=15 AND Field2=0 AND Field3 LIKE '%John%'
ORDER BY Field6 LIMIT 0,20;
What do you have now???
Mikhail.
- Original Message -
From: David Bordas [EMAIL
Try MySQL Connector-J 3.0.0 (dev). You can download it from mysql.com.
Regards,
Michael
-Original Message-
From: Mike Duffy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:41 AM
To: [EMAIL PROTECTED]
Subject: JDBC 3.0 Driver
Does anyone know if there is a good JDBC 3.0
Hi Victoria,
May I ask when 4.0.3 will be released?
In addition, I found 4.0.x contains the max sqld as well. Are there any
different between the 4.0.x and 4.0.x-MAX version?
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the getGeneratedKeys() method.
The mm.mysql driver has been taken over (with it's author), renamed (but
not the author) to Connector/J, and enhanced to 3.0 level. It is still Beta
at the moment, but supports
Mike Duffy wrote:
Does anyone know if there is a good JDBC 3.0 Driver for MySQL?
I would like to use the getGeneratedKeys() method.
Thanks.
Mike
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
On Mon, 26 Aug 2002, Donald J Miller wrote:
Hello everyone,
I am trying to create a mysql table to hold either the entire contents
of text or WordPerfect files. I've read about BLOB or TEXT type columns
so I've tried creating a table such as:
CREATE TABLE filetest(fileid int(5) not
On Tue, Aug 27, 2002 at 09:17:46AM -0600, Scott Pippin wrote:
When will MySQL 4.0 be released as a stable version?
Where there have been no reported bugs for a sufficient amount of
time.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
I would like to know if it is possible to configure mysql auo increment
feild to start from a specific number or configure it to have a specific
character such as a letter inserted infront of it.
Thanks
I have no respect for reality as soon as it is acknowledged as such. I am
interested
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
Dear Sir/Madam,
In dos-prompt, I type at c:\mysql\binmysql for testing to see if mysql is
connected successful but
the error is : Error 2003: Can't connect to MySQL server on 'localhost'
10061
How to solve this problem?
Hope to hear from you soon.
Thank you.
Regards
Ellen
On Tue, 27 Aug 2002, Will K. wrote:
hello,
Please dont tell me to RTFM on this one (cause I am already doing that), but
for clarity's sake... can someone tell me what it means when you use NULL
and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I
use them?
Will,
I would like to know if it is possible to configure mysql auto increment
field to start at a specific number or to configure the auto increment field
with a character such as a letter inserted infont of it(eg. r1, r2..)
Thanks
F belfon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tuesday 27 August 2002 17:17, Scott Pippin wrote:
When will MySQL 4.0 be released as a stable version?
As soon as it actually *is* stable :)
On a more serious note, we are currently working on preparing the first
release of 4.0 (4.0.3)
Hi
I have a table that returns the following error message as soon as I run
a query that reads out more then 300 posts from the table
ERROR 1030: Got error -1 from table handler
The strange part is that the table works without any problem except when I
try to select more then 300 posts. I have
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
According to the book I'm working from right now, you can't do this directly. What it
suggests is that you insert the first row in your table manually and insert the
integer that you want to start at. AUTO_INCREMENT will then use this number as its
starting point and continue upwards.
I
Scott Pippin wrote:
Which Operating Systems limit MySQL to a 2GB table size?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Thomas Spahni wrote:
On Mon, 26 Aug 2002, Donald J Miller wrote:
Hello everyone,
I am trying to create a mysql table to hold either the entire contents
of text or WordPerfect files. I've read about BLOB or TEXT type columns
so I've tried creating a table such as:
CREATE TABLE
Frederick,
ALTER TABLE will do the biz:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
I would like to know if it is possible to configure mysql auto increment
field to start at a specific number or to configure the auto increment
field
with a character such as a letter inserted
Hello,
If you're using MyISAM tables, shut down your server and run myisamchk
For example, myisamchk \mysql\data\dbname\*.MYI
See the MySQL Technical Reference for detailed syntax and usage
information. However, it seems like your table is corrupted, indeed.
Regards,
Iikka
On Tue, 27 Aug 2002
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
As soon as it actually *is* stable :)
On a more serious note, we are currently working on preparing the first
release of 4.0 (4.0.3) that will be declared Beta instead of Alpha.
The
The search function for our ecommerce site has worked great up until the
other day, but now when a search is ran the whole system just hangs. Here
is what I have found:
A process is started (search.cgi) that stays open until all of the memory is
used up (sometimes two same-named processes).
Elias,
ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
I would like to know if it is possible to configure mysql auo increment
feild to start from a specific number or configure it to have a specific
character such as a letter inserted infront of it.
On Tue, 27 Aug 2002, Scott Pippin wrote:
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
Hello,
There are basically two things you should consider:
1) Switch to InnoDB tables and create several data files just under
In the last episode (Aug 27), Chad Arimura said:
The search function for our ecommerce site has worked great up until
the other day, but now when a search is ran the whole system just
hangs. Here is what I have found:
A process is started (search.cgi) that stays open until all of the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 20:05, Scott Pippin wrote:
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
You could either use MERGE tables:
Dean Ellis wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote:
As soon as it actually *is* stable :)
On a more serious note, we are currently working on preparing the first
release of 4.0 (4.0.3) that will be declared Beta
Hi,
My opinion:
Personally, i'm not agree with this model of data in a table...but it's
your choice.
Anyway, i think you can try this :
select field1,field2,field3,field4,field5,field6,field7 from YOUR_TABLE
WHERE field2=0 AND field7=15 AND (CASE WHEN field3 like 'john' THEN field3
like 'john'
I'm building a job database with simple invoicing. I have one table called
JOBS and one called INVOICES. In INVOICES there's a foreign key column
called job_id referencing INVOICES to JOBS.job_id.
in a simplified way it looks like this:
(there are a lot of other columns of course)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql,query ...
On Tuesday 27 August 2002 02:30 pm, walt wrote:
There has been some issues with gcc 3.x if I remember correctly. I know
RedHat released another beta because of problems with gcc 3.x. Have you
tried it on a box with gcc 2.9x ?
your date strings are incorrect.
As a string it should be '2002-08-01'
but it can also be treated as a numeric.
try:
and expendituredate between 20020801 and 20020831
kamesh jayachandran wrote:
Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,%d-%b-%Y) as
use the -f option to ignore the duplicates.
Chris Barnes wrote:
Hi,
I have a database which a few tables which have a few fields set with
auto_increment and i'm having alot of trouble restoring the backup because
the backup recreates the table with the auto_increment field, but when it
tries to
Does anyone have any idea when Mysql 4 will be classed as stable.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hi,
I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
deadlocks since upgrading from .51. When I do a show innodb status in
prints out the following:
020826 19:22:15 LATEST DETECTED DEADLOCK:
*** (1) TRANSACTION:
TRANSACTION 0 16655549, ACTIVE 1 sec, OS thread id 87339022
Matt Darcy wrote:
Does anyone have any idea when Mysql 4 will be classed as stable.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Sounds fair.
I have played with it a bit and found it good.
Just hoping it was be found stable soon as I am keen to use it in
production.
I'll get back to some testing.
Thanks,
Matt
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: 27 August 2002 22:15
To:
I'm trying to put together some statistics on our queries and am wondering
what percentage of our queries involve a full table scan. The variable
which kind of tracks this is Handler_read_rnd_next. However, since a
query may cause multiple Handler_read_rnd_next events to occur to get all
of
When will 4.0.x finally be released to beta?
The facts as I understand them:
- 4.0 went alpha in Nov or Dec of '01
- At the time, Monty and his gang projected stabilization by Jan or Feb
- More than 6 months have passed since and the product is not yet stabilized
- No meaningful information has
On Tue, Aug 27, 2002 at 05:45:07PM -0400, Will French wrote:
When will 4.0.x finally be released to beta?
The facts as I understand them:
- 4.0 went alpha in Nov or Dec of '01
- At the time, Monty and his gang projected stabilization by Jan or Feb
- More than 6 months have passed since and
The confusing thing is, I run the query across the EXACT same code on a
different database (old copy of same database), and it works just fine. Are
there any ways to peak into what mysql is doing besides mysqladmin
showprocesses?
Thanks,
Chad
-Original Message-
From: Dan Nelson
Hi there,
I have a big table which has 25 rows.And each row has a BLOB field
which stores lots of text. When I search text in this table(using the query:
where CONTENT like '%news%'),the searching speed is quite slow. is there
anybody also have such problem? Any ideas about improving the
In the last episode (Aug 27), Chad Arimura said:
The confusing thing is, I run the query across the EXACT same code on
a different database (old copy of same database), and it works just
fine. Are there any ways to peak into what mysql is doing besides
mysqladmin showprocesses?
If the
Joe,
- Original Message -
From: Joe Shear [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 28, 2002 12:15 AM
Subject: Innodb deadlock printouts in .52
Hi,
I'm running mysql 3.23.52 w/ innodb tables, and I started getting some
deadlocks since upgrading
Hi Will,
As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta
as we speak and is likely to be released in the next month. V4.1 will most likely be
released Early Sept in Src form and in Binaries two months later.
4.0.x branch will be allowed to stabalise from
1 - 100 of 118 matches
Mail list logo
