Hi Venu,
If you are having problem in running mysqldump, you can copy the data
directory and place it in another mysql servers data directory. The data dir
of the particular database is stored in the same name of the database. After
moving the data dir, restart the mysql dameon. Now you can
Em Sat, 11 Nov 2006 16:03:41 +0100, Yannick Landry ANTONIO escreveu:
Je viens au pres de vous solliciter une aide en ce qui concerne le
demarrage du serveur mysql.
Eſt-ce qu’il n’y a pas de liſte francophone ?
J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win
Hi all,
I have the following simple table:
CREATE TABLE data (
id int NOT NULL,
version int NOT NULL,
value int NOT NULL,
PRIMARY KEY (id, version)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
What I would like to do is to find all the values for the latest
versions, that is, for every id I
Curtis,
the reason why innodb.com was unreachable for some time on Friday was
that Oracle web administrators moved the DNS records to an Oracle domain
server. The registrar of innodb.com is Tucows, and I believe the admins
made some error which caused Tucows to set renewyourname.net as the
for every id I want exactly one row, namely the row with the maximum
value of version.
SELECT id,MAX(version) FROM data GROUP BY id;
PB
-
Sebastiaan van Erk wrote:
Hi all,
I have the following simple table:
CREATE TABLE data (
id int NOT NULL,
version int NOT NULL,
value int NOT
To get the value for each id's max version take the query
Peter just suggested and make it a subselect and join it
back to data like this:
select data.* from
(SELECT id,MAX(version) maxversion FROM data GROUP BY id) a,data b
where a.id=b.id and a.version=b.maxversion;
- Original Message
Hi everyone,
Everyday I got around 10 Deadlock errors in my database :
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when
trying to get lock; try restarting transaction
SQL=UPDATE Shop SET Total=Total-125 WHERE CustomerID=1697 AND OrderID=105
I'm using Innodb engine type for my
Hi,
Thanks for your quick answer, but unfortunately this query does not
return the value column of the row; and that is the column I am
ultimately interested in (in combination with the id).
Regards,
Sebastiaan
Peter Brawley wrote:
for every id I want exactly one row, namely the row with
You should play it safe and add $dblink-commit(); right after
$dblink-exec($sql);
The reason for this is from Page 419 of the
MySQL 5.0 Certification Study Guide bullet point #3:
During the course of a transaction, InnoDB may acquire row locks
AS IT DISCOVERS THEM TO BE NECESSARY.
I don't
Try this !!!
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: peter brawley [EMAIL PROTECTED]
Cc: Sebastiaan van Erk [EMAIL PROTECTED], mysql@lists.mysql.com
Sent: Monday, November 13, 2006 9:28:46 AM GMT-0500 US/Eastern
Subject: Re: How do I do this query efficiently?
To
Hi,
Thanks for the response! I thought I had tried this, but maybe my index
was wrong or my query was just different because when I tried it it was
really slow (also around 5 seconds). However this does the trick and it
is very fast (0.02 seconds). Thanks again!
Regards,
Sebastiaan
Rolando
Sorry
I have $dblink-commit(); right after $dblink-exec($sql); but I
forgot to write it here (my mistake, sorry )
also I want to mention that I have 3 primary key in my table:
ShopID
CustomerID
OrderID
Could this be the problem ?
On 11/13/06, Rolando Edwards [EMAIL PROTECTED] wrote:
You
Right, if you want the value column you need too, you need a different
query ...
SELECT t1.id, t1.version, t1.value
FROM data t1
LEFT JOIN data t2 ON t1.id=t2.id AND t1.version t2.version
WHERE t2.id IS NULL;
PB
Sebastiaan van Erk wrote:
Hi,
Thanks for your quick answer, but unfortunately
I have a client that is looking for a setup and was hoping that
somebody here could give me a quote for the job. I can't give ALL of
the details, but I am hoping that this will be enough to get a
quote. I am not looking for a hardware quote. Just one for setting
this up software wise.
20
It should not be a problem if you are updating only one row at a time.
If an UPDATE query is updating more tahn one row, then MySQL may try
to acquire all the row-level locks first.
For example, in the query you gave
UPDATE Shop SET Total=Total-125 WHERE CustomerID=1697 AND OrderID=105
How many
Pretty slick.
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Sebastiaan van Erk [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, November 13, 2006 10:43:26 AM GMT-0500 US/Eastern
Subject: Re: How do I do this query efficiently?
Right, if you want the value column
Wow, neat. I didn't think you could do that without a subquery somewhere.
Learned a cool new trick today. Thanks!
Regards,
Sebastiaan
Peter Brawley wrote:
Right, if you want the value column you need too, you need a different
query ...
SELECT t1.id, t1.version, t1.value
FROM data t1
LEFT
Hello everyone,
I have an opening for a senior DBA here in Ottawa, Ontario, Canada. I
measure senior not by years of experience but rather by overall abilities,
so please feel free to apply even if you don't have years years of
experience.
We will happily sponsor a work visa for an exceptional
Greetings:
I have a 600M data file that never gets backed up. The following error
occurs in the cron job:
tar: /data/mysql/my_db_name/my_large_table_name.MYI: file changed as we
read it
Is there a way I can set this one table to read-only prior to the backup
without affecting other db
Van wrote:
Greetings:
I have a 600M data file that never gets backed up. The following error
occurs in the cron job:
tar: /data/mysql/my_db_name/my_large_table_name.MYI: file changed as
we read it
Is there a way I can set this one table to read-only prior to the backup
without affecting
Van, I'll second what Gerald said about mysqlhotcopy.
When we first began using MySQL at my last job, we had terrible
problems with MySQL crashing. Turned out to be due to a 3rd party
backup process attempting to lock and read the database files while
MySQL was attempting to use them.
Using
I need some advice. We currently are in the process of starting to use LDAP
for our accounts to authenticate. Now when I create a new LDAP account I need
to assign a free gidnumber and uidnumber which can be to 1 to 999. My
plan is to load all gidnumbers and uidnumbers that are being
Would it be practical to leave the record in the table and mark it as
unused? That would certainly simplify the whole business.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From:
Kory -
It's always a little more challenging to find something that's NOT in the data!
I'd suggest two approaches:
1 - create a reference table containing all the possible values, 1 -
999. Then do a SELECT MIN and a join to find the lowest number
not in your data table, something like
I need some advice. We currently are in the process of starting to use
LDAP for our accounts to authenticate. Now when I create a new LDAP
account I need to assign a free gidnumber and uidnumber which can be to
1 to 999. My plan is to load all gidnumbers and uidnumbers that
are being used
Hi,
I enabled binlog for replication yesterday and i'm getting some problems:
-Yesterday, and all last days binlog was off, and i had an only one mysqld
process at top processlist.
-Today I'm getting several mysql processes, instead of a single one.
-I've got three hard disks, one drive for
I think the full-text index is an inverted index structure. So, it has
all the words from the fields it indexes. For each word it has a list of
record ID which have that word.
What I am interested to get is this inverted index structure. I imagine
it can be represented as 1-2 table(s). Can I
27 matches
Mail list logo