Can I estimate the row count of a large mysql table using the disk space?

Howdy, Can I ask a Cassandra data model question here about time series data and timeline query? Materialized Views or Index CF, which way is better to handle 20 single column indexes in one table? We have a book table with 20 columns, 300 million rows...

I have a single InnoDB table growing about 800 MB per day with user-to-user interaction data, therefore they are small inserts all day long. Today it has ~100GB of data + indicies. One day I will run out of storage in the current architecture. Most of...

I would like to charge the users of my SaaS, by the amount of disk space that their data stored on the MySQL server is taking. There is only ione database and it's a system where all the tables contain shared data belonging to all the clients and each...

Hi, Im trying to create a table in mysql using variable $signupemail as table name. Here is my code mysql_select_db("profiles",$connect); mysql_query("CREATE TABLE ".$signupemail." (FirstName VARCHAR(30), LastName VARCHAR(30...

I was considering following approach: Create a table with new schema in the same database Replicate all write operations of old table on this table using bin logs (Note that old table is still serving live traffic) Once new table has caught up,  rename...

I have some code like this: $table = 'table'; $stmt = $mysqli->prepare("CREATE TABLE $table ( ... ") or die($mysqli->error); if ($stmt === FALSE) { ...show more

Using the 'product_id' in Table A, I would like to check if a product exists in Table B. If the product does exist, I want to replace the 'product_price' in Table B with the one from Table A. I am currently using a 'while' loop in PHP, checking each...

I have the following line in my plugin to remove transients from the database option table. $wpdb->query( "DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient%_feed_%')" ); However, it won't work with sites which set a prefix...