Is there anyway to get mySQL to generate a warning or other info when
it ignores a row via LOAD DATA INFILE IGNORE? I'm happy having the
duplicates ignored but ideally would like to log which records were
dupes in a place I can find them again.
--
thanks,
>> First: select * from table1 order by field1 asc limit 1
>> Last: select * from table1 order by field1 desc limit 1
> That only returns one number.. what we are really looking for is something
And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE
of those queries is going to be
The mysql_install_db script shipped with 4.1.1-alpha seems to leave
the mysql/* (user,host,etc.) tables owned root.root on my Debian
system; this makes mysqld fail to start after the grant tables are
installed.
It looks like this is because mysql_install_db calls mysqld with
--bootstrap and *witho
> I don't believe this. I'm going to write a script to disprove this theory
> right now..
We have a lot more than 100,000,000 more than that in a single MyISAM
table at work:
mysql> select count(*) from probe_result;
+---+
| count(*) |
+---+
| 302045414 |
+---+
1 row in
> Select User_Account from Users as a, Devices as b
> WHERE
> a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices
>WHERE b.Device_Name LIKE 'HP%' )
> I'm running 3.23.49 which I know is not the most current..it was installed
3.x does not support
I've got an application that uses a fairly large (~50MM rows, ~1GB of
disk) table of read-only data. The table changes maybe once a month,
but when it changes, (almost) EVERY row in the table changes.
The app needs to be replicated into several datacenters worldwide
using relatively slow backend
