From: "Martin"
> For my tests I used the blob field (not varchar or anything else), but
> compared to your tests, I didn't use MySQL 5.0.6 (as it's still a beta)
but
> I used MySQL 4.1. Maybe that's part of the problem, although I'm not sure.
FWIW: I tested it on 4.0.23-standard, with the same re
Short-answer: use "IN" instead of "="
Long-answer:
Your query is kind of weird. I think you want to use "IN":
SELECT memberid, fullname FROM members WHERE memberid IN (select
distinct memberid FROM familymembers)
The equals implies an exact match between the top-level, and the
sub-query, b
i get an error when i run the query below though SQLyog.
SELECT memberid,fullname FROM members WHERE memberid =
(select distinct memberid FROM familymembers)
the error is
Error Code : 1064
You have an error in your SQL syntax. Check the manual that corresponds to your
MyS
> So we have recently started stress testing Mysql on an Opteron dual
CPU
> machine running Ubuntu Hoary. We are using the 64-bit GCC
> 4.0.24-standard binary from mysql. The stress test that I'm currently
> running on it involves inserting a large database (from a mysqldump)
> ...
Which l
I install the last version of mysql and got this
$mysqlhotcopy test
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
What happened ?
Best regards,
Miguel
---
E-mail: [EMAIL PROTECTED]
.
ADVERTENCIA: La informacion contenida en
Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in
my.cnf: socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is
removed.
does your system errors when starting mysqld?
He
You need to run the script that creates MySql tables (user, hosts, ...)
mysql_install_db in scripts dir.
Santino
At 15:20 -0400 16-06-2005, Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option
in my.cnf: socket="/tmp/m
"Peter Normann" <[EMAIL PROTECTED]> wrote on 06/16/2005 02:15:34 PM:
> Sorry guys,
> I just learned that ctrl-return would send the email you are composing,
so I
> got cut off short, so let me try again :-/
> It appears to be usual practice from what I can see in this list to use
a
> primary k
On Thu, 16 Jun 2005, Spenser wrote:
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
same old...
/usr/local/mysql/bin/mysqld_safe --user=mysql
--datadir=/usr/local/mysql/tmp &
cat ../
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
On Thu, 2005-06-16 at 15:20 -0400, Paul Mitchell wrote:
>
> ./mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp
--
MySQL General Ma
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in my.cnf:
socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed.
does your system errors when starting mysqld?
Hello Danny,
Thanks for t
We never dump the data just shutdown the slave, copy the data
directory and restart the slave. This practice is trustworthy
probably only where the servers are running on the same platform, mysql
server version and operating system.
-Kieran
___
hi,
there will not be a lot of paying backup tools if just copying files is OK.
You can't because active transactions change some files checkpoint, then you
copied files are not at the same checkpoint state, and you can't use the copy
for a restore.
The only way is to lock all the tables if you wa
The ALTER TABLE is going to "copy" the entire table when it executes the
ALTER TABLE so it will take some time. Depends on your server, diaks,
table type etc..
One alternative might be to do a
SELECT a, enumcolumn INTO OUTFILE 'x' FROM tablename;
TRUNCATE tablename;
ALTER TABLE tablename CHAN
At 03:09 AM 6/16/05, Cory Robin wrote:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my
hum... clever. i liked that solution.
but do have experience on how long it will take with milions of records?
all records havin only a int(11) as unique key and the enum field..
suposing now i have enum("a", "b") only, and did a "ALTER TABLE
tablename CHANGE columnname columnname ENUM('a','b','c
Sorry guys,
I just learned that ctrl-return would send the email you are composing, so I
got cut off short, so let me try again :-/
It appears to be usual practice from what I can see in this list to use a
primary key that actually contain somewhat meaningful data.
I have always used primary ke
Hi everybody,
It appears to be usual practice from what I can see in this list to use a
primary key that actually contain somewhat meaningful data.
I have always used primary keys solely for one purpose only: To identify a
table row uniquely, using autoincremental integers. Actually, if I were to
If you have "c" values in the table currently you can just do an
ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b','c','x')
DEFAULT "a" NOT NULL
then
UPDATE tablename SET columname = 'x' WHERE columname = 'c'
Then
ALTER TABLE tablename CHANGE columnname columnname ENUM('a','b',
With all this discussion going on about the best way to backup MySQL
data, I have a question: Is there anything wrong with simply copying
the db files when you're backing up, as opposed to doing a full shutdown
of the server (regardless of whether it's a master or slave) and then
doing a
If you use InnoDB then the InnoDB Hot-backup tool works very well. It's not
free, but its inexpensive and if you are in an environment where you need to do
large fast hot backups you will probably find it well worthwhile.
We normally do backups as follows:
Production Server A <-> Production
A very nice way to do 'virtually' live MySQL database backups is to replicate
to a dedicated or semi-dedicated 'backup' server. That server will have the
current data in it at all times. Then you can backup that server at will,
either by doing an on-line dump, or even shutting the server down
If i have a table with about 800M records. and one of the fields is a
enum("a", "b", "c") and i want to change it to enum("a","b","x") will
it fall into some optimization and be instant?
and what if previously i've never used the "c" value? isn't there any
optimization for that? ...leaving "blank
Yes, that's the way we currently do it but we were looking for more
options.
Jeff
> -Original Message-
> From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 16, 2005 11:26 AM
> To: Jeff McKeon
> Cc: mysql@lists.mysql.com
> Subject: Re: Backing up live MySQL Databases
>
Le Thursday 16 June 2005 17:06, Jeff McKeon("Jeff McKeon"
<[EMAIL PROTECTED]>) disait:
Hello,
> Anyone using any third party products like Arkeia that enable you
> to do a live backup of MySQL database?
I've tried Arkeia few months ago. The online backup and restore of
MySql databases worked
Hi!
InnoDB is the MySQL table type that supports foreign key constraints,
transactions, two-phase commit in XA, row-level locking, non-locking
consistent read (MVCC), all four SQL-1992 isolation levels of transactions,
multiple tablespaces, asynchronous unbuffered disk I/O on Windows, and a
n
Hendro,
In SQL an empty string is not null.
PB
Hendro Suryawan wrote:
Hi all,
I have table with primary key on field PO,BrgId, NOSP but when i try
insert several new reccord with field NOSP = '', mysql will accept the
new reccord without complaint error.
Is this normal behavior? My perception
James M. Gonzalez wrote:
-Original Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: 15 June 2005 21:09
To: James M. Gonzalez
Subject: Re: help joining tables in a query
James M. Gonzalez wrote:
Greetings,
I'm facing a difficult query at the moment. I have tried many
d
Hendro Suryawan <[EMAIL PROTECTED]> wrote on 06/16/2005 06:53:31 PM:
> Hi all,
> I have table with primary key on field PO,BrgId, NOSP but when i try
> insert several new reccord with field NOSP = '', mysql will accept the
> new reccord without complaint error.
> Is this normal behavior?
As long
Hi,
Thanks for your reply,
For my tests I used the blob field (not varchar or anything else), but
compared to your tests, I didn't use MySQL 5.0.6 (as it's still a beta) but
I used MySQL 4.1. Maybe that's part of the problem, although I'm not sure.
So it's really quite strange, but so far I solv
Hello.
It is a fresh, brand new :) bug:
http://bugs.mysql.com/bug.php?id=11297
Elton Hughes wrote:
> Hello All,
>
> I am trying to install MySQL 4.1.12 on my Powermac G4. My OS is 10.4.1.
> I downloaded the binary distribution from the MySQL website. I
> uncompressed it an
So we have recently started stress testing Mysql on an Opteron dual CPU
machine running Ubuntu Hoary. We are using the 64-bit GCC
4.0.24-standard binary from mysql. The stress test that I'm currently
running on it involves inserting a large database (from a mysqldump)
from three separate
(forwarded to the list - I am not the OP)
- Forwarded by Shawn Green/Unimin on 06/16/2005 11:45 AM -
James Black <[EMAIL PROTECTED]> wrote on 06/16/2005 11:44:36 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] wrote on 06/16/2005 11:
[EMAIL PROTECTED] wrote on 16/06/2005 16:29:46:
>
>
> [EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
>
> > Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
>
> > > I need to speed up a search, big time.
> > >
> > > I have an application that searches for records on a date field
And exactly what you expect "nothing" to look like? If "nothing" (no rows)
is the correct response to your query, how would you like it formatted?
Without knowing exactly how you are executing this query, it's impossible
to know how to tell you how to detect an empty result set (assuming you
a
[snip]
I have a little question. I have two tables which are used for saving
private messages. If a user has NO messages, the result doesn't return
_anything_. I expected to get "0 results" but this really confuses me.
[/snip]
If there is no data you should get an 'Empty set (0.00)' message or
s
You got exactly what the db found. An "Empty Set". You wouldn't get '0'
results because there aren't '0', it's EMPTY. It's not NULL either since
NULL is a form of non-existence.
Why were you expecting '0'?
J.R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
[EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
> Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> > I need to speed up a search, big time.
> >
> > I have an application that searches for records on a date field. If
it
> > doesn't find an exact date match, it keeps searching ad
Hi everyone!
I have a little question. I have two tables which are used for saving
private messages. If a user has NO messages, the result doesn't return
_anything_. I expected to get "0 results" but this really confuses me.
Query:
SELECT upn.id, upn.fid, upn.tid, upn.subject, upn.message, up
Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> I need to speed up a search, big time.
>
> I have an application that searches for records on a date field. If it
> doesn't find an exact date match, it keeps searching adjacent days until
it
> finds a certain amount of records.
>
Hello.
> Also, while testing I experienced that inputting something like more
> the 255 characters with AES_Encrypt, the AES_Decrypt function doesn't
> give
> back more then 255 characters. Is this correct, or am I doing something
> wrong here?
AES_ENCRYPT wo
I have a master-slave replication setup. A scheduled backup script on
the slave runs automatically at regular intervals.
The script slave does this:
shutdown the mysql server on the slave
backup the mysql data directory to backup media
restart the mysql server on the slave.
Using a setup like t
Hallo
I have some problems loading data from Master. I am using the circular
replication procedure for example a->b->c->a. Since I ran out of disk in
my main server, my other servers started reporting duplicate entries
later.
I thought going it from scratch to take the complete data from the
M
Hi all,
I have table with primary key on field PO,BrgId, NOSP but when i try
insert several new reccord with field NOSP = '', mysql will accept the
new reccord without complaint error.
Is this normal behavior? My perception if i have primary key on the
three field the three field must be not empty
Anyone using any third party products like Arkeia that enable you to do
a live backup of MySQL database?
I'm searching for a backup solution for our new data center and would
like to here what other people are using for MySQL.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my application to loop through and run
multip
"nicolas ghosn" <[EMAIL PROTECTED]> wrote on 06/15/2005 03:14:39
AM:
> Dear mysql supports,
> I want to change the font color for database mysql , for example I want
to
> insert data with red color
> when I select this data the font color is the default black.It's
possible to
> change the font
You have also 3000 * 7 millions columns to left joins to x,y,.. others tables.
And you use myisam. this will certainly be a big update problem.
I suggest you to transform your query into :
1. select using the left joins to see first the number of rows to be updated
2. according to this number th
48 matches
Mail list logo
