|
|
Posted by Rik Wasmus on 02/01/08 16:07
On Wed, 30 Jan 2008 05:02:31 +0100, Sudhakar <sudhakararaog@gmail.com> =
wrote:
> my question is about "SHOW TABLE STATUS LIKE 'tablename'";
Which is MySQL, crossposted, f'upped to there.
> 1.
> echo "The number of allocated but unused bytes: ".$array['Data_free'];=
> =3D This does not display any number at all.
http://bugs.mysql.com/bug.php?id=3D32440
> 2.
> echo "The maximum length of the data file. This is the total number of=
> bytes of data that can be stored in the table : " .
> $array['Max_data_length'];
>
> displays 4294967295 which comes to 3.99 GB
>
> Does this mean that the Entire capacity for the MySql Database that is=
> installed on the unix server including all the
> a) Tables and from all the Databases is 3.99 GB
>
> Because i have used this SHOW TABLE STATUS LIKE 'tablename' for all
> the tables i have have in 3 databases that i have, in each case the
> value displayed for
> echo $array['Max_data_length']; is 4294967295 which is 3.99 GB so i am=
> assuming the total capacity for "MySql Database VERSION 3.23.58" that
> is installed on the unix server can hold a maximum of 3.99 GB of data
> each time data is inserted into the various tables which are in
> different databases
I'll leave this for more MySQL savvy users at comp.databases.mysql..
> 3.
> echo $array['Data_length'] =3D The value displayed is ex=3D 36872 for
> this, does it mean that 36872 number of bytes have been consumed by a
> particular table at a particular time, everytime an insert statement
> had been executed
No idea what this means.
> 4.
> Also i have 2 databases and each have couple of tables so i guess i
> will have to use the following statement 2 times
>
> mysql_select_db("database1", $conn);
> mysql_select_db("database2", $conn);
Or just mysql_query('USE database2'); will do the trick.
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|