Mysql...

truefusion

Jun 23 2005, 05:37 PM

I haven't been able to try out any mysql databases, but is more than one really required? I'm looking at most hosts and most offer unlimited mysql databases. Shouldn't one database be enough? I would guess one can hold several kinds of information in sub-databases, maybe?

bjrn

Jun 23 2005, 06:07 PM

You can manage with just one, and just make sure all your tables have different names. You could for example add a few characters in front of each table name to show which "group" it belongs to. So you might have
dev_table1
dev_table2
forum_table1
forum_table2
and so on

In fact phpBB by default prefixes all its tables with a few characters so it doesn't clash with any existsing tables you may have.

Something that _is_ important is the amount of space you get for your database(s). Some hosts have space for the databases independent from the rest of your hosting space. Make you that you have enough space for storage.

Other than that, multiple databses is a convenience, and a bit of a security measure (both with regards to password and so on, but also data-corruption). But as I said, you will probably manage with just one.

htmlmaster

Jun 23 2005, 09:20 PM

II would go with five, better safe than sorry. It really depends on the type of website you run. If you run an extremely dynamic website with submission forms, user log-ins, and other stuff that requires a MySQL database, then shoot for unlimited. Otherwise if your website is more static go for about 5, just in case you decide you want to use them.

Dominic

Jul 26 2005, 05:47 PM

QUOTE(htmlmaster @ Jun 23 2005, 05:20 PM)

I would go with five, better safe than sorry.

I agree, If someone is using over 50 MySQL databases at a time, the server will go REALLY slow.

sader

Jul 30 2005, 09:48 PM

QUOTE(Dominic @ Jul 26 2005, 07:47 PM)

I agree, If someone is using over 50 MySQL databases at a time, the server will go REALLY slow.

Are you want to say Dominic that is much better use one database
with many tables instead many databases

I realy want to know that

Nileshpatel

Oct 4 2005, 08:51 PM

Hello

Wehosting server is not simple server its handle more than 500 site at a time so
i thing for webserver its not issue for fast/slow.

But if you are use use diffrent database rather that table than it will take more time compare to one database.

arboc7

Oct 6 2005, 03:49 AM

One database would be the fastest and likely the most efficient. But it's all up to you. There are some professionals out there who are database consultants, so that should give you an idea of how complex the issue could be. It's really up to you...

Good Luck!

sonorama

Oct 6 2005, 05:23 AM

I guess I'd use more than one... I just read something about tables and it said that tables can make unstable a site or a whole database.

So, i think i will keep using my 3 MySQL and that should be enough for me

Cheers!!

Saint_Michael

Oct 6 2005, 02:05 PM

so wait your telling me with-in the one mySQL table you could run everything would that mean you would have to do all the editing in myphpadmin or could you do that in cpanel?

DreamCore

Oct 6 2005, 03:09 PM

I dont think peapole shuld use over 15 databases so I would add the limit to 15 databases beacuse may be some beginners dont know how to add tables.

So thats my tought....

Latest Entries

michaelper22

Nov 9 2005, 02:55 AM

You can use phpMyAdmin, an open source tool that you can acces from cPanel. I use it occasionally, and find it easy to use.

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute your information that might help someone here. Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE

Mysql... - and its limits?

Mysql... - and its limits?

Latest Entries