Re: Bulk Insertion Performance

2010-12-15 Thread Feris Thia
Hi Mark, On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews wrote: > Feris, > > I don't know what Kettle is doing under the hood, but if it's doing > addBatch(), executeBatch(), then adding "rewriteBatchedStatements=true" to > your MySQL JDBC URL should probably help quite a bit. > It works. By ha

Re: Autostart not working for me in 5.5.8 version

2010-12-15 Thread Yangontha Maung
Hi, I will answer my own question. I have to add a line in (/etc/my.cnf) as follows:- basedir=/usr/local/mysql I have installed mysql in /usr/local/mysql. But the same was done in previous versions and I do not need to add this. Anyway, now that it is working. rgds, --- On Thu, 12/16/10

Autostart not working for me in 5.5.8 version

2010-12-15 Thread Yangontha Maung
Hi, Please help to set up the autostart of mysql when the Linux server starts. It is not working for me after installing to version 5.5.8. I have been using different versions of mysql for quite some time with different servers, Fedora versions. All these are working for autostart. But for thi

Re: [NEWS]

2010-12-15 Thread Noel Butler
On Wed, 2010-12-15 at 14:06 +0200, Sergey Lazurenko wrote: > Hello! Hello! I'd like to place basic information about our products. I'll > be appreciate you. > > Best Regards, > Sergey Lazurenko > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe

Re: Bulk Insertion Performance

2010-12-15 Thread Mark Matthews
On Dec 14, 2010, at 7:21 PM, Feris Thia wrote: > Hi Mark, > > On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews > wrote: > 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

MySQL Community Server 5.5.8 has been released

2010-12-15 Thread Karen Langford
Dear MySQL users, We are proud to present to you the MySQL Database 5.5.8 GA release, the first 5.5 production version of the world's most popular open source database. MySQL 5.5.8 is recommended for use on production systems. MySQL 5.5 includes several high-impact changes to address scalabilit

[NEWS]

2010-12-15 Thread Sergey Lazurenko
Hello! Hello! I'd like to place basic information about our products. I'll be appreciate you. Best Regards, Sergey Lazurenko CodeCompare 2.50.odt Description: application/vnd.oasis.opendocument.text -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: restrict mysql replication ?

2010-12-15 Thread Per Jessen
Johan De Meersman wrote: > On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote: > >> Per Jessen wrote: >> >> > Is there a way of limiting that? Alternatively, is there a way of >> > doing "replication-on-demand", perhaps triggered by cron? >> >> Ignore this, problem solved. I'll let the slaves

Re: restrict mysql replication ?

2010-12-15 Thread Johan De Meersman
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen wrote: > Per Jessen wrote: > > > Is there a way of limiting that? Alternatively, is there a way of > > doing "replication-on-demand", perhaps triggered by cron? > > Ignore this, problem solved. I'll let the slaves query the master > regularly and jus

Re: restrict mysql replication ?

2010-12-15 Thread Per Jessen
Per Jessen wrote: > Is there a way of limiting that? Alternatively, is there a way of > doing "replication-on-demand", perhaps triggered by cron? Ignore this, problem solved. I'll let the slaves query the master regularly and just reload the entire table. /Per Jessen, Zürich -- MySQL Gener

restrict mysql replication ?

2010-12-15 Thread Per Jessen
I have a need to have a number of small tables (perhaps up to 1 rows each) replicated to a number of mysql slaves. Frequency of change is very low, and they need not be replicated within seconds, an hour is fine. The master server has a lot more and bigger tables, but each slave will only hav