PHPmyadmin don't work well

Hello

i have a reseller account and have such a problem.

my site is working on php-mysql, and when i try to do DB export via phpmyadmin (size of db is 6gb iz tar.gz format), my site (on user side) go down.
untill downloading finished.

when i tell me hoster that this is a phpmyadmin or mysql configuration problem, he told me that his server is well configured and don't allow any user to do overloading.

can DB export via phpmyadmin may be the reason of overloading? and why my site is in down during this?

hoster send my his server limitations:
here they are: KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 10
MaxClients 512
MaxRequestsPerChild 100
safe_mode = Off
max_execution_time = 20 ; Maximum execution time of each script, in seconds
memory_limit = 6M ; Maximum amount of memory a script may consume (8MB)
register_globals = On
post_max_size = 55M
mysql.allow_persistent = Off
[client]
port = 3306

[mysqld]
port = 3306
#socket = /var/tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=16M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
set-variable = max_connections=500
set-variable = max_user_connections=45
set-variable = interactive_timeout=20

# added by nick
#skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
# end of added by nick


[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

unfortunately i don't understand anythink in it, but think that if db export don't work, it the problem of the hoster and not mine.

btw, he suggest me to move to semidedicated server :-(

 

 

 

 

Top