<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-11933937.post6593069220704055537..comments</id><updated>2010-06-07T16:58:44.384-05:00</updated><category term='pattern'/><category term='.net'/><category term='agile'/><category term='mysql'/><category term='ruby/rails'/><category term='humor'/><category term='efficiency'/><title type='text'>Comments on STEPHEN CHU . com: Speed up your MySQL data load</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://www.stephenchu.com/feeds/6593069220704055537/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default'/><link rel='alternate' type='text/html' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html'/><author><name>Stephen Chu</name><uri>http://www.blogger.com/profile/07181510921622947661</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-11933937.post-3938961703125853928</id><published>2010-06-07T16:58:44.379-05:00</published><updated>2010-06-07T16:58:44.379-05:00</updated><title type='text'>I&amp;#39;ve been waiting since 2008 for a sweet updat...</title><content type='html'>I&amp;#39;ve been waiting since 2008 for a sweet update.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/3938961703125853928'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/3938961703125853928'/><link rel='alternate' type='text/html' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html?showComment=1275947924379#c3938961703125853928' title=''/><author><name>Mike</name><uri>http://www.blogger.com/profile/09252692713715260282</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='http://lh6.google.co.uk/image/maleksiuk/RheLAVuB-7I/AAAAAAAAADQ/GLv73nm-zvo/s288/Image099.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html' ref='tag:blogger.com,1999:blog-11933937.post-6593069220704055537' source='http://www.blogger.com/feeds/11933937/posts/default/6593069220704055537' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-821946712'/></entry><entry><id>tag:blogger.com,1999:blog-11933937.post-8273005970148000718</id><published>2009-06-09T13:54:31.020-05:00</published><updated>2009-06-09T13:54:31.020-05:00</updated><title type='text'>is this the brain?</title><content type='html'>is this the brain?</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/8273005970148000718'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/8273005970148000718'/><link rel='alternate' type='text/html' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html?showComment=1244573671020#c8273005970148000718' title=''/><author><name>Peter</name><uri>http://www.blogger.com/profile/08657762656083540454</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html' ref='tag:blogger.com,1999:blog-11933937.post-6593069220704055537' source='http://www.blogger.com/feeds/11933937/posts/default/6593069220704055537' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1909214846'/></entry><entry><id>tag:blogger.com,1999:blog-11933937.post-3425175953396071872</id><published>2009-02-10T13:25:00.000-06:00</published><updated>2009-02-10T13:25:00.000-06:00</updated><title type='text'>Thanks for the post. I was doing some research on ...</title><content type='html'>Thanks for the post. I was doing some research on some of these variables that you are setting. According to this post (http://www.mysqlperformanceblog.com/2006/06/08/mysql-server-variables-sql-layer-or-storage-engine-specific/)&lt;BR/&gt;, it seems that bulk_insert_buffer_size is only relevant to MyISAM tables.&lt;BR/&gt;&lt;BR/&gt;Also, I noticed that the MySQL site lists typical sizes for innodb_additional_mem_pool_size and innodb_log_buffer_size as about 8M. Did you try this ? It is quite a bit smaller than your setting of 256M. Just curious if you noticed a difference.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/3425175953396071872'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/3425175953396071872'/><link rel='alternate' type='text/html' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html?showComment=1234293900000#c3425175953396071872' title=''/><author><name>qug</name><uri>http://www.blogger.com/profile/11530158806092021257</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html' ref='tag:blogger.com,1999:blog-11933937.post-6593069220704055537' source='http://www.blogger.com/feeds/11933937/posts/default/6593069220704055537' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-269021559'/></entry><entry><id>tag:blogger.com,1999:blog-11933937.post-7309614648307412015</id><published>2009-01-28T23:48:00.000-06:00</published><updated>2009-01-28T23:48:00.000-06:00</updated><title type='text'>thanks for the tips.</title><content type='html'>thanks for the tips.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/7309614648307412015'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/11933937/6593069220704055537/comments/default/7309614648307412015'/><link rel='alternate' type='text/html' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html?showComment=1233208080000#c7309614648307412015' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.stephenchu.com/2008/12/speed-up-your-mysql-data-load.html' ref='tag:blogger.com,1999:blog-11933937.post-6593069220704055537' source='http://www.blogger.com/feeds/11933937/posts/default/6593069220704055537' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1089725339'/></entry></feed>
