MySQL Community Server 5.5.17 has been released

2011-10-22 Thread Joerg Bruehe
Dear MySQL users, MySQL 5.5.17 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.17 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL

Re: How to dynamically create database and tables on mysql?

2011-10-22 Thread Peter Brawley
On 10/21/2011 3:05 AM, 王科选 wrote: Hi, Is there any way to dynamically create database and tables on mysql? For example, if I want to create 100 databases(dbname is unknown until run time), with 100 predefined tables in it, how to achieve that? Thanks in advance! Easiest mebbe from a scripting

Re: Maximum line length or statement length for mysqldump

2011-10-22 Thread Alex Schaft
On 2011/10/21 10:26 AM, Johan De Meersman wrote: - Original Message - From: Alex Schaftal...@quicksoftware.co.za Got my app reading in a dump created with extended-inserts off, and lumping all of the insert statements together. Works like a charm Just for laughs, would you mind

Re: how to optimize mysql in easy way

2011-10-22 Thread mos
At 05:49 AM 10/21/2011, you wrote: how to optimize mysql in easy way step, i know indexing, mapping other than that is any way. -- Thanks Regards, P.Benaya Paul Apart from enrolling in Hogwarts, you may be interested in the book High Performance MySQL 2nd Edition. It can be found in

Re: How to dynamically create database and tables on mysql?

2011-10-22 Thread René Fournier
What is your application? Maybe we can help more. On 2011-10-21, at 2:05 AM, 王科选 wrote: Hi, Is there any way to dynamically create database and tables on mysql? For example, if I want to create 100 databases(dbname is unknown until run time), with 100 predefined tables in it, how to