[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: mysqldump problem with large innodb tables...
From:       <pavlica () unidataz ! cz>
Date:       2007-06-19 9:08:06
Message-ID: 46779CF6.4080301 () unidataz ! cz
[Download RAW message or body]

Try to look for Lost connection error in MySQL manual and it can give 
your some hints like
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

Dusan


Hartleigh Burton napsal(a):
> Hi All,
>
> I have a database which is currently at ~10GB in it's test phase. It 
> is containing uncompressed audio and is expected to reach 1.5TB in no 
> time at all. I am just running some backup tests and I have been 
> having lots of problems creating an accurate backup.
>
> I have tried both MySQL Administrator & mysqldump, both applications 
> drop out on the same table, the table `trackdata` which contains ~9GB 
> worth of data. There is no single row any larger than 50MB, most 
> average around 40MB. Windows 2000 Server, MySQL v5.0.37-community-nt 
> and all tables are InnoDB.
>
> If anyone can help me out with this problem the assistance is greatly 
> appreciated. I have scoured google and various other sources and not 
> found much information that has been useful to me. I hope I have 
> enough info below... if more is required let me know.
>
> mysqldump example
>
> P:\>mysqldump -u username -p mraentertainment > mraentertainment.sql 
> --opt
> --verbose --max_allowed_packet=500M --hex-blob --single_transaction
> --net_buffer_length=100M
> Enter password: ******
> -- Connecting to localhost...
> -- Retrieving table structure for table albums...
> -- Sending SELECT query...
>
> ...
>
> -- Retrieving rows...
> -- Retrieving table structure for table trackdata...
> -- Sending SELECT query...
> -- Retrieving rows...
> mysqldump: Error 2013: Lost connection to MySQL server during query 
> when dumping
>  table `trackdata` at row: 1
>
>
> my.ini configuration file
>
> [client]
>
> port=3306
>
> [mysql]
>
> default-character-set=latin1
>
> [mysqld]
>
> log-bin=itd002-bin
> server-id=1
>
> port=3306
>
> wait_timeout=86400
>
> max_allowed_packet=100M
>
>
> basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
>
> datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
>
> default-character-set=latin1
>
> default-storage-engine=INNODB
>
> sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
>
> max_connections=100
>
> query_cache_size=0
>
> table_cache=256
>
> tmp_table_size=77M
>
> thread_cache_size=8
>
> #*** MyISAM Specific options
>
> myisam_max_sort_file_size=100G
>
> myisam_max_extra_sort_file_size=100G
>
> myisam_sort_buffer_size=154M
>
> key_buffer_size=130M
>
> read_buffer_size=64K
> read_rnd_buffer_size=256K
>
> sort_buffer_size=256K
>
> #skip-innodb
>
> innodb_additional_mem_pool_size=6M
>
> innodb_flush_log_at_trx_commit=1
>
> innodb_log_buffer_size=3M
>
> innodb_buffer_pool_size=252M
>
> innodb_log_file_size=126M
>
> innodb_thread_concurrency=8
>
>
>
>
>
> Regards,
> Hartleigh Burton
> Resident Geek
>
> MRA Entertainment Pty Ltd
> 5 Dividend St | Mansfield | QLD 4122 | Australia
> Phone: (07) 3457 5041
> Fax: (07) 3349 8806
> Mobile: 0421 646 978
>
> www.mraentertainment.com
>
>
>
> Internal Virus Database was built: Never
> Checked by MAC OSX... we don't get viruses!
>
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]