Re: stuck commits

2009-01-15 Thread Krishna Chandra Prajapati
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.

NDB Cluster Storage Engine 6.2 data types limit

2009-01-15 Thread Claudio Nanni
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

Re: Re: VC++ 2008 / MySQL debug / Unhandled exception

2009-01-15 Thread safknw
On Jan 14, 2009 9:40pm, Miguel Cardenas renit...@gmail.com 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

Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Daevid Vincent
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

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread John Daisley
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

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Daevid Vincent
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 surely

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Moon's Father
Yeah, you're right. On Fri, Jan 16, 2009 at 10:57 AM, Daevid Vincent dae...@daevid.com 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

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Jim Lyons
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

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Daniel Brown
On Thu, Jan 15, 2009 at 20:44, Daevid Vincent dae...@daevid.com 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:

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

2009-01-15 Thread Baron Schwartz
On Thu, Jan 15, 2009 at 9:57 PM, Daevid Vincent dae...@daevid.com 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