-- $db
echo --
TABLES=`mysql -u $MUSER -p$MPASS $db -e show tables`
for table in $TABLES
do
mysql -u $MUSER -p$MPASS $db -e Alter table $table disable keys
done
echo completed disabling indexes for database -- $db
done
Cheers,
Anirudh Sundar
DESC;
For top slow queries :-
mysqldumpslow -s c -a -t 5 mysqlslow.log top10_slow-count_envr.log
For Engine Info of a table and other details :-
Show table status like 'tablename';
Cheers,
Anirudh Sundar
On Mon, Aug 9, 2010 at 9:31 PM, PRATIKSHA JAISWAL
pratikshadjayswa...@gmail.com wrote
to do it this way.
Cheers,
Anirudh Sundar
On Mon, Jul 26, 2010 at 9:56 AM, Rob Wultsch wult...@gmail.com wrote:
On Sun, Jul 25, 2010 at 12:55 PM, Geoff Galitz ge...@galitz.org wrote:
Hello.
I need to migrate a master and slave to new hardware. The DB is approx
50G on disk and my time
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 j...@bytesmiths.com wrote:
From: Jay Blanchard jblanch...@pocket.com
You always have to
SUFFICIENT PROGRAMMING LANGUAGE.
Anirudh Sundar.
On Thu, Jul 22, 2010 at 6:08 PM, Jay Blanchard jblanch...@pocket.comwrote:
[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 comparing.
[/snip
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 j...@bytesmiths.com wrote:
On 22 Jul 10
,
Anirudh Sundar
DataVail Corp
Mumbai
On Wed, Jun 9, 2010 at 6:52 PM, Michael Dykman mdyk...@gmail.com 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 ODBC connector)
and it's
and 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 sometimes it does not insert record
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 11, 2010 at 9:06 PM, mos
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 mo...@fastmail.fm wrote:
At 10:53 AM 5/11/2010, Anirudh
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 sav...@savage.za.org wrote
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 sav...@savage.za.org wrote:
My appologies for leaving that bit out...
mysql EXPLAIN SELECT COUNT(FlightRoutes.FlightID
.
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. Does this not work in myisam
13 matches
Mail list logo