Re: killing mysqldump

2012-05-31 Thread Singer X.J. Wang
Yes, killing a mysqldump is perfectly safe. Caveat being that the dump file produced may be pretty useless. Singer On Thu, May 31, 2012 at 7:41 AM, Roland Roland wrote: > Is it safe to kill a mysqldump while it's in process ? > i mean aside loosing the dumped file, would it affect the running D

Re: Can the mysql replication limited to one database

2012-05-02 Thread Singer X.J. Wang
RBR solves the default db case.. S On Wed, May 2, 2012 at 1:25 PM, Claudio Nanni wrote: > I recommend to use the 'wild' modifier, if you have a default db and you > specify the schema in the query like update > schemanotreplicated.mytable. you will miss that. > > Claudio > > 2012/5/2 Rick

Re: New Fast MySQL Compatible Server

2012-04-02 Thread Singer X.J. Wang
Perhaps something called a VM can be use? S On Tue, Mar 27, 2012 at 18:12, Mogens Melander wrote: > Guys, really... > > Is this a binary release? Need to sudo to root? Not on my watch! > > On Tue, March 27, 2012 16:40, Baron Schwartz wrote: > > The license of this software is unclear. The bina

Re: New Fast MySQL Compatible Server

2012-03-27 Thread Singer X.J. Wang
Thanks Baron. I downloaded it and found it was dervied from the MySQL server as well. I was looking for the source and found nothing. Mr. Watari, is there source code available? Since you are using GPL source code in your code, you must provide the source code. S On Tue, Mar 27, 2012 at 10:40,

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-05 Thread Singer X.J. Wang
Checking your firewall settings.. S On Mon, Mar 5, 2012 at 08:39, javad bakhshi wrote: > Hi, > > Still have the same problem and changing connect_timeout didn't help. > Any other Ideas? Is there even any solution to this? > > Best regards, > Javad Bakhshi, > > > ___

Re: Query help...

2012-02-29 Thread Singer X.J. Wang
http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ifnull On Wed, Feb 29, 2012 at 13:15, Don Wieland wrote: > Little help... > > In my mySQL query editor, I am trying to return a value of 0 when there is > no related rows from this query: > > (select if(count(ip.payment_

Re: Adding a column to a huge mysql table

2012-02-16 Thread Singer X.J. Wang
If you have a Master-Master and you explicitly name all the columns in your queries, you can do it by doing it on one master and flipping the application and etc. If not, look at http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html Singer On Thu, Feb 16, 2012 at 20:29, Wi

Re: Filesystem choice

2012-02-07 Thread Singer X.J. Wang
I highly recommend against Raw Devices.. You're extremely limiting your backup options in this case.. S On Tue, Feb 7, 2012 at 13:39, Michael Dykman wrote: > If what you are looking for is performance optimization, you might > want to consider: > > http://dev.mysql.com/doc/refman/5.5/en/innodb

Re: SQL DATA

2011-12-13 Thread Singer X.J. Wang
the engineers spend their time on more significant > problems. > > Just my $0.02. > Arthur > > 2011/12/9 Halász Sándor > > > >>>> 2011/12/09 20:37 -0500, Singer X.J. Wang >>>> > > When the procedure is executed, each query in the procedur

Re: SQL DATA

2011-12-13 Thread Singer X.J. Wang
When the procedure is executed, each query in the procedure is obviously run through the query optimizer. But the flags are symbolic only for humans. 2011/12/9 Halász Sándor > ;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang >>>> > But again one of the flags are