zgkhoo Posted November 16, 2007 Share Posted November 16, 2007 a site 2 database is it the limit is it more than site that only have 1 database's ? or it determine by the space of the hardware and o/s? Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 16, 2007 Share Posted November 16, 2007 What do you mean actually ? Why do you need 2 database if 1 is enough... Quote Link to comment Share on other sites More sharing options...
thryb Posted November 16, 2007 Share Posted November 16, 2007 2 database limit mean you can create 2 database for you site, If they didnt put any size restriction on the DB then you actually can use as much table as you want, wich mean you can use prefix to separate your table from a website a & b. IE: [MyTable] a_ExampleID a_ExampleName ... b_ExampleID b_ExampleName ... Thats not the best, but it work well and keep you out of confusion. Was that you question ? Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 16, 2007 Author Share Posted November 16, 2007 i afraid one db is not enough space for my multiple huge table......so i plan for more db Quote Link to comment Share on other sites More sharing options...
teng84 Posted November 17, 2007 Share Posted November 17, 2007 its all about normalization!! Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 17, 2007 Author Share Posted November 17, 2007 wat i wanna ask is ......is it two db space greater than one db? Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 17, 2007 Author Share Posted November 17, 2007 *bump* Quote Link to comment Share on other sites More sharing options...
AndyB Posted November 17, 2007 Share Posted November 17, 2007 @ zgkhoo: Take a very deep breath before you respond next. It's near impossible for anyone to answer your question because it's so very vague. Databases have intrinsic overhead. An empty database takes disk space. So splitting one Mb of data into five databases will occupy more disk space than leaving one Mb of data in a single database. The usual solution to _very_large_databases_ is to consider the design and structure of the tables. That's what normalization is about. Perhaps you should Google that to be sure you understand its impact. And normally, data size allocation (regardless of how many databases it's split into) is a function of your web host or web server. With that in mind, and referring to the MySQL reference manual which details size restrictions, what is your real question and why is it significant? Quote Link to comment Share on other sites More sharing options...
zgkhoo Posted November 17, 2007 Author Share Posted November 17, 2007 sorry for that.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.