phpbar.de logo

Mailinglisten-Archive

Tabelle voll - was nun ...

Tabelle voll - was nun ...

Sebastian Mendel lists at sebastianmendel.de
Die Jun 13 14:08:52 CEST 2006


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sebastian Mendel schrieb:

> " By default, MySQL creates MyISAM tables with an internal structure
> that allows a maximum size of about 4GB. You can check the maximum table
> size for a MyISAM  table with the SHOW TABLE STATUS statement or with
> myisamchk -dv tbl_name. See Section 13.5.4, ?SHOW Syntax?.
> 
> If you need a MyISAM table that is larger than 4GB and your operating
> system supports large files, the CREATE TABLE statement supports
> AVG_ROW_LENGTH and MAX_ROWS options. See Section 13.1.5, ?CREATE TABLE
> Syntax?. You can also change these options with ALTER TABLE to increase
> a table's maximum allowable size after the table has been created. See
> Section 13.1.2, ?ALTER TABLE Syntax?. "
> 
> http://dev.mysql.com/doc/refman/5.0/en/table-size.html

Und? Konntest du Tabelle ändern so das sie jetzt größer als 4GB werden kann?


- --
Sebastian Mendel

www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)

iD8DBQFEjqrUX/0lClpZDr4RAnovAJ9eFDutYAOBN+vfh9Sac1OFRuyYBQCfYPNC
HsqnLnP5lbLjNNlACVs3vRA=
=ObLw
-----END PGP SIGNATURE-----

-- 
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql 


php::bar PHP Wiki   -   Listenarchive