phpMyAdmin help

**Oznob** · Apr 21, 2003, 06:11

For some reason - I can no longer view the overview of my database (i.e. the main page in phpMyAdmin showing all the tables).

I can see all the tables in the left hand frame and can pull up any of them in the main frame - but when I click on the database name I no longer see the list of all the tables with the little checkboxes beside them.

version 2.3.3 used

--- Could it because I all of a sudden have too many tables in my database ? (I have 1322 now).

--- How can this be fixed easily

Thanks in advance,
Oznob

**PHP John** · Apr 21, 2003, 06:33

Let me get this clear... you have 1322 TABLES in ONE database?

**Oznob** · Apr 21, 2003, 06:58

yup - (i.e. a couple differernt forums and nuke sites in one database).

is this a problem?

**PHP John** · Apr 21, 2003, 08:49

This from the manual:
5.4.8 Drawbacks to Creating Large Numbers of Tables in the Same Database

If you have many files in a directory, open, close, and create operations will be slow. If you execute SELECT statements on many different tables, there will be a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. You can reduce this overhead by making the table cache larger.

--

I don't know how you have the whole thing organized, but it seems to me be fairly unwieldy, and could be a real headache to maintain. However, my experience with large databases is limited, and I am curious myself, to read what someone with more experience with mySQL databases has to say about it.

**Oznob** · Apr 21, 2003, 09:07

Because most of the application on this database are things like nuke sites, bulletin boards, etc. I have just set up different prefixes for the tables related to each site.

I too now am curious if this is a bad thing to do.

But most importantly - if someone could answer my first question - how I fix it to show that homepage in phpMyAdmin (or wont it work because of the large number of tables).

Oznob

**Dr Livingston** · Apr 21, 2003, 09:46

LoL...

Sorry but over one thousand tables ? Come again ? I think you'd be better off putting at least some of those tables into seperate databases....

**rsdl** · Apr 21, 2003, 10:25

Thousand tables..whoa...how'd that happen? PHPNuke, bulletin boards...etc installs their tables in seperate databases. odd...odd indeed. yea, you better divide your tables into seperate databases or else it's going to be murder on your server.

-rsdl