Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free sharedbuffers cached
Mem: 15899 15877
First, you might want to move the WHERE...t3.int_a =
condition into the join condition for t3.
Your not using anything from t4, so I'm not sure why you have that
table in your query.
You can suggest or force mysql to use an index if it's using the wrong
one:
http://dev.mysql.com/doc/refma
I agree with Jerry. Take a look at the UUID() function.
http://dev.mysql.com/doc/refman/5.1/en/miscellaneous-functions.html#function_uuid
Second Life (http://secondlife.com) uses UUIDs to track millions and millions
of unique items every day.
CheersFish
-Original Message-
>From: Je
Hi,
there is a table with several trees in nested set form in it.
CREATE TABLE IF NOT EXISTS `posts` (
`id` int(11) unsigned NOT NULL auto_increment,
`root_id` int(11) unsigned NOT NULL,
`lft` int(11) unsigned NOT NULL,
`rgt` int(11) unsigned NOT NULL,
`date` datetime NOT NULL,
PRIMAR
You should be able to do it with the select you already have,
something like this:
delete ACCOUNTACTION from ACCOUNTACTION join (
select ACCOUNTACTION.ID from ACCOUNTACTION
where ACCOUNTACTION.ACTIONDATE like '2008-08-01 02:00%'
group by ACCOUNTACTION.ACCOUNT_ID
having (count(ACCOUNTACTION.ACCOUNT
Why would the auto_increment not work for you? The only case where you
would have a problem is if the last record was deleted before mysql
shutdown. If you are really concerned about this unique scenario,
insert a dummy record before shutdown to guard against it and delete
the dummy record after yo
Hello all,
We've experienced a MySQL problem, during which few of the tables got
corrupted. Because of this, few of the websites contained "gibberish" and we
had to restore from backup.
This problem was caused by overloaded CPU and unwritten data to the hard disk.
We are looking for a me
>I try to generate a unique id for each row in a Mysql-InnoDB Table.
>Because of many deletes I can't use an auto_increment column.
>After a Mysql restart, the next value for an auto_increment-column is
>max(auto_increment-column)+1, and I need a really unique id.
>
[JS] See if the UUID() functio
I strongly advise you to use an off-the-shelf solution. In fact, if you can
afford it you should go with a CRM vendor. They will have all kinds of
features, such as address duplication detection, that you will need.
An open-source system would only be a good alternative if it is easily
extensible
Hi all,
I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of
many deletes I can’t use an auto_increment column.
After a Mysql restart, the next value for an auto_increment-column is
max(auto_increment-column)+1, and I need a really unique id.
My first solution looks
Jason Pruim schrieb:
On Aug 12, 2008, at 2:30 AM, robert rottermann wrote:
Hi there,
I am about to create tools to maintain addresses (companies, persons,
groups)
As this is probably done allredy a million times over I would like to
ask if somebody could point me from where I migth download
On Aug 12, 2008, at 2:30 AM, robert rottermann wrote:
Hi there,
I am about to create tools to maintain addresses (companies,
persons, groups)
As this is probably done allredy a million times over I would like
to ask if somebody could point me from where I migth download the
database struc
12 matches
Mail list logo
