Re: Dropping ALL indexes from a database / not just a table?

2010-08-09 Thread Anirudh Sundar
e echo "completed disabling indexes for database -- $db" done Cheers, Anirudh Sundar On Tue, Aug 10, 2010 at 1:33 AM, Nunzio Daveri wrote: > Hello Gurus, is there a way / script that will let me DROP ALL the indexes > in a > single database? for example, lets say my database i

Re: info on mysql

2010-08-09 Thread Anirudh Sundar
N_SCHEMA.TABLES t ON s.schema_name = t.table_schema WHERE s.schema_name not in("mysql","information_schema","test") GROUP BY s.schema_name,t.engine order by Data_size DESC; For top slow queries :- mysqldumpslow -s c -a -t 5 mysqlslow.log > top10_slow-coun

Re: migration via replication for large DB?

2010-07-26 Thread Anirudh Sundar
. Please let me know how it goes if you decide to do it this way. Cheers, Anirudh Sundar On Mon, Jul 26, 2010 at 9:56 AM, Rob Wultsch wrote: > On Sun, Jul 25, 2010 at 12:55 PM, Geoff Galitz wrote: > > > > Hello. > > > > I need to migrate a master and slave to n

Re: Why is MySQL always linked to PHP?

2010-07-22 Thread Anirudh Sundar
Now ur shouting ;) ;) ;) i was not. haha U can say anything an escape with it without being brushed.go an take poetry...where u can anything with any other thing...hehehe Cheers, Anirudh Sundar On Fri, Jul 23, 2010 at 10:53 AM, Jan Steinman wrote: > > On 22 Jul 10, at 21:01, A

Re: Why is MySQL always linked to PHP?

2010-07-22 Thread Anirudh Sundar
SUFFICIENT PROGRAMMING LANGUAGE. Anirudh Sundar. On Thu, Jul 22, 2010 at 6:08 PM, Jay Blanchard wrote: > [snip] > Jay, > > PHP is a WEB based Server Side scripting Language. > > Do not compare it with C. C is a middle -level System programming > language. > > Please stop c

Re: Why is MySQL always linked to PHP?

2010-07-22 Thread Anirudh Sundar
Jay, PHP is a WEB based Server Side scripting Language. Do not compare it with C. C is a middle -level System programming language. Please stop comparing. On Sat, Jul 17, 2010 at 10:03 PM, Jan Steinman wrote: > From: "Jay Blanchard" >> >> >> You always have to use the right tool for the job

Re: How can I see the query from a remote session against my server

2010-06-09 Thread Anirudh Sundar
t.log Cheers, Anirudh Sundar DataVail Corp Mumbai On Wed, Jun 9, 2010 at 6:52 PM, Michael Dykman wrote: > You have 2 options here. The Mysql General Query Log > > http://dev.mysql.com/doc/refman/5.1/en/query-log.html > > Alternatively, if it's windows ( I ask because of the

Re: Strange behavior by MySQL Stored Procedure

2010-05-28 Thread Anirudh Sundar
few records from the query executed. Cheers, Anirudh Sundar 9594506474 DataVail Mumbai. On Fri, May 28, 2010 at 5:44 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Dear All, > > I have one stored procedure Which inserts data into one table. > > But sometim

Re: How to put table definition into another table using SQL?

2010-05-11 Thread Anirudh Sundar
Hey Mike, I do not see a possibity of a quick response for this We need to work on a query (if at all it is possible to be done in a query). Will get back soon on this. Cheers, Anirudh Sundar On Tue, May 11, 2010 at 9:36 PM, mos wrote: > At 10:53 AM 5/11/2010, Anirudh Sundar wr

Re: How to put table definition into another table using SQL?

2010-05-11 Thread Anirudh Sundar
Hi Mike, Did you try this :- Create table TableDef select * from TableX where 1 = 2; If you give this statement you will create the new table "TableDef" with the same variables and datatypes as table "TableX" Let me know if it works.... Cheers, Anirudh Sundar On Tue, May

Re: log-slow-queries

2010-05-07 Thread Anirudh Sundar
ed in the log. mysql> set global log_output = FILE; [if you find log_output as TABLE or NONE] Let me know if you have any issues... Cheers, Anirudh Sundar On Fri, May 7, 2010 at 10:34 PM, Stephen Sunderlin < stephen.sunder...@verizon.net> wrote: > Can't get slow querys to log.

Re: Where to index - over 15m records and growing

2010-05-07 Thread Anirudh Sundar
the IVAOData table. It will help updating the index statictics and defragmenting the table (the table will respond better to queries). try these can get back with your observations. Cheers, Anirudh Sundar On Fri, May 7, 2010 at 12:51 PM, Chris Knipe wrote: > My appologies for leaving that bit o

Re: Where to index - over 15m records and growing

2010-05-07 Thread Anirudh Sundar
Hey Chris, Please send the explain plan for this query, the estimated table sizes (in MB or GB) and the RAM capacity. These are also the requisites for helping optimizing your query if required... Thanks. Anirudh Sundar On Fri, May 7, 2010 at 12:14 PM, Chris Knipe wrote: > Hi All, &g