getting the satabase space

[Andresss]

hi guys, does anybody know how to get a database space and a certain table in it?

[Jorge Solis]

Which language, which database.

Jorge

[Andresss]

mysql with php...

[Jorge Solis]

You can list tables on a database: http://es2.php.net/manual/en/function.mysql-list-tables.php. Check also on left side all the functions available in mysql API

Jorge

[Andresss]

i mean the space that the database is using expressed in bytes and the space that a table is unsing expressed in bytes as well...

[Jorge Solis]

Check also on left side all the functions available in mysql API

Can you see it there?

Jorge

[Andresss]

sorry.. yep it was there.. here is what i found:

function mydbsize($filesize){
$bytes = array('KB', 'KB', 'MB', 'GB', 'TB'); # values are always displayed
        if ($filesize < 1024) $filesize = 1; # in at least kilobytes.
        for ($i = 0; $filesize > 1024; $i++) $filesize /= 1024;
        $file_size_info['size'] = ceil($filesize);
        $file_size_info['type'] = $bytes[$i];
        return $file_size_info;
}

mysql_select_db ($this->dbname);
                         $rows = mysql_query("SHOW TABLE STATUS");
                         $dbsize = 0;
                         while ($row = mysql_fetch_array($rows)) {
                         $dbsize += $row['Data_length'] + $row['Index_length'];
                         }
mydbsize($dbsize);

i would like to add it to an amfphp function... is ti possible?.. my first tests are not very good...

[Jorge Solis]

Anything that you can do with PHP can be done in amfphp.

Jorge

[Andresss]

hey hi guys i have this problem... i want to return my db space but i dont know how to do it, this is my code:

Code: [Select]

     function chSett(){
          function file_size_info($filesize) {
        $bytes = array('KB', 'KB', 'MB', 'GB', 'TB'); # values are always displayed
        if ($filesize < 1024) $filesize = 1; # in at least kilobytes.
        for ($i = 0; $filesize > 1024; $i++) $filesize /= 1024;
        $file_size_info['size'] = ceil($filesize);
        $file_size_info['type'] = $bytes[$i];
        return $file_size_info;
        }
        $rows = mysql_query("SHOW TABLE STATUS");
                $dbsize = 0;
              while ($row = mysql_fetch_array($rows)) {
              $dbsize += $row['Data_length'] + $row['Index_length'];
              }
        $dbsize = file_size_info($dbsize);
        $andy="el mejor";
        $myquery= mysql_query("select ttpp.tPeriods, enesettings.tPeriod, enesettings.tempo, enesettings.tempow, enesettings.disponible from enesettings join ttpp");
        return "$myquery {$dbsize['size']} {$dbsize['type']}";

      }
but it outputs something like:  Result: "Resource id #20 52 KB"

[Jorge Solis]

Your return:

return "$myquery {$dbsize['size']} {$dbsize['type']}";

The output:

 Result: "Resource id #20 52 KB"

Only the size?

return "$myquery {$dbsize['size']}";

Jorge

[Andresss]

well i wanted to output a query too, thats why i put that query there... do u think it would be better if i call them separate of each other?

[Jorge Solis]

output a query too

Don't understand

Jorge

[Andresss]

$myquery= mysql_query("select ttpp.tPeriods, enesettings.tPeriod, enesettings.tempo, enesettings.tempow, enesettings.disponible from enesettings join ttpp");    <-------- the query

return "$myquery {$dbsize['size']} {$dbsize['type']}";
               |
               |
            the quey is return with the space, i think dats why it outputs: Resource id #20 52 KB"

[Jorge Solis]

If you want to return the result of your query, use:

return $myquery

If you don't know how to walk a remoting Recordset object, check http://www.flash-db.com/Tutorials/loading/loadingData.php?page=6

Jorge