He, Ming Xin PSE NKG wrote:
> Hi, Pipes
> Is it reliable to use MySQL 5.1 in a commercial product now since it is
> still a beta version?
Hmmm. Probably depends on what you are doing with it... But, in
general, it's fairly sta ble at this point but, like all beta software,
cannot be considered a production version.
> -----Original Message-----
> From: Jay Pipes [mailto:jay@stripped]
> Sent: Wednesday, April 18, 2007 10:04 PM
> To: Brent Baisley
> Cc: He, Ming Xin PSE NKG; mysql@stripped
> Subject: Re: Problem on millions of records in one table?
> Brent Baisley wrote:
>> It all depends on how complicated your data and searches are. I've got
>> tables that add 2-3 million per day and I don't have performance
>> problems. Although we only retain at most 500 millions records, not a
>> full years worth.
>> That said, you can get horrible performance out of mysql with tables
>> small as 100,000 records if you don't structure your queries correctly
>> or use a good table structure. If I know the tables are going to grow
>> quickly and I don't need the entire dataset all the time, I'll use
>> tables. This makes it easy to remove "old" data easily from the
>> table set.
> Hi! Have you tried out the new partitioning features of MySQL 5.1 to do
> this? Would be cool if you had some performance numbers comparing the
> older MERGE table method with the newer partitioning...
>> ----- Original Message ----- From: "He, Ming Xin PSE NKG"
>> To: <mysql@stripped>
>> Sent: Tuesday, April 17, 2007 11:03 PM
>> Subject: Problem on millions of records in one table?
>> The number of the records in one table increase constantly. As
>> evaluated, the amount would increase to at least 30 millions within
>> year. So we worry about whether mysql could handle such a big amount
>> records with good performance. Or need we some other solutions to
>> this problem ,such as using Partition, dividing a big table and etc.
>> help or idea would be greatly appreciated.
>> Best Regards