tag:blogger.com,1999:blog-6480555434853676325.post2357437837603465175..comments2023-07-13T04:04:51.867-06:00Comments on MySQL DBA - An Oracle DBA's Journey: Learning the MySQL ArchitectureAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6480555434853676325.post-62265126709898321492009-08-06T07:57:55.158-06:002009-08-06T07:57:55.158-06:00Philip, look at my Labels section under DBA Best ...Philip, look at my Labels section under DBA Best practices and look at MOCA. It has recommendations for how to lay out your data.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-14876453176986288152009-08-05T15:54:26.612-06:002009-08-05T15:54:26.612-06:00What about sizing the database?
Currently I see y...What about sizing the database?<br /><br />Currently I see your layout using only one datafile.<br /><br />At my last employer we setup oracle to use 2 data filesystem when data is less than 500GB. If it is more then we setup 4 data filesystem.<br /><br />Oracle does this with no problems so what about MySQL?OkieUnixhttps://www.blogger.com/profile/07240446787268033019noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-56951652916492068662009-07-01T10:11:06.928-06:002009-07-01T10:11:06.928-06:00Phil, I think you have a really good point. Espe...Phil, I think you have a really good point. Especially since storage engines are a core area of MySQL. I'd love to write more on storage engines, but with this set of blogs I am just trying to provide some high level insights into MySQL. I will tell you there are a "lot" of very interesting things going on with 3rd party storage engines. I'd love to hear some of your Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-60978073629104460102009-07-01T09:27:05.136-06:002009-07-01T09:27:05.136-06:00Don't you think that where one is concerned ab...Don't you think that where one is concerned about MySQL being presented as a toy, it is by omission the biggest mistake to just list "3rd party" storage engines without even attempting to deliver information about where MVCC log files might be, whether the relevant storage engin is InnoDB or not?Unknownhttps://www.blogger.com/profile/13636955866097692739noreply@blogger.com