Results 1 to 5 of 5
-
05-03-2005, 01:24 PM #1Web Hosting Master
- 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
-
05-03-2005, 06:21 PM #2Junior Guru Wannabe
- 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.
-
05-03-2005, 06:53 PM #3Hosting Systems Specialist
- Join Date
- Dec 2003
- Location
- New Zealand
- Posts
- 1,265
a 200mb mysql DB is pretty big, I have seen bigger...
-
05-04-2005, 06:13 AM #4Web Hosting Master
- 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 ?
Alex Monaghan - Monaghan Consultants Ltd
Web hosting, ADSL, IT & Database consultancy
Custom Web hosting Linux/cPanel (UK or USA servers) or Windows/DotNetPanel (UK only). Reseller accounts also available
-
05-04-2005, 07:54 AM #5The Linux Specialist
- 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