两个获取数据库使用的大小的方法

得到的结果是以字节为单位，除1024为K，除1048576为M。

1.

		public function getDBSize($dbName,$tblPrefix=null){
			$sql = "SHOW TABLE STATUS FROM ".$dbName;
			if($tblPrefix != null){
				$sql .= "LIKE '$tblPrefix%'";
			}
			$result = $this->mysqli->query($sql);
			$size = 0;
			while (($row = $result->fetch_assoc())!=false){
				$size += $row["Data_length"]+$row["Index_length"];
			}
			return $size;
		}

2.

		public function getDBSize2($dbName){
			$sql = "SELECT sum(DATA_LENGTH)+sum(INDEX_LENGTH) as db_size
			      FROM information_schema.TABLES where TABLE_SCHEMA='$dbName'";
			$result = $this->mysqli->query($sql);
			$size = 0;
			if (($row = $result->fetch_assoc())!=false){
				$size = $row["db_size"];
			}
			return $size;
		}