• I think I want some optimization for my server coz It came slow when ever I do backup


    1. dedicated server (I just have 1 vbulletin forum in the hole server)
    2. your server specs. For example:

    AMD Athlon(tm) XP 3000+
    512mb ram
    80GB ATA DISK drive
    CentOS 3.4 i686
    Apache/1.3.33
    PHP/4.3.10
    MySQL version: mysql 4.0.23-standard


    3. I have only one database for vBulletin forum
    4. !??!?!
    5. your top stats
    08:20:27 up 4:21, 1 user, load average: 0.22, 0.23, 0.25
    110 processes: 108 sleeping, 2 running, 0 zombie, 0 stopped
    CPU states: cpu user nice system irq softirq iowait idle
    total 2.9% 0.0% 0.1% 0.1% 0.0% 0.5% 96.0%
    Mem: 447328k av, 428532k used, 18796k free, 0k shrd, 12132k buff
    327440k actv, 64372k in_d, 6488k in_c
    Swap: 1052216k av, 57408k used, 994808k free 168508k cached
    PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
    1239 mysql 15 0 29020 24M 1352 S 0.3 5.5 9:04 0 mysqld
    7337 root 15 0 1180 1180 892 R 0.1 0.2 0:00 0 top
    1 root 15 0 508 476 448 S 0.0 0.1 0:03 0 init
    2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
    3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd
    4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
    7 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
    5 root 15 0 0 0 0 SW 0.0 0.0 0:01 0 kswapd
    6 root 15 0 0 0 0 SW 0.0 0.0 0:03 0 kscand
    8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
    9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
    13 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
    478 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
    479 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
    480 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald



    6. your mysql configuration variables located at /etc/my.cnf or c:my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type

    [mysqld]
    skip-innodb
    max_connections = 500
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 7200
    connect_timeout = 10
    tmp_table_size = 64M
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    [mysqld_safe]
    open_files_limit = 8192
    [mysqldump]
    quick
    max_allowed_packet = 16M
    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M




    7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:

    +--------------------------+------------+
    Variable_name Value
    +--------------------------+------------+
    Aborted_clients 0
    Aborted_connects 0
    Bytes_received 36204868
    Bytes_sent 1707158377
    Com_admin_commands 0
    Com_alter_table 0
    Com_analyze 0
    Com_backup_table 0
    Com_begin 0
    Com_change_db 13703
    Com_change_master 0
    Com_check 0
    Com_commit 0
    Com_create_db 0
    Com_create_function 0
    Com_create_index 0
    Com_create_table 0
    Com_delete 392
    Com_delete_multi 0
    Com_drop_db 0
    Com_drop_function 0
    Com_drop_index 0
    Com_drop_table 0
    Com_flush 0
    Com_grant 0
    Com_ha_close 0
    Com_ha_open 0
    Com_ha_read 0
    Com_insert 6803
    Com_insert_select 82
    Com_kill 0
    Com_load 0
    Com_load_master_data 0
    Com_load_master_table 0
    Com_lock_tables 28
    Com_optimize 0
    Com_purge 0
    Com_rename_table 0
    Com_repair 0
    Com_replace 453
    Com_replace_select 0
    Com_reset 0
    Com_restore_table 0
    Com_revoke 0
    Com_rollback 0
    Com_savepoint 0
    Com_select 42214
    Com_set_option 0
    Com_show_binlog_events 0
    Com_show_binlogs 0
    Com_show_create 0
    Com_show_databases 4
    Com_show_fields 0
    Com_show_grants 0
    Com_show_keys 0
    Com_show_logs 0
    Com_show_master_status 0
    Com_show_new_master 0
    Com_show_open_tables 0
    Com_show_processlist 53
    Com_show_slave_hosts 0
    Com_show_slave_status 0
    Com_show_status 35
    Com_show_innodb_status 0
    Com_show_tables 6
    Com_show_variables 10
    Com_slave_start 0
    Com_slave_stop 0
    Com_truncate 0
    Com_unlock_tables 28
    Com_update 9811
    Connections 13864
    Created_tmp_disk_tables 21
    Created_tmp_tables 3543
    Created_tmp_files 0
    Delayed_insert_threads 0
    Delayed_writes 0
    Delayed_errors 0
    Flush_commands 1
    Handler_commit 0
    Handler_delete 5448
    Handler_read_first 3078
    Handler_read_key 6101795
    Handler_read_next 5884476
    Handler_read_prev 74383
    Handler_read_rnd 941039
    Handler_read_rnd_next 117421353
    Handler_rollback 0
    Handler_update 10718
    Handler_write 621778
    Key_blocks_used 15586
    Key_read_requests 13353340
    Key_reads 25518
    Key_write_requests 24125
    Key_writes 19331
    Max_used_connections 9
    Not_flushed_key_blocks 0
    Not_flushed_delayed_rows 0
    Open_tables 121
    Open_files 205
    Open_streams 0
    Opened_tables 127
    Questions 136152
    Qcache_queries_in_cache 898
    Qcache_inserts 41919
    Qcache_hits 48704
    Qcache_lowmem_prunes 0
    Qcache_not_cached 295
    Qcache_free_memory 27821824
    Qcache_free_blocks 352
    Qcache_total_blocks 2311
    Rpl_status NULL
    Select_full_join 7
    Select_full_range_join 0
    Select_range 7320
    Select_range_check 0
    Select_scan 11337
    Slave_open_temp_tables 0
    Slave_running OFF
    Slow_launch_threads 0
    Slow_queries 4
    Sort_merge_passes 0
    Sort_range 7927
    Sort_rows 97557695
    Sort_scan 7374
    Table_locks_immediate 119047
    Table_locks_waited 195
    Threads_cached 4
    Threads_created 10
    Threads_connected 6
    Threads_running 2
    Uptime 16049
    +--------------------------+------------+


    8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
    vB Only

    9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
    350-150
    and the cookie timeout is

    10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site


    In the Attachment

    11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

    KeepAlive ON
    MaxKeepAliveRequests 100
    KeepAliveTimeout 15
    MinSpareServers 8
    MaxSpareServers 13
    StartServers 5
    MaxClients 350

    12. what version of vB are you running ?
    3.0.7

    13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log

    NO


  • I was able to backup the DB via admincp with timeout several times and without any effect in the server ... but after upgrading I can't at all!
    Do you mean that my server doesn't need any optimization!
    and Is there any change in my.cnf and httpd.conf to reach the maximum performance for the server

    I will try your advice

    Thanks for your help Eva2000


  • You really need to run backups though the shell one way or another. Should be way less strenous than a php backup.

    Also move your attachments from the database to the file system if you already haven't done so.


  • there's ya problem admincp backup only works for small databases for large databases it probably will timeout.. you should use ssh telnet and mysqldump command to backup your database

    read a good guide at http://www.sitepoint.com/article/678


  • Ops
    sorry

    The cookie timeout is 900

    I'm backing up the database through admincp but the server load came very high
    the database large is 649.7 MB

    and there is the phpinfo (http://72.9.249.195/phpinfo.php)


  • cookie timeout is missing ? can you post url to phpinfo.php instead for future cases :)

    how are you backing up your forum database ? how large is the database in total ?


  • mysql stats, swap usage and my.cnf are all fine although AMD XP cpus aren't really made for web serving

    you could try reducing maxclients in httpd.conf from 350 to 150 and restart apache







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about I can't backup my database ... The server came very slow , Please add it free.