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 d
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 syst
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
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 this
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:
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 us
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 mys
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 affect
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
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
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 JOIN
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 col
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
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
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
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
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
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
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 li
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 wit
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
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 -
>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
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
do
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
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-wi
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 se
27 matches
Mail list logo