Max number of mySQL database - UK Web Hosting | Dedicated Server Windows and Linux VPS Forum

**eleboeuf** · #1 (**permalink**) 17-07-2007, 22:06

My Bronze plan allows a maximum of 5 mySQL databases. What are the limits for the Silver, Gold and Reseller package?

Thanks in advance for your help. Thanks.

Eric

**esnail** · #2 (**permalink**) 17-07-2007, 22:10

The reseller package is unlimited MySQL databases - dunno about the others.

**WelshTom** · #3 (**permalink**) 17-07-2007, 23:06

Q. How many MySQL databases do you allow on your hosting packages?
Ans. We allow unlimited MySQL databases on all our hosting plans and you can create as many databases, however, your databases are restricted by your disk space allocation.

http://www.eukhost.com/support/knowledgebase/

**eUKhost.com** · #4 (**permalink**) 17-07-2007, 23:09

Quote:

Originally Posted by eleboeuf

My Bronze plan allows a maximum of 5 mySQL databases. What are the limits for the Silver, Gold and Reseller package?

Thanks in advance for your help. Thanks.

Eric

This has been rectified on your server. please check the same on your end.

**eleboeuf** · #5 (**permalink**) 18-07-2007, 08:39

Yes, it now says that I am using 2 out of 25 SQL database, this should be more than sufficient with the package that I currently have.

Thanks. Eric

**DPS Computing** · #6 (**permalink**) 18-07-2007, 09:34

Glad to see that you got it sorted - the reason for the number of databases being set so low is probably so you don't overload your plan and rapidly run out of disk space

.

**esnail** · #7 (**permalink**) 18-07-2007, 09:48

Quote:

Originally Posted by DPS Computing

Glad to see that you got it sorted - the reason for the number of databases being set so low is probably so you don't overload your plan and rapidly run out of disk space

.

If the plan is unlimited then its not up to eukhost to play GOD and control their usage by limiting the number. The reason for the restriction is surely an administrative error and nothing more. If you wanted 10 apples and I gave you only two in case you ate them all - would you be satisfied?

**DPS Computing** · #8 (**permalink**) 18-07-2007, 09:51

Quote:

Originally Posted by esnail

If the plan is unlimited then its not up to eukhost to play GOD and control their usage by limiting the number. The reason for the restriction is surely an administrative error and nothing more. If you wanted 10 apples and I gave you only two in case you ate them all - would you be satisfied?

No, but if I was on a shared plan and my website went down because of over excessive MySQL usage then (as a possibly inexperienced user) not only would it cause ticket after ticket where do you think the blame would land?

I agree with your point in principle though.

**eUKhost.com** · #9 (**permalink**) 18-07-2007, 13:27

Quote:

Originally Posted by esnail

If the plan is unlimited then its not up to eukhost to play GOD and control their usage by limiting the number. The reason for the restriction is surely an administrative error and nothing more. If you wanted 10 apples and I gave you only two in case you ate them all - would you be satisfied?

I can make it 9999999999 if Eric wants to setup that many databases. Absolutely no problem in doing so

**DPS Computing** · #10 (**permalink**) 19-07-2007, 12:22

Quote:

Originally Posted by eukhost.com

I can make it 9999999999 if Eric wants to setup that many databases. Absolutely no problem in doing so

What kind of website would be running that many

lol.

**Brian** · #11 (**permalink**) 19-07-2007, 17:04

Quote:

Originally Posted by DPS Computing

What kind of website would be running that many

lol.

Im sure we could make one :d

**DPS Computing** · #12 (**permalink**) 19-07-2007, 17:50

Quote:

Originally Posted by Brian

Im sure we could make one :d

lol, what would be the topic of the site?

Wouldn't that crash the shared server?

**eUKhost.com** · #13 (**permalink**) 19-07-2007, 19:33

Quote:

Originally Posted by DPS Computing

lol, what would be the topic of the site?

Wouldn't that crash the shared server?

Server wont allow you to make more than 32,000 Directories in any particular directory so your control panel will not allow you to make that many databases as any sort of directory creation command will fail to execute.

Server wont go down but it wont allow you to make any new directory.

**DPS Computing** · #14 (**permalink**) 19-07-2007, 19:39

Why is 32,000 the limit? Is that a restriction of the operating system or an eUKhost restriction?

**eUK-Martin** · #15 (**permalink**) 19-07-2007, 20:13

Mr. Mark is correct, Linux kernel with ext3 partitions support only 32000 subdirectories as that is the limit for an inods link count. However if you have ext4 partition then you can patch your kernel to have upto 65000+ directories.

**DPS Computing** · #16 (**permalink**) 20-07-2007, 11:32

Quote:

Originally Posted by euk-martin

Mr. Mark is correct, Linux kernel with ext3 partitions support only 32000 subdirectories as that is the limit for an inods link count. However if you have ext4 partition then you can patch your kernel to have upto 65000+ directories.

Thank god that I'm nowhere near 32000 directories!