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
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
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
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
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
Hello,
How can i subscribe for this list
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.
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
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 -- 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
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
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
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.
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
14 matches
Mail list logo