Re: MySQL Magazine - Issue 1 available NOW!!!!

2007-06-06 Thread Peter Rosenthal
I would disagree on the use of mysql_real_escape_string(). The use of placeholders is much safer from a maintenance and 'oops look I typoed it' perspective. On 04/06/07, Jon Ribbens [EMAIL PROTECTED] wrote: On Mon, Jun 04, 2007 at 02:44:25PM -0700, Daevid Vincent wrote: Thanks for the

Re: [PART 2/2] InnoDB - Different EXPLAINs for same query

2007-01-17 Thread Peter Rosenthal
While I think optimize does an analyze, you may find that just an ANALYZE will do it instead of a full OPTIMIZE: http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html On 18/01/07, William R. Mussatto [EMAIL PROTECTED] wrote: Just a thought, did you try running Optimize Table from the

Re: Losing MySQL 5.0 connection at random on Windows box

2006-10-27 Thread Peter Rosenthal
10061 means actively refused. Maybe check your event log around the same time to see if mysql died? On 27/10/06, mos [EMAIL PROTECTED] wrote: Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get an error message Can't connect to MySQL server on 'localhost' (10061) Socket

Re: Anyone tried solidDB for MySQL?

2006-08-29 Thread Peter Rosenthal
http://www.solidtech.com/en/carrier-grade/index.asp http://dev.soliddb.com/en/index.php On 29/08/06, Ratheesh K J [EMAIL PROTECTED] wrote: What is this solidDB? where can i get much info on this?? Thanks, Ratheesh Bhat K J

Re: Anyone tried solidDB for MySQL?

2006-08-26 Thread Peter Rosenthal
I've installed the beta and imported data. It took longer to import than InnoDB does so I think at least inserts are slower. I haven't benchmarked reads or anything yet. I like the idea of having MVCC instead of locks. We would benefit more from better query planning so I'm unsure whether we

Sub-query optimizer improvements scheduled?

2006-05-06 Thread Peter Rosenthal
Out of interest is there any time on the roadmap to improve the query optimizer's handling of sub-queries as specified in http://dev.mysql.com/doc/refman/5.0/en/subquery-restrictions.html ? Thanks.