Try maatkit mk-query-digest
mk-query-digest --filter '($event-{user} || ) =~ m/user/' mysql.slow.log
2010/9/28 Stefan Onken supp...@stonki.de
Hello,
is there any way to run a a slow query analyse with mysdumpslow only on
specific mysql user connections? We have multiply application
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 Vikram A vikkiatb...@yahoo.in
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
--
*From:* hao ding fire9di...@gmail.com
*To:* Vikram A
Max Bube maxbube at gmail.com writes:
The problem starts when I run bulk writes like an alter table or a
restore
from mysqldump, its starts processing more than 5 rows/s but suddenly
the ratio goes down to 100 rows /sec. and then its stucked at this ratio
even if I restart MySQL
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
/3/18 Ananda Kumar anan...@gmail.com
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 maxb...@gmail.com wrote:
Hi list,
Im having problems with bulk writes (restores from mysqldumps
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
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,
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 bedoug...@earthlink.net
Hi...
I have the following...
mysql INSERT INTO ParseScriptTBL VALUES
- ('auburnCourse.py',40,1,1),
-