| |
| | |

CodersClub

 Forgot password?
 Register
Search
View: 4123|Reply: 4
Collapse the left

Database size in phpmyadmin

[Copy link]
Post time: 2012-07-21 21:05
| Show all posts |Read mode
Hello. After fresh install my database has 23mb. Is it normal? This numbers shows me PhpMyAdmin but when I created backup of my forum (discuz + uc) I have only 500kbs. Whats wrong?

 Palestine

Post time: 2012-07-21 23:47
| Show all posts
Yesw its wrong and too larg !

amybe it's not new database

it has tabels before install discuz


 Author| Post time: 2012-07-22 00:59
| Show all posts
Edited by kaaleth at 2012-7-21 23:01

No, it's new database. I installed discuz 2 times and I don't know why this happend. The largest tables are: pre_common_district (2mb) pre_ucenter_vars (5mb) pre_common_session (8.5mb) pre_common_process (12mb). I will check it on my localhost, but I don't know reason why...

Now it has 28mb... I have no posts, no topics, no forums, just only admin account. I changed some info about forum (title, groups, ranks, styles) and that's all.

 Russia

Post time: 2012-07-22 08:32
| Show all posts
The database size is not wrong.
It is ok, but unfortunately is very large.
The large size is a cost that we have to pay for the high working speed.
For achive fast working we have to create a lot of database indexes that require alot of disk space...

And the second reason - it is a not so good database design.
 Author| Post time: 2012-07-22 11:55
| Show all posts
Forum is runing very fast. I exported database but I get only 500kbs. After this I put this database to my localhost and there are only 1.1Mb. Maybe it's something wrong with my hosting company.

Anyway, thanks for your answers.
You have to log in before you can reply Login | Register

Points Rules

Archive|Mobile|Dark room|CodersClub

Top.Mail.Ru
Top.Mail.Ru

2024-11-22 15:50 GMT+3 , Processed in 0.053071 sec., 9 queries .

Powered by Discuz! X3.4 Release 20230520

© 2001-2024 Discuz! Team.

MultiLingual version, Rev. 4301, © codersclub.org

Quick Reply To Top Return to the list