Hi Alexandre On 05/05/2010, at 1:15 PM, Alexandre Almeida wrote:
Thanks for your intervention.
I don't doubt that. But, 5 hours? This load in a innodb takes no more than 40 min. Can I assume that default is useless?
Not necessarily, depends on actual vs predicted row size, and other factors. For anything production/performance, technically any default config is useless, except for MySQL in general and MyISAM they work remarkably well for a good long time - even InnoDB. We have clients that run on InnoDB with default buffer pool size etc.... I think we can agree that's no good.
So, I going to download docs and try to adjust buffers, this & that to get better performance.
Excellent. It is a *very* different engine, so presuming anything is not wise (or fair). Regards, Arjen.
Em 04/05/2010, às 20:30, Arjen Lentz escreveu:
Hi Alexandre
On 05/05/2010, at 4:55 AM, Alexandre Almeida wrote:
I am setting an enviroment with MariaDB + PBXT, but, I am pretty much disappointed.
Do you know if this time (see below) makes sense?
Five hours to create a PBXT table with 10mio records... It's too much!!! See my steps:
PBXT, like any other storage engine, requires some tuning for production performance.
Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
-- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org