 Mysql..., and its limits? |
|
|
|
|
  |
 Jun 23 2005, 05:37 PM
Post
#1
|
|
|
Ephesians 6:10-17  Group: [MODERATOR] Posts: 1,893 Joined: 22-June 05 From: The World of Gentoo Member No.: 8,528   |
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?
|
 |
 
|
|
Jun 23 2005, 06:07 PM
Post
#2
|
|
|
Super Member  Group: Members Posts: 378 Joined: 8-January 05 Member No.: 3,174 |
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. |
|
|
|
|
Jun 23 2005, 09:20 PM
Post
#3
|
|
|
Newbie [Level 2] Group: Members Posts: 27 Joined: 23-June 05 Member No.: 8,585 |
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.
|
|
|
|
|
Jul 26 2005, 05:47 PM
Post
#4
|
|
|
Newbie Group: Members Posts: 4 Joined: 23-July 05 Member No.: 9,751 |
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. |
|
|
|
|
Jul 30 2005, 09:48 PM
Post
#5
|
|
|
Member [Level 2] Group: Members Posts: 86 Joined: 18-July 05 From: Lithuania Member No.: 9,570 |
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 
|
|
|
|
|
Oct 4 2005, 08:51 PM
Post
#6
|
|
|
Newbie [Level 3] Group: Members Posts: 42 Joined: 3-October 05 Member No.: 12,518 |
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. |
|
|
|
|
Oct 6 2005, 03:49 AM
Post
#7
|
|
|
Advanced Member Group: Members Posts: 123 Joined: 5-September 05 Member No.: 11,522 |
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! |
|
|
|
|
Oct 6 2005, 05:23 AM
Post
#8
|
|
|
Premium Member Group: Members Posts: 197 Joined: 3-April 05 From: Cuernavaca, Mexico Member No.: 5,226 |
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!! 
|
|
|
|
|
Oct 6 2005, 02:05 PM
Post
#9
|
|
|
$p4m 0n j00 $h4m3 m3 0nc3 $p4m 0n m3 $h4m3 m3 7\/\/1c3 Group: [HOSTED] Posts: 6,444 Joined: 21-September 04 From: 9r33|\| 399$ 4|\|D 5P4/\/\ Member No.: 1,218 |
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?
|
|
|
|
