Re: Kill DELETE Query

2010-12-16 Thread Ananda Kumar
No...it will not. On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto wrote: > Thanks for the reply. I used non stored procedure approach. Another > question is if I kill the process will it crash the table? Thanks. > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > >

Re: Kill DELETE Query

2010-12-16 Thread Willy Mularto
Thanks for the reply. I used non stored procedure approach. Another question is if I kill the process will it crash the table? Thanks. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Dec 17, 2010, at 12:06 PM, Ananda Kumar wrote: > If u have used a stored proc to delete

Re: Kill DELETE Query

2010-12-16 Thread Ananda Kumar
If u have used a stored proc to delete the rows, and commting freqently, then the kill will happen faster. If you have just used "delete from table_name where , then it would take toot much time to rollback all the deleted but not commited rows. Regards anandkl On Fri, Dec 17, 2010 at 8:37 AM, Wi

Kill DELETE Query

2010-12-16 Thread Willy Mularto
Hi List, I run a delete query to delete around 1 million rows in innodb table, It's been hours and still unfinish. Is it safe to kill that delete query process while the table is also inserting and updating other rows? Thanks. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/

Access to MySQL

2010-12-16 Thread Jerry Schwartz
I have to move the back-end of an Access application to MySQL, and I’ve run into one issue that I haven’t been able to solve yet. The Access database stores dates as text in a “/mm/dd” format. The problem is that the default value is a formula that generates the current date, for

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-16 Thread Yves Goergen
On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote: > Are you using ubuntu deb's or mysql bin? Do you get that message when > the service start? Look init script to see what it does. I get the message when MySQL is started. I've installed the Ubuntu standard package mysql-server-5.1. It has alr

Re: MySQL Parallel Inserts

2010-12-16 Thread Andy
Shawn/Krishna, Thank you. I will try this. -Andy On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Andy, > > I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% > faster than normal inserts. > > Krishna > > > On Tue, Dec 14, 201

Re: Password Reset

2010-12-16 Thread Alejandro Bednarik
> > Any guidance on this would be appriciated. > > -- > Gary > > > > __ Information from ESET Smart Security, version of virus signature > database 5708 (20101216) __ > > The message was checked by ESET Smart Security. > > http://www.eset.com >

Password Reset

2010-12-16 Thread Gary
database 5708 (20101216) __ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Shawn Green (MySQL)
On 12/16/2010 03:53, Tim Thorburn wrote: On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Wor

Re: Autostart not working for me in 5.5.8 version

2010-12-16 Thread Alejandro Bednarik
You are right. In previous version init script have a default value, now is empty. mysql 5.1..53 - basedir=/usr/local/mysql mysql-5.5.8 - basedir=. Cheers. On Thu, Dec 16, 2010 at 12:42 AM, Yangontha Maung wrote: > Hi, > > I will answer my own question. > > I have to add a line in (/etc

Re: Bulk Insertion Performance

2010-12-16 Thread Johan De Meersman
Hmm, interesting. What does this do, exactly ? Can something similar be applied to non-jdbc connections, too ? On Thu, Dec 16, 2010 at 8:34 AM, Feris Thia < milis.datab...@phi-integration.com> wrote: > Hi Mark, > > On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews > wrote: > > > Feris, > > > > I d

Re: Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run Workbenc

Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
Hello, I just downloaded MySQL 5.5.8 (Win64 version) today and installed it on my dev machine. Previously I had MySQL 5.1.51 installed - as I've always felt it was better to uninstall the old before installing the new with Windows, I uninstalled 5.1.51 by doing the following: - As Administra