database size unusual?

[3d Dental]

My database is now over 400MB and that does not include a backup.

Is this unusual for web site with less than 50,000 posts and only 2200 members?

Three years old.

Site is down and exceeded my storage capacity for my server and I cant seem to get networksolutions to upgrade me to 1000MB database storage.

I paid for it Four days ago but some tech issue nobody can explain to me reason for the issues with adding space?

www.3d-dental.com



Yesterday Mr. Turbo and I changed MySQL password to admin and also edit the config.php to match of course.

Site instantly started to work as normal again.

 

[3d Dental]

networksolutions tells me not possible to upgrade to 2000MB.....but they took my money and sold me that!

lol

 

[3d Dental]

Had a ticket open with networksolutions since Tues!

My database is frozen and no access.

Is it normal to have database over 400MB ?

Networksolutions tell me that need to have access to it to grab some tables?

Then, they can do something?

 

[Floyd R Turbo]

My database is now over 400MB and that does not include a backup.

Is this unusual for web site with less than 50,000 posts and only 2200 members?

Three years old.

Site is down and exceeded my storage capacity for my server and I cant seem to get networksolutions to upgrade me to 1000MB database storage.

You can go into phpmyadmin and look at the tables, order by size, and look for one that is extraordinarily large. Usually that is the search index, which you can “drop” and rebuild later. Once you drop it, search won’t work until it’s rebuilt but that would reduce the database size temporarily. I’d check first through to see if that might have some unintended consequences

@Chris D any thoughts on that as a temporary course of action?

 

[3d Dental]

I now have access to everything again.....after changing passwords again!

Same as yesterday.

So...anyone care to accept some money to look at my xeno stuff?

Why is my database over 400MB with such a small site?

 

[3d Dental]

calling xenoforo experts to work for money.

Check my stuff and tell me if looks normal or not?

using phpMyAdmin and also have FTP open to access other files.

?

Whatever you need access to.

I require for you to download teamviewer and join me on my PC.
That way....I do not have to tell you any of my passwords!

It is for my protection guys.

I am not working with help by typing back and fourth anyother wAy

 

[3d Dental]

Grab teamviewer in 10 second...

http://connect.teamviewer.com/v11

then I send you my numbers to connect.

I have paid license on my end, and no need to signup to join or ?? to use this.

Scotty

 

[3d Dental]

Anything out of the norm here?

My tables listed in order of Rows....highest first

xf_ip table has 82,167 Rows?

 

[TPerry]

My advice... find a new qualified hosting provider immediately and since you are apparently using cPanel have them do a cPanel -> cPanel transfer for you.

 

[3d Dental]

Nobody has answered my question I have now asked over and over....

Is 400MB normal size for database?

Yes or No question.

 

[3d Dental]

My database is 400MB (+/-)

My site is here www.3d-dental.com

This is a list of database tables sorted by rows....highest first, which is xf_ip

 

[3d Dental]

Does this seem reasonable?

My site only has 2200 members and 17,000 total posts.

?

 

[Chris D]

People were probably waiting for some indication about your table sizes, which you only provided in your previous message.

To be honest, those numbers look fairly normal (and the size). The IP log is pruned every day, removing any items older than 1 year. You can change that in the Admin CP. Search "ipLogCleanUp" in the Admin CP though I wouldn't expect it to have a huge impact on database size.

The size of your stuff however is likely a very moot point. If you move to another host, then you can make sure they can provide a reasonable amount of storage. Even the cheapest host I can find gives you 100GB of storage...

 

[3d Dental]

I have 300000 MB (300GB) of total Web Disk Storage space, but only 300MB of that is dedicated to my database

I am trying to get the database moved or upgraded to 1000MB storage size.

According to networksolutions....my site is very large database and they seem to think this is an issue.

The size of my database has fluxuated wildly!

Monday was 340MB......Wed was 180MB......today now over 400MB

 

[3d Dental]

I would feel great if an expert would check out my database and ?? to tell me if something is out of the norm

Having 82,000 rows in xf_ip is OK you are saying??

 

[3d Dental]

Networksolutions tell me NOBODY....ZERO of their customers have a database over 1GB

That is not even possible to buy that much storage space just for the database!

They say my database is too large for what it is.

The maximum amount to buy is 1GB for the actual database itself.

 

[Slavik]

I would feel great if an expert would check out my database and ?? to tell me if something is out of the norm

Having 82,000 rows in xf_ip is OK you are saying??

Happy to take a look, but yes, IP's quickly build up, so pruning them off keeps that table small.

 

[3d Dental]

I am not trained in "pruning" a table of ip.

Not sure if I should, have no idea of the consequences.

Do you recommend this?

 

[Chris D]

To be honest, those numbers look fairly normal (and the size). The IP log is pruned every day, removing any items older than 1 year. You can change that in the Admin CP. Search "ipLogCleanUp" in the Admin CP though I wouldn't expect it to have a huge impact on database size.[/QUOTE]

 

[3d Dental]

Chris......

?

I asked if I should.
I asked the consequences.

Do you think you answered that?
What is purpose of your re-post that I already read man?