Did you change innodb_buffer_pool_size first?
Did you make sure all the tables had PRIMARY KEYs?
I'll bet the next dump+reload will be faster -- because they will then be
dumped _and_ reloaded in the same order.
Etc.
That is, your test case involved several things other than just "load" speed.
>
On Tue, 20 Nov 2012, Ricardo Barbosa wrote:
Hi all.
I'm trying to do a recover on a table for a client, with the following message
root@falcon:~# mysqldump -u root -pXXX database
-- MySQL dump 10.13 Distrib 5.1.30, for pc-linux-gnu (i686)
--
-- Host: localhost Database: database
-- --
2012/11/19 05:05 +0100, Mogens Melander
I found an article on:
http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab
Describing how to do the dynamic generation of SQL statements.
And I was inspired to do some such thing to one of my views.
This view
On Mon, November 19, 2012 17:02, Shawn Green wrote:
> On 11/19/2012 9:02 AM, Mogens Melander wrote:
>>
>> On Mon, November 19, 2012 13:49, Jan Steinman wrote:
From: "Mogens Melander"
So, I got a little further with my problem. I found an article
on:
http://stackoverf
