MySQL Community Server 5.5.10 has been released

2011-03-16 Thread Hery Ramilison
Dear MySQL users, MySQL 5.5.10 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.10 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL D

Re: Backup Policy

2011-03-16 Thread Karen Abgarian
Interestingly, this page does not say anything about MySQL Enterprise Backups. On Mar 15, 2011, at 8:48 AM, a.sm...@ukgrid.net wrote: Hi, there is a lot of info on different backup methods here: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html For example, for incremental backu

RE: Suggestions for InnoDB files

2011-03-16 Thread Rolando Edwards
You should use a simpl data path and create a separate tablespace for each InnoDB file innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table This way, ibdata1 only contains the metadata and MVCC control data for all InnoDB files and transactions Awhile back, you ran a query to get

mysql using aio/raw device on linux

2011-03-16 Thread Zhu,Chao
hi, Guys One Q: Can mysql binlog use raw device on Linux? Can we use asynch IO for binlog writing? sequential non-qio fsync is slowing our throughput... Thx -- Regards Zhu Chao

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
- Original Message - > From: "Adarsh Sharma" > Johan De Meersman wrote: > A Heartiest Thanks from my heart for explaining all these things in a > fantastic manner. I agreed with your suggestions but one thing which > isn't explained from your side , as you go deeper in RAID point. > Q:-

Re: Suggestions for InnoDB files

2011-03-16 Thread Adarsh Sharma
Johan De Meersman wrote: From: "Adarsh Sharma" Johan De Meersman wrote: Interesting, but why like this instead of simply larger disks or raidsets ? It's the IT-Admin Issue , I can't question that and we have only disks of 300GB ( SAS ). Your admin is supposed to provide se

Re: mysql binlog format

2011-03-16 Thread Johan De Meersman
- Original Message - > From: "Brent Clark" > > 'Statement may not be safe to log' Heh. Some of those statements weren't particularly safe in previous versions, either, but they didn't whine :-p Roughly, what it comes down to is that statements that contain things that may be differe

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
> From: "Adarsh Sharma" > > Johan De Meersman wrote: > > Interesting, but why like this instead of simply larger disks or raidsets ? > > It's the IT-Admin Issue , I can't question that and we have only disks of > 300GB ( SAS ). Your admin is supposed to provide services that benefit the applicat

mysql binlog format

2011-03-16 Thread Brent Clark
Hiya I run master - master replication for my MySQL replication setup. Ive just upgraded to Mysql 5.1 and as a result im seeing the following in my syslog. 'Statement may not be safe to log' Ive been reading up on the following. http://dev.mysql.com/doc/refman/5.1/en/replication-sbr-rbr.htm