Re: filter slowquerylog on specific user

2010-09-28 Thread Max Bube
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

Re: Fw: BIN LOG Error when use Begin Trans in Replication.

2010-04-22 Thread Max Bube
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

Re: Innodb and bulk writes

2010-03-19 Thread Max Bube
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

Innodb and bulk writes

2010-03-18 Thread Max Bube
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

Re: Innodb and bulk writes

2010-03-18 Thread Max Bube
/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

Re: Default Date and Time

2009-06-26 Thread Max Bube
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,

Re: a possible group issue???

2009-06-12 Thread Max Bube
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), -