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
: t...@stuxnet.org
To: mysql@lists.mysql.com
Subject: Re: missing data after partitioning an existing table
Hi there,
Le 23/05/2014 21:06, Roland RoLaNd a écrit :
[...]
Ouch
This post is somewhat ... unreadable !
Please format !
Christophe.
--
MySQL General Mailing
table
Hi there,
Le 23/05/2014 21:06, Roland RoLaNd a écrit :
[...]
Ouch
This post is somewhat ... unreadable !
Please format !
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
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:
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
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 RoLaNd:
Dear all,I
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