May2015 VALUES LESS THAN
> (TO_DAYS('2015-06-01')), PARTITION Jun2015 VALUES LESS THAN
> (TO_DAYS('2015-07-01')), PARTITION Jul2015 VALUES LESS THAN
> (TO_DAYS('2015-08-01')), PARTITION Aug2015 VALUES LESS THAN
> (TO_DAYS('2015-09-01&#
SERT INTO p3_dna_new SELECT * FROM p3_dna_old;
It finishes after a while, with absolutely no error nor warning.
if i issue the following:
select count(*) from p3_dna_new;
it will be different than the result of
select count(*) from p3_dna_old;
If there's an issue, shouldn'
I know a couple of things, but table partitioning isn't one of them. i have a
35 GB sized table which is causing performance issues, my research came across
partitioning, which is what i tried and failed with today. i tried altering the
table, that kept going for 2 hours with absolutely no chang
Dear all,
I realize this is a very newbie question so bear with me please.
I know that when you import/export a DB its tables are locked to ensure
consistency and no data corruption.
but why would other DBs on the same server get locked if im importing/exporting
one DB ?
in other words:
expo
Is it safe to kill a mysqldump while it's in process ?
i mean aside loosing the dumped file, would it affect the running DB
being dumped?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
i agree it wouldn't cause trouble, though it might lock mysql as there's
a number of other databases running on the same server.
so performance is an issue even if it's just a CPU/RAM peak.
On 5/31/12 11:23 AM, Reindl Harald wrote:
Am 31.05.2012 09:13, schrieb Roland RoLa
Dear all,I have a task to anonymize data in 82000 record (for the time
being)i've tested my script against about 30 of them, and it takes about 2.4
sec for each query to be executed.
i'm seeking help with the following:
- what's the best way to run such a script without affecting the DB server
