Mysql connections not released

Good morning all A few days ago i posted some questions relating to mysql threads running out and not being able to restart the database. We had the same again this morning however this time I had a bit of a heads up and managed to get into the database befor

Re: Reserving threads for root user

On Wed, Jun 30, 2010 at 8:29 AM, Shawn Green (MySQL) wrote: > On 6/30/2010 6:56 AM, Machiel Richards wrote: >> >> Good day all >> >> >>                Sorry one more question. >> >> >>                I have seen many questions about this on the web but no >> resolution yet. >> >> >>              

Updating 4 to 5

Hi all, I have serveral servers running mysql 4, and need to update to mysql 5. I have version 5 setup on a new dev server and will be cloning that to the old servers, then restoring all the data from backups (mysql databases included). Once I have restored the data from backups, I will neee

Re: phpMyAdmin and other management tools

You can also explore : http://kontrollsoft.com/software-kontrollbase On Thu, Jul 1, 2010 at 5:47 PM, Nilnandan Joshi wrote: > http://mysqlonlinehelp.wordpress.com/2010/06/30/tools-for-mysql-database/ > > regards, > Nilnandan > > > Noel Butler wrote: > >> On Thu, 2010-07-01 at 07:38 -0400, David S

Re: selecting data for computation

> A general-case good design for this is to have status fields, as > suggested, and who-owns-this-row fields. Set the rows initially to > un-owned (NULL), and status 'new' or similar. The "get_lock" approach was ultimately successful, and I think better than using a status field as it is entirely

Re: phpMyAdmin and other management tools

http://mysqlonlinehelp.wordpress.com/2010/06/30/tools-for-mysql-database/ regards, Nilnandan Noel Butler wrote: On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I

Re: phpMyAdmin and other management tools

On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: > Hi Folks, > > > > I'm currently using phpMyAdmin to manage the mySQL databases. I'm > wondering what most people like to use? I know there is "mySQL > Workbench", which I haven't really fooled with yet > command line (mysql prompt

Re: phpMyAdmin and other management tools

Hi Dave, I recommend you to use "Toad for MySQL". It has wizard for query creation phpMyAdimn, mysql workbench, sqlyog lack this feature. Krishna On Thu, Jul 1, 2010 at 5:08 PM, David Stoltz wrote: > Hi Folks, > > > > I'm currently using phpMyAdmin to manage the mySQL databases. I'm > wonderi

Re: phpMyAdmin and other management tools

I prefer the good old command line. ~~Fish~~ On Jul 1, 2010 7:38 AM, "David Stoltz" wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is "mySQL Workbench", which I haven't really fooled with yet Can a

phpMyAdmin and other management tools

Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is "mySQL Workbench", which I haven't really fooled with yet Can anyone comment on what they use and why? Thanks! Dave

RE: INSERT with auto increment

Awesome - thanks all for that clarification! -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Wednesday, June 30, 2010 1:42 PM To: David Stoltz Cc: mysql@lists.mysql.com Subject: Re: INSERT with auto increment generally, it is: INSERT INTO TABLE1 (fieldname [ , f

Re: stored procedure syntax error

I think, you have to use prepare() before run that select statement. i.e SET @s = CONCAT("SELECT * INTO OUTFILE", c ,"FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM cells_summary WHERE PMMDATEANDTIME=b"); PREPARE stmt FROM @s; EXECUTE stmt; regards, nilnandan

stored procedure syntax error

Hi all ! I m getting an error while writing stored procedure, the code is as below and error CODE -- DELIMITER $$ DROP PROCEDURE IF EXISTS `aaa` $$ CREATE definer=`ro...@`%