Getting error while launching mysqld

2014-09-04 Thread Banerjee, Somnath
Hi, We are getting following error while launching mysqld_safe in local machine. Any help would be appreciated. -- connect to address 127.0.0.1 port 544: Connection refused connect to address 127.0.0.1 port 544: Connection refused trying

ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5 Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool: Database Workbench 5 There have been numerous improvements to existing tools and the new, more consistent user interface is

Re: next-key lock

2014-09-04 Thread Akshay Suryavanshi
Hi Geeetanjali, I retried the scenario you mentioned, however I am getting consistent locking results on both unique and non-unique index, the preceding records are getting updated however just the next record is being locked next-key locking. If I try to insert a new record after the next key it

Re: next-key lock

2014-09-04 Thread geetanjali mehra
Thanks to all, Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Sep 4, 2014 at 2:36 PM, Akshay Suryavanshi akshay.suryavansh...@gmail.com wrote: Hi Geeetanjali, I retried the scenario you mentioned, however I am getting

Re: purge thread

2014-09-04 Thread Akshay Suryavanshi
Hi Geetanjali, Well word of caution with this setting, it can block the whole server if the purge thread is delayed too much. Also look into other things like IO saturation or issues with disk as to why the purge thread is not able to keep up with the backlog. If IO is not the issue then there is

Re: Query regarding implementation of parallel-replication

2014-09-04 Thread Ajay Garg
Hi all. Unfortunately, I have run into the logs, as described at http://bugs.mysql.com/bug.php?id=71495 Unfortunately, the issue does not go away, even after reverting back to slave-parallel-workers=0 in my.cnf, and restarting the mysql instance. Any quick idea, as to how we may get the

Re: 1045 Error accessing mysql db

2014-09-04 Thread Divesh Kamra
check weather there any space in localhost 'localhost ' Also check permission for 'foo' user though command select * from mysql.user where 'foo'; On Thu, Aug 21, 2014 at 6:53 AM, Augori aug...@gmail.com wrote: After an operating system change (CentOS 5 to CentOS 6), my Python script could

Re: 1045 Error accessing mysql db

2014-09-04 Thread wagnerbianchi.com
Do you know if the Python version has changed? Do you know what was the Python version you used to develop your script on CentOS 5? So, If anything has changed in mysql.user table or even in `foo` user credentials, it seems that your script must be reviewed and even the Python version in use

Re: Query regarding implementation of parallel-replication

2014-09-04 Thread wagnerbianchi.com
You can try these steps: 1-) Stop slave and write down the replication coordinates getting that in MySQL's error log (*very important step*); 2-) Issue the `reset slave` command on MySQL Slave; 3-) Issue the CHANGE MASTER TO considering the replication coordinates you've just written down on step

Re: ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Jan Steinman
From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your

RE: converting numeric to date-time?

2014-09-04 Thread Jan Steinman
From: Ed Mierzwa (emierzwa) emier...@micron.com FROM_UNIXTIME(1409304102.153) /*your epoch column here*/ I don't think the OP has a Unix timestamp. The number looks suspeciously like concatenation of date digits, 140930 at the beginning looks like September 30, 2014. If that's the case,