Re: Database procedures

2010-12-14 Thread Machiel Richards
HI All Just to give you some idea of what I have tried thus far: mysql delimiter // mysql create procedure select_delete_id (in dt date, out id bigint) begin select max(id) into id from archive_collections where utc dt; end// Query OK, 0 rows affected (0.00 sec) mysql

Re: MySQL Parallel Inserts

2010-12-14 Thread Krishna Chandra Prajapati
Hi Andy, I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% faster than normal inserts. Krishna On Tue, Dec 14, 2010 at 8:02 AM, Andy listan...@gmail.com wrote: Greetings everyone. I am in a situation where I need to do parallel inserts into MySQL database from inside

List archive?

2010-12-14 Thread Patrice Olivier-Wilson
I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing

Re: List archive?

2010-12-14 Thread Patrice Olivier-Wilson
On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the links to the list, but I don't have any on hand at the moment.) see it on the

Re: List archive?

2010-12-14 Thread Daniel P. Brown
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson b...@biz-comm.com wrote: On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote: I have a question that this list solved a year ago, and I can't remember what the solution was. Does this list have an archive? (Sorry if it is on one of the

How can i subscribe

2010-12-14 Thread omar zorgui
Hello, How can i subscribe for this list

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

2010-12-14 Thread Yves Goergen
On 13.12.2010 15:26 CE(S)T, who.cat wrote: try /mysql_bin_path/mysql_secure_installation ! Hope it helpfu! I already followed that path and it doesn't quite help. I've done the checks that the install script does and my installation is secure by those means. But I don't want to install things.

Re: How can i subscribe

2010-12-14 Thread Daniel P. Brown
On Tue, Dec 14, 2010 at 13:58, omar zorgui omarzor...@gmail.com wrote: Hello, How can i subscribe for this list http://lists.mysql.com/mysql?sub=1 -- /Daniel P. Brown Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting (866-) 725-4321 http://www.parasane.net/ -- MySQL

Negative connection/thread IDs in mysqld.log?

2010-12-14 Thread Atle Veka
Hi, I tried searching for an answer to this to no avail. I noticed my mysqld.log contains negative connection/thread IDs. mysqld itself shows positive IDs as expected. Some sort of wrap? /usr/sbin/mysqld, Version: 5.0.32. started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time

Mysql 5.5.x -- when is it going to go GA?

2010-12-14 Thread Hank
Mysql 5.5 -- when is it going to go GA? And when it does, which version will it be? 5.5.8 or 5.5.6rc? Thanks, -Hank

Bulk Insertion Performance

2010-12-14 Thread Feris Thia
Hi All, I have a data warehouse infrastructure with following configuration : - MySQL 5.0 MyISAM + InndoDB enabled (XAMPP Distribution) - Windows 2003 64 bit data center edition - Java Runtime 6 - 32 bit version And have ETL running data warehouse process. Reading is impressive, 12,000 rows per

Re: Bulk Insertion Performance

2010-12-14 Thread Mark Matthews
On Dec 14, 2010, at 6:51 PM, Feris Thia wrote: Hi All, I have a data warehouse infrastructure with following configuration : - MySQL 5.0 MyISAM + InndoDB enabled (XAMPP Distribution) - Windows 2003 64 bit data center edition - Java Runtime 6 - 32 bit version And have ETL running data

Re: Bulk Insertion Performance

2010-12-14 Thread Feris Thia
Hi Mark, On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews mark.matth...@oracle.comwrote: Feris, *How* are you writing, via batch statements with rewriting, or directly, or via LOAD DATA INFILE? It seems you're off by about a factor of 10-20x from what I've seen performance-wise for writes.

Re: Mysql 5.5.x -- when is it going to go GA?

2010-12-14 Thread Sharl.Jimh.Tsin
not sure,maybe help to you: http://forge.mysql.com/wiki/Development_Cycle#GA_releases Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/15 Hank hes...@gmail.com: Mysql 5.5 -- when is it going to go GA? And when it does, which version will it be?  5.5.8 or