Any hint where and how to get mysql 4.1.1?
Thanks
John
-Original Message-
From: Jon Haugsand [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 3:14 AM
To: '[EMAIL PROTECTED]'
Subject: Re: utf8 support
* John Li
MySql 4.1 should have utf8 charset support, I downloaded the alpha
Hello,
I am relatively new to MySql (4.0.14) but I have read through the relevent
documentation and am still confused about how row level locking behaves
with InnoDB tables.
I created a database with a single innodb table which has 2 columns, one
of which is indexed. The locking behavior I see
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
Hello, mysql,
Yesterday,mysql process disappear sliently.
After I check the err-log,no clues found.
But the PID file still exising.I think the mysql terminate by some reason.But
I still not found why.
The error-log mysqld.log wouldn't provide any valueable msg.It
All,
I have a query that is inner joined with another table based on country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('list of countries here');
The problem is when I have more than 2 country codes, the query takes forever...
When
* Twibell, Cory L
I have a query that is inner joined with another table based on
country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('list of countries here');
The problem is when I have more than 2 country codes, the query
Hi Jesse,
- Original Message -
From: Jesse Sheidlower
Sent: Monday, August 25, 2003 8:26 AM
Subject: Explanation of multiple-column indexes
After some discussion in a separate thread, I've been trying
to get a better understanding of the workings of multiple-column
indexes, and think
Description:
I've recently compiled mysql 4.0.14 on redhat 8.0.
The installation fails, however, when running mysql_install_db.
I've attached a transcript below.
I gather from searching the 'net that this isn't an entirely
unusual thing to happen, and is likely the result of some
Indexing columns will help but you *may* need to take a peek at some other
factors such as Memory Management
Read Jeremy's article on MySQL Performance Tuning
http://www.linux-mag.com/2001-12/mysql_01.html
Hth,
Martin
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL
Ahh, so Linux on 64-bit right now with INNODB is really not much different
than on 32-bit x86? XEON CPUs have AWE/PAE which lets them address a 36-bit
memory address space, getting past the 4GB addressable limit. 64-bit CPUs
obviously can address _much_ more memory in a single chunk. MySQL/INNODB
On Tue, 26 Aug 2003, Heikki Tuuri wrote:
Asif,
now take the old log files from the safe place and put them back! That will
save your data.
The instructions about changing the size of the log files are the following:
http://www.innodb.com/ibman.html#Adding_and_removing
If you want to
Andi,
- Original Message -
From: Andi Kleen [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 1:37 AM
Subject: Re: 64-Bit and INNODB
Heikki Tuuri [EMAIL PROTECTED] writes:
Adding the 32-bit Intel AWE support into InnoDB on Linux would be
rather
nobody have answer ?
For me it is very urgent to kwow when the .15 version will be avalaible .
Tks
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: I.P. [EMAIL PROTECTED]
Sent: Friday, August 22, 2003 1:16 PM
Subject: Re: Replication Problem
On Tue, Aug 26, 2003 at 07:38:04PM -0600, Twibell, Cory L wrote:
All,
I have a query that is inner joined with another table based on
country codes Select distinct Name.* from Name inner join Location
on Location.key = Name.key and Location.cc in ('list of countries
here');
The problem
Wendell,
- Original Message -
From: Wendell Dingus [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 27, 2003 6:35 AM
Subject: RE: 64-Bit and INNODB
Ahh, so Linux on 64-bit right now with INNODB is really not much different
than on 32-bit x86? XEON CPUs
On Tue, 26 Aug 2003 17:00:16 -0400
Nicola Hartland [EMAIL PROTECTED] wrote:
When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
On the Mysqladmin it tells me that my odbc driver 3,.51 not found is that a problem
and how do I get the driver?
you
User can use SHOW GRANTS command:
Thank you!
But one more question: what privileges user should have to issue this command? I've
got a user who has rights only to SELECT from certain db. What should i GRANT to him
to allow use of SHOW GRANTS?
--
MySQL General Mailing List
For list archives:
Hi,
When compiling MySQL with statically linking options (with glibc 2.3.1),
There weren't any errors during configure and compilation stages but
mysql_install_db was giving out a segmentation fault.
The list archives had suggested to give up statically linking libraries,
which worked fine.
Hi,
I've read the replication section in the manual but i'm not quite sure about
the possibilities of the replication in mysql:
It's possible a server could act as master for one database with slave
server A and as a slave for another database which runs on master server B?
If yes: as far as
Matthias Blaser wrote:
It's possible a server could act as master for one database with slave
server A and as a slave for another database which runs on master
server B?
As in A - database1 - S - database2- B
AFAIK anything S logs will be red by B. Using 'replicate-do-db=database2' B
will
On Wednesday 27 August 2003 10:50, Hans van Harten wrote:
Matthias Blaser wrote:
It's possible a server could act as master for one database with slave
server A and as a slave for another database which runs on master
server B?
As in A - database1 - S - database2- B
Well, it should
Hi
I have problems with mysql (4.0.6-4.0.14b) on windows 2000 SP3. MySQL
locks tables when I alter table structure or execute update queries. I
know that this is the exactly what database engine is supposed to do but
the engine doesn't release the locks at all. This happens frequently but
not
Thanks for writing to [EMAIL PROTECTED] This is
an auto-generated response to let you know that your
message has reached our general information box
on 8/23/2003 at 5:38:55 AM.
Customer Service will be processing and, if necessary,
responding to your inquiry shortly. We usually reply
to general
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I asked a question along these lines yesterday, but got no response. Perhaps I
can make it clearer:
I have a ucs2 table in my predominantly latin1 database. (Mysql 4.1.1 from bk)
I am using latin1 most of the time, it's the default charset,
from what I can see from the subject and this message alone, someone on
this list has been infected by the sobig.f virus, could everyone just
please check their computers... that is if you are running any windows
machine, not you that are running linux or any other os...
thanks in advance...
Thompson, Jordan [EMAIL PROTECTED] wrote:
I wan to use a variable for the outfile file name in a select into clause. I am
doing something like:
set @fileName=/tmp/result.text
SELECT col1, col2 INTO OUTFILE @fileName
FIELDS TERMINATED BY ','
FROM test_table;
the interpreter dies at the
gord barq [EMAIL PROTECTED] wrote:
I'm using MySQL 4.1 so how do I define case sensitive collation? Is it on
the columns or on the indexes?
On column. Look at the collations of your character set using SHOW COLLATION command:
http://www.mysql.com/doc/en/Charset-SHOW-COLLATION.html
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Thanks.
Fernando Bernardino
Steve,
- Original Message -
From: Steve McWilliams [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 27, 2003 12:07 AM
Subject: Question about row level locking with InnoDB tables
Hello,
I am relatively new to MySql (4.0.14) but I have read through the
[EMAIL PROTECTED] wrote:
User can use SHOW GRANTS command:
Thank you!
But one more question: what privileges user should have to issue this command? I've
got a user who has rights only to SELECT from certain db. What should i GRANT to him
to allow use of SHOW GRANTS?
Every user can see
On Wed, 27 Aug 2003 09:05:17 -0300
bernardaum [EMAIL PROTECTED] wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Hi all,
I'm upgrading a mission critical production server with Solaris 9 and mysql
4.0.13 and was wonder if I should install as 64 bit or 32 bit.
I couldn't find much recent discourse on the subject, perhaps some of you
have some experience, known pit falls, ideas or suggestions
Quick log question...
We've got our 3.23 db installed with all the data on the /home partition
which is ok. The *-bin.00x logs are also in that data directory. The
Var/log/mysql/mysql.log however on our root drive has grown to 11gig.
Our Root partion is not as large as our Home partition and I
Hi All,
The link below says that online backup functionality will be provided
in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is
Mysql going to extend the functionality of mysqlhotcopy so that it works
for Innodb tables also? or they are going to provide independent online
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
When I need to do
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up a 12 GB mail
database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send
the expensive bottles of alcohol for
On Wed, 27 Aug 2003 13:27:25 +0100
Simon [EMAIL PROTECTED] wrote:
On Wednesday 27 August 2003 1:05 pm, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
On the Mysqladmin it tells me that my odbc driver 3,.51 not
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I restart this sequence? Start from 0 again?
Why bother? MySQL doesn't care if there
These are tables that I did not design (and would not have in this fashion), but I
have to make do with them
Table 1 structure:
id_num number,
descr1 varchar(30),
descr2 varchar(30),
descr3 varchr(30)
Table 2 structure
id_name varchar(15),
ext_descr varchar(30)
Table 2 is a child of table 1
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not clean, its follows the
sequence.
Can I
On Wed, 27 Aug 2003 09:33:38 -0400
Nicola Hartland [EMAIL PROTECTED] wrote:
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
hmm..
you will have to excuse my ignorance what Is a mysql_*;function as I said I
At 17:56 +0400 8/27/03, Antony Dovgal wrote:
On Wed, 27 Aug 2003 09:38:16 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
At 9:05 -0300 8/27/03, bernardaum wrote:
Hi,
I have a table with an auto_increment field. When I
delete all the record and insert a new one the
auto_increment field is not
On 26 Aug 2003 at 19:38, Twibell, Cory L wrote:
I have a query that is inner joined with another table based on
country codes Select distinct Name.* from Name inner join Location on
Location.key = Name.key and Location.cc in ('list of countries
here');
From the message you're getting it
On Tue, Aug 26, 2003 at 09:26:55PM -0500, Matt W wrote:
Hi Jesse,
- Original Message -
From: Jesse Sheidlower
What I'm trying to understand is how you would set up these
indexes when you'd always be doing joins with another table.
Suppose you have The Canonical CD Database, and
If the backup solutions are there already, why is that a future
requirement for Mysql?
Thanks,
Srinivasulu.
Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up a 12 GB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 27 August 2003 12:05 pm, I wrote:
How do I escape UCS2 characters in a latin1 SQL statement?
Okay, so the answer's in the manual. I just didn't look hard enough...
http://www.mysql.com/doc/en/Charset-literal.html
So I do:
'INSERT
On Wed, 27 Aug 2003 10:04:02 -0400
Paul DuBois [EMAIL PROTECTED] wrote:
Second reason still applies.
yes, but I suppose he knows what he's trying to do =)
If it's still something deemed desireable:
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
yes, this is another one possible solution, but I
Dear Mysql Users,
Could you tell me what should I do to get local (polish) daynames from the following
function:
SELECT DAYNAME(1998-02-05);
thanks,
regards,
Lukasz
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
Hi Jeremy Zawodny (and all)
I am using your mytop and this is what I am seeing
MySQL on localhost (4.0.13-standard-log)
up 0+10:48:22 [11:14:37]
Queries: 85.6k qps:2 Slow: 207.0 Se/In/Up/De(%):86/05/05/02
qps now:2 Slow qps: 0.0 Threads: 11 ( 2/ 4)
Jeff McKeon [EMAIL PROTECTED] wrote:
We've got our 3.23 db installed with all the data on the /home partition
which is ok. The *-bin.00x logs are also in that data directory. The
Var/log/mysql/mysql.log however on our root drive has grown to 11gig.
Our Root partion is not as large as our
All, the tables are defined as MyISAM. In fact, I left last night and
the Query was still running the convert HEAP to MyISAM Somethings
definately wrong.
I have indices on Name.key, Location.key and Location.cc
the results of the explain :
id| select_type| table | type | possible keys|
Li, John [EMAIL PROTECTED] wrote:
Any hint where and how to get mysql 4.1.1?
Official binaries will be available in September at:
http://www.mysql.com/downloads/index.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates to be committed can
be tricky. At best, this means performance problems. Please don't
Hello MySQL Team,
I'm working currently on the project where we need
to make a decision what engine would be our main
production database engine.
Could you please help me and shed a light on what
pros and cons MySQL vs Ingres: features, performance,
support, portability among Wintel and Unix
Hi All,
my $0.0.2... anybody correct me please if you know it better...;-)
2003 8 27 23:22P Srinivasulu :
If the backup solutions are there already, why is that a future
requirement for Mysql?
Thanks,
Srinivasulu.
Chris Nolan [EMAIL PROTECTED] 8/27/2003 6:41:27 PM
Hi!
You can
Hi Chris,
2003 8 28 00:54Chris Nolan :
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates to be committed can
be tricky. At
Hi Chris,
2003 8 28 00:54Chris Nolan :
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates to be committed can
be tricky. At best,
2003 8 28 01:43Nils Valentin :
Hi Chris,
2003 8 28 00:54Chris Nolan :
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates
Sorry for reposting , wrong subject in the prebious one
-- Forwarded message --
Date: Wed, 27 Aug 2003 11:17:36 -0400 (EDT)
From: Asif Iqbal [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Replication with multiple servers in Mysql ?
Hi Jeremy Zawodny (and all)
I am using
The advantage of other methods is that you avoid all sorts of nasty
locking on various parts of your database. The advantage of
the Hot Copy
product that Innobase Oy sell is that it doesn't place any
locks on your
InnoDB table space when it runs.
Wouldn't that break the ACID ? The
Hi list:
I have the following partial result from an explain select:
| table| type | possible_keys
| key
Scott Haneda wrote:
Anyone else get one of these for every post to this list?
Return-Path: [EMAIL PROTECTED]
That offender have now been removed from the list and prevented from
re-subscribing.
Best Wishes
Thomas
--
MySQL General Mailing List
For list archives:
We've got our 3.23 db installed with all the data on the /home
partition which is ok. The *-bin.00x logs are also in that data
directory. The Var/log/mysql/mysql.log however on our root
drive has
grown to 11gig. Our Root partion is not as large as our
Home partition
and I
Hello,
Could someone recommend a decent php script that could be used for
database[MySQL]::Web interfacing and management. Preferably open source,
freeware or otherwise [I'll just have to grin bare it]
Thanks
-- Joe --
--
MySQL General Mailing List
For list archives:
Carl B. Constantine [EMAIL PROTECTED] wrote:
* Victoria Reznichenko ([EMAIL PROTECTED]) wrote:
It means that user doesn't have ALTER privilege.
BUT, I've tried granting the user all privs in mysqlcc and it still
doesn't work. Looking at my other setup, the users look like they are
set up
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1, which returns set Result1. Inside this loop,
I run an UPDATE query which
Hi!
A hot backup (= online backup) means backing up your database without
locking anything for more than a few milliseconds.
If you back up a massive, fast changing, database with
mysqldump --single-transaction, then -- at least in some theoretical
settings -- InnoDB can run out of space in the
Hey,
I have a question about copying a database that was developed on a windows os and
moving it to a Linux server os. Will this work ? Has it been done before ?
Thanks,
-Dan
Yes it will work, and it has been done before.
Copy the *.MY* files and the *.frm files to the linux server.
---Original Message-
--From: Dan J. Rychlik [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, August 27, 2003 11:31 AM
--To: [EMAIL PROTECTED]
--Subject: database from win to lin
--
Thanks so much for the reply...
- Original Message -
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Dan J. Rychlik' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 2:11 PM
Subject: RE: database from win to lin
Yes it will work, and it has been done before.
Dan,
Dan J. Rychlik said:
Hey,
I have a question about copying a database that was developed on a windows
os and moving it to a Linux server os. Will this work ? Has it been
done before ?
Thanks,
-Dan
Yes, I have done it just recently.
Just use the mysqldump-command.
--
Once a
Hi!
First: thanks for ideas - I'm adding them to my todo :)
About dates - it's very difficult to say when a particular feature will
be implemented. Anyway, first I'm going to finish with this 2-level
index structure - to implement optimizations that rely on it.
Any speed/optimization
I'm testing my application using MySQL 4.1.0. Before I was using 4.0.14
version. Today I've looked into error file of the 4.1.0 where there was
hundreds of new lines with information like this:
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 3686351459 page number
Marek,
do not worry:
http://www.innodb.com/ibman.html#InnoDB_history
MySQL/InnoDB-4.0.14, July 21, 2003:
...
* Fixed the checksum calculation of data pages. Previously most OS file
system corruption went unnoticed. Note that if you downgrade from version =
4.0.14 to an earlier version 4.0.14
76 matches
Mail list logo