On Sun, May 13, 2001 at 06:09:12PM +0300, Heikki Tuuri wrote:
Suggested improvements would be the addition of COALESCE TABLESPACE
Do you mean reorganization and compaction of a tablespace? The way to
do it is to dump and reload all tables in the tablespace.
During my tests I've
Dan,
At 03:02 PM 5/11/01 -0500, you wrote:
In the last episode (May 11), Heikki Tuuri said:
Dan Nelson wrote:
No ANALYZE TABLE - correct key and subkey cardinality counts work
wonders for complex queries (probably easy to add).
InnoDB does the estimation of cardinalities required by
Hi!
In the last episode (May 10), Eric J. Schwertfeger said:
Also, my initial testing shows that INNOBASE tables are even faster
than MyISAM, at least for insertions, though the same tupples in a
similar table seem to take up more room. Aside from the restrictions
InnoDB tables are faster
In the last episode (May 11), Heikki Tuuri said:
Dan Nelson wrote:
No ANALYZE TABLE - correct key and subkey cardinality counts work
wonders for complex queries (probably easy to add).
InnoDB does the estimation of cardinalities required by the MySQL
optimizer. But the counts are not
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and I've
run into something unusual.
Basically, when I create a table with type = innobase then do a stat on
the table, it returns a table type of MyISAM. I've verified that this is
what the table really is by looking for the
On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
I've run into something unusual.
Basically, when I create a table with type = innobase then do a
stat on the table, it returns a table type of MyISAM.
On Thu, 10 May 2001, Jeremy Zawodny wrote:
On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
I've run into something unusual.
Basically, when I create a table with type = innobase then do a
On Thu, 10 May 2001, Dan Nelson wrote:
The first two are as expected, the third isn't. However, this is
with a mysqld that was configured with --with-innobase. So why is
have_innodb=NO?
The name of the option changed in 3.23.37. Use --with-innodb instead.
Never trust printed
In the last episode (May 10), Eric J. Schwertfeger said:
Also, my initial testing shows that INNOBASE tables are even faster
than MyISAM, at least for insertions, though the same tupples in a
similar table seem to take up more room. Aside from the restrictions
mentioned in 8.7.4 of the