Try maatkit mk-query-digest
mk-query-digest --filter '($event->{user} || "") =~ m/user/' mysql.slow.log
2010/9/28 Stefan Onken
> Hello,
>
> is there any way to run a a slow query analyse with "mysdumpslow" only on
> specific mysql user connections? We have multiply application accessing
> the
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A
> Hi Hao Ding,
>
> I attached in my request mail it self. Please find the attachment.
> Thank you
>
> --
> *From:* hao ding
> *To:* Vikram A
> *Sent:* Wed, 21 April, 2010 7:25:0
0.99 0.0015.8416.00
0.000.00 0.00 0.00
sdj 0.00 0.00 0.00 0.99 0.00 1.98 2.00
0.000.00 0.00 0.00
sdk 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.000.00 0.00 0.00
2010/3/18 Raj Shekhar
> Max Bube g
/3/18 Ananda Kumar
> when the writes are happening, please run "show full processlist" and let
> us know the out put.
>
> regards
> anandkl
>
> On Thu, Mar 18, 2010 at 9:09 PM, Max Bube wrote:
>
>> Hi list,
>>
>> Im having problems with bulk wr
Hi list,
Im having problems with bulk writes (restores from mysqldumps, alters,
delete in (select ...)) with innodb. The servers are at amazon EC2 instances
w/ 15G ram and raid0 4disks EBS.
The problem starts when I run bulk writes like an alter table or a restore
from mysqldump, its starts proces
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle
> Hi All,
>
> I want to create a table that defaults to current_date and current_time.
>
> I have:
>
> CREATE TABLE `personalevent`(
>`pevent` mediumint(10) NOT NULL,
>`eventid` mediumint(10)
Try with GROUP_CONCAT(ScriptName)
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
2009/6/12 bruce
> Hi...
>
> I have the following...
>
> mysql> INSERT INTO ParseScriptTBL VALUES
> -> ('auburnCourse.py',40,1,1),
> -> ('auburnFaculty.py',40,2,2),
> -> ('uof
