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
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
.
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
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
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
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
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
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
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
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
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.
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
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
13 matches
Mail list logo