On Thu, Jan 15, 2009 at 9:57 PM, Daevid Vincent wrote:
> you misunderstand me. I have three servers (dev, test, prod) that all
> have maybe 3 databases EACH that have all these eventum* tables in them.
> don't ask. a simple "trickle" won't do. I'm writing a script to loop
> through them all.
mk-f
On Thu, Jan 15, 2009 at 20:44, Daevid Vincent wrote:
> I've been tasked with cleaning up a bunch of 'eventum' tables that got
> accidentally dumped into several databases and then replicated.
>
> I'm wondering if I can just go through with a simple command to blow
> these all away:
>
> find /var/
By the subject line, it would these are all MyISAM tables. If true, then
deleting the files should do the trick. If any of them happens to be an
InnoDB table, it won't work and you'll have to do some gyrations to get them
dropped. It'll be a mess.
Since you're accessing all the databases any wa
Yeah, you're right.
On Fri, Jan 16, 2009 at 10:57 AM, Daevid Vincent wrote:
> you misunderstand me. I have three servers (dev, test, prod) that all
> have maybe 3 databases EACH that have all these eventum* tables in them.
> don't ask. a simple "trickle" won't do. I'm writing a script to loop
>
you misunderstand me. I have three servers (dev, test, prod) that all
have maybe 3 databases EACH that have all these eventum* tables in them.
don't ask. a simple "trickle" won't do. I'm writing a script to loop
through them all.
On Fri, 2009-01-16 at 01:57 +, John Daisley wrote:
> Well sure
Well surely its a simple case of drop the tables on the master and let
replication do the rest!
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate (CMA)
Comptia A+
I've been tasked with cleaning up a bunch of 'eventum' tables that got
accidentally dumped into several databases and then replicated.
I'm wondering if I can just go through with a simple command to blow
these all away:
find /var/lib/mysql/ -name eventum*
Or is there some other magic that a "DR
On Jan 14, 2009 9:40pm, Miguel Cardenas wrote:
Hi
I'm using /MT (LIBCMT.lib?) and it is multi-threaded since all my
multi-thread code is working. LIBCMTD.lib is ignored because it is
indicated
in a post at MySQL forums "
http://forums.mysql.com/read.php?45,49606,49606#msg-49606"; and a
All,
I can't find the following informations on the MySQL Docs to see if there
are limits on data types using NDB6.2:
[1] What is the maximum length for one record of a NDB 6.2 storage engine
table? (65k like MyISAM?)
[2] Is it possible to use TEXT and BLOB fields without any problem?
Thanks
C
Hi Scott,
The configuration shows that you are using default mysql configuration with
very few enhancement. The enhancement must depends on the size of physical
memory available.
innodb_buffer_pool_size268M
It should be between 50% to 70% of your ram.
innodb_additional_mem_pool_s
10 matches
Mail list logo
