Rich Brant wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table of around 750k records, it
take
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table of around 750k records, it
takes in excess of 20 s
Toan. Dang Anh wrote:
Dear All,
I use this command [/usr/bin/ndb_mgm -e "START BACKUP WAIT COMPLETED"]
to backup mysql cluster. Backup is successful, when I restore my
database using [ndb_restore -m -b 3 -n 2] and [ndb_restore -r -b 3 -n
2], restore also is successful.
Hi Toan,
You need to
Dear All,
I use this command [/usr/bin/ndb_mgm -e "START BACKUP WAIT COMPLETED"]
to backup mysql cluster. Backup is successful, when I restore my
database using [ndb_restore -m -b 3 -n 2] and [ndb_restore -r -b 3 -n
2], restore also is successful.
But when I select or browse the tables have c
On 6/26/07, Brown, Charles <[EMAIL PROTECTED]> wrote:
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed.
Which version of MySQL are you running? I'm running 5.0.22 on my
desktop, but I'm fairly s
I am doing this to move data from one table to other and getting below
error.
How can check this particular record at this row number 921888 in dats_tem
table.
insert into reports1.dats1 select * from dats_tem;
ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for
column 'P_LAS
