Hi, all,
We have an innodb table named test. It has some rows as follow:
mysql> show create table test;
+---+-+
| Table | Create Table
> From: Dan Buettner [mailto:[EMAIL PROTECTED]
> This is a feature - a NULL value is an undefined value,
> therefore two NULL values are not the same. Can be a little
> confusing but makes sense when you think about it.
>
> A UNIQUE index does ensure that non-NULL values are unique;
> you co
Hi Kelly,
The short script of prefixing fields with tablename till 5.0 and beta is not
applicable.
Hope, this senario would be rare, that too many tables with larger field
length, more columns etc.
Thanks
ViSolve DB Team
- Original Message -
From: "Kelly Jones" <[EMAIL PROTECTED]>
T
Hi,
The following information is important to all MySQL Cluster 5.1 users,
and especially to those using MySQL Cluster Replication.
It was not included in the 5.1.14 release announcement, so I'm quoting
the relevant update to the 5.1.14 changelog (
http://dev.mysql.com/doc/refman/5.1/en/news
I just checked my latest dump attempt and it has now spent 128077
seconds trying to dump the 29GB table and making almost no progress (1
row every 30 seconds as estimated by strace). I guess the MVCC
implementation is pushed to its limits because I can see other queries
not finishing in a timel
Mathieu Bruneau wrote:
> I never experience any dump that were slow due to the index. The index
> aren't dumped anyway they will be recreate when you import them back so
> it shouldn't matter. (And that will cause problem if the db is running)
> so I wouldn't drop the index on your table if I were
Depending on the interface you're using, you can code an "on demand"
convert function. You can keep your server running with the
--old-passwords option till all your passwords are converted.
So, you keep the --old-passwords option, when a user login, you test
the password to see if its the new or
Hi
Thanks, this is easy and simple if I just have few users :) I have
more than 30,000 users :)
I think there is no way to do this so I have to use old-passwords
option in the new servers :)
Thanks
On 12/11/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote:
On 12/11/06, Ahmad Al-Twaijiry <[EMAIL
Hi !
I'm a beginner with mysql. I just installed the phpMyAdmin
2.9.1.1-Debian-1 / mysql 14.12 Distrib 5.0.30 for a soft (koha), but I
have an error when I try to install the base :
Creating the MySQL database for Koha...
0
ERROR 1064 (42000) at line 772: You have an error in your SQL syntax;
che
how do i find a log file of mysql
- Original Message -
From: "Nico Sabbi" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 11, 2006 8:37 PM
Subject: Re: MySQL 5.1.14 Beta has been released
Mads Martin Joergensen wrote:
Dear MySQL users,
We are proud to present to you the MySQL Serve
On 12/11/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote:
Hi everyone
I'm using mysqld with option "old-passwords" in my server (let's call
it serverA)
and in my application I use "UPDATE . SET
USERPWD=PASSWORD('ABCD')" to set the users password
now I want to move my database to another se
I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name fields, and 3
number fields.
Of course, I can/should do:
SELECT x.id AS x_id, x.name AS x_name, x.number AS x_number,
Mads Martin Joergensen wrote:
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.14 Beta
release, a new Beta version of the popular open source database.
Bear in mind that this is a beta release, and as any other pre-production
release, caution should be taken when installin
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.14 Beta
release, a new Beta version of the popular open source database.
Bear in mind that this is a beta release, and as any other pre-production
release, caution should be taken when installing on production level
systems or
> I have an InnoDB table similar to this:
>
> CREATE TABLE Target
> (IMSI VARCHAR(15) ASCII,
> IMEI VARCHAR(15) ASCII,
> UNIQUE KEY (IMSI, IMEI));
>
> After playing a bit with it, I managed to add duplicate records, if one of
> the fields was a NULL:
>
> +-+-+
> |
This is a feature - a NULL value is an undefined value, therefore two
NULL values are not the same. Can be a little confusing but makes
sense when you think about it.
A UNIQUE index does ensure that non-NULL values are unique; you could
specify that your column not accept NULL values.
Dan
On
It is expected behavior, you can make the unique key a primary key
instead. This should prevent this situation.
Ed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 11, 2006 7:42 AM
To: mysql@lists.mysql.com
Subject: UNIQUE KEY vs NULLs
Hi,
I
Hi everyone
I'm using mysqld with option "old-passwords" in my server (let's call
it serverA)
and in my application I use "UPDATE . SET
USERPWD=PASSWORD('ABCD')" to set the users password
now I want to move my database to another server (serverB) and the
mysqld in this new server doesn't ru
Hi,
I have an InnoDB table similar to this:
CREATE TABLE Target
(IMSI VARCHAR(15) ASCII,
IMEI VARCHAR(15) ASCII,
UNIQUE KEY (IMSI, IMEI));
After playing a bit with it, I managed to add duplicate records, if one of
the fields was a NULL:
+-+-+
| IMSI
I agree, you should just update it since the standard operation for
MYSQL is
to only apply updates if the value is changing.
http://dev.mysql.com/doc/refman/5.0/en/update.html
"If you set a column to the value it currently has,
MySQL notices this and does not update it."
Ed
-Original Messa
Dear MySql,
I am finding my version 5.1.6 and 4.1.9 sometimes locking up during the
passing of BLOB data. Size between 25 and 250 KB.
If I repeat the transaction it will pass.
Statistically it occurs about 1 in 30 INSERTs or UPDATEs or a blob.
Non-Blob data to the same table will never lock
I never experience any dump that were slow due to the index. The index
aren't dumped anyway they will be recreate when you import them back so
it shouldn't matter. (And that will cause problem if the db is running)
so I wouldn't drop the index on your table if I were you...
Your getting a lot of c
Try dropping the indexes first if you can, would save you about half the
time and then re-build them after the dump finishes. Obviously you
would need to do it at a quite time though when the DB is not being
used. Is a binary backup not an option? at 29G is a large text file to
write
Ade
D
Would like to know what is the archive "db.opt".
http://www.google.co.uk/search?q=mysql+db.opt&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hello !
I'm a beginner with mysql. I just installed the phpMyAdmin
2.9.1.1-Debian-1 / mysql 14.12 Distrib 5.0.30 for a soft (koha), but I
have an error when I try to install the base :
Creating the MySQL database for Koha...
0
ERROR 1064 (42000) at line 772: You have an error in your SQL synta
Thanks,
I have the previous ib_log* files on the app server. And every thing on the cnf
file was perfect. Only the ib_log file's size was a mismatch. Whats the best
work around?
Can I copy the log files of the App server to the DB server and change the
innodb_log_file_size to 256M and then res
26 matches
Mail list logo
