On May 6, 2010, at 1:25 PM, Alexandre Almeida wrote:
Paul,
I was wondering. Can you say that PBXT works much better with fixed
length rows?
PBXT works well with both fixed and variable length rows. But fix
length records will not generally not require any tuning.
Alex
Em 06/05/20
Hi Alex,
No idea what is happening here. I would have to investigate to find
out. Please contact me directly. Maybe it would be possible for me to
get access to your test machine. Then I could take a look.
Best regards,
Paul
On May 6, 2010, at 8:52 PM, Alexandre Almeida wrote:
Paul,
Paul,
Do you any clue why I get this during select?
|
69305170
|
1 |
|
69306030
|
Paul,
I was wondering. Can you say that PBXT works much better with fixed
length rows?
Alex
<>
Em 06/05/2010, às 03:32, Paul McCullagh escreveu:
Hi Monty,
On May 5, 2010, at 7:02 PM, Michael Widenius wrote:
"Paul" == Paul McCullagh writes:
Paul> PBXT can help you out with this.
Hi Monty,
On May 5, 2010, at 7:02 PM, Michael Widenius wrote:
"Paul" == Paul McCullagh writes:
Paul> PBXT can help you out with this. Do the following:
Paul> (1) Load the telpbxt table with a few 1000 rows (or use
telpbxt2,
Paul> since telpbxt already has too many rows in it).
Paul> (2
Hi!
> "Paul" == Paul McCullagh writes:
Paul> PBXT can help you out with this. Do the following:
Paul> (1) Load the telpbxt table with a few 1000 rows (or use telpbxt2,
Paul> since telpbxt already has too many rows in it).
Paul> (2) In mysql client enter: CHECK TABLE telpbxt2; (note: do
Hi Paul,
Thanks for your valuable explanation.
Of course that I will apply all recommendation first, but, I will
take a deep look into the like you sent me.
As soon as I get a chance today I will apply the adjustments, and
make it visible here.
Thanks,
Alex
<>
Em 05/
Hi Alexandre,
As Arjen says, PBXT is unconventional, and sometimes requires tuning,
as I explained in my last conference talk: http://www.primebase.org/download/pbxt-uc-2010.pdf
.
While tuning may be necessary, it may be worth it for the results we
can achieve.
But I don't expect you to
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 othe
Hi Arjen,
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?
So, I going to download docs and try to adjust buffers, this & that
to get better performance.
Alex
<>
Em
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 s
Hi Guys,
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:
create table telpbxt like telinno;
Query OK, 0
12 matches
Mail list logo
