Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    Chicago IL
    Posts
    573

    Need to increase tranfer size to mySQL

    I want to temporally increase the amount transferred to a mySQL DB on one of my servers to allow a customer to upload a large 200 meg DB with out timing out. Here are my present settings. Basically wondering what in the config would have to be altered.


    # The MySQL server
    [mysqld]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 384M
    max_allowed_packet = 32M
    table_cache = 512
    sort_buffer_size = 2M
    read_buffer_size = 2M
    myisam_sort_buffer_size = 64M
    thread_cache = 8
    query_cache_size = 32M
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8

    Thanks in advance.
    WebzPro.com Hosting Solutions Since 2004
    Shared/Reseller Hosting - Semi-Dedicated
    24/7 Support Help Desk
    - LiteSpeed Powered Servers CPanel/WHM

  2. #2
    Join Date
    Jun 2004
    Location
    SF, CA
    Posts
    79
    What is your upload mechanism? e.g. if it is php then there is also a setting in php.ini that sets a max upload limit.

  3. #3
    Join Date
    Dec 2003
    Location
    New Zealand
    Posts
    1,265
    a 200mb mysql DB is pretty big, I have seen bigger...

  4. #4
    Join Date
    Dec 2003
    Location
    UK
    Posts
    658
    Why not get the customer to ftp the SQL file then you can import it locally rather than risk timeouts during import ?

  5. #5
    Join Date
    Mar 2003
    Location
    /root
    Posts
    23,990
    I never tried it yet but you can try http://www.ozerov.de/bigdump.php

    Specially 4 U
    Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
    JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
    Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •