database-administration

MySQL - How to convert data_length to actual size?

I am trying to optimize the database buffer size, but i am finding the SHOW TABLE STATUS rather cryptic. I know that the data length is "165719261184"- how do i convert that into actual megabytes? ...

Very large database, very small portion most being retrieved in real time

Hi folks, I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would very much prefer to keep them around because some features require them. Some of it (namely some tables, and some identifiable ...

Web frameworks with scaffolding and/or web based DB administration tools?

I'm looking for web app frameworks and/or database administration tools, either popular and unpopular, written in any language, for any relational database. In short, I'm looking for web accessible CRUD front-ends with minimal programming effort. For example: phpMyAdmin (MySQL administration tool) Ruby on Rails (web app framework wit...

Are there any pitfalls with having multiple MySQL databases on 1 server node?

I want to prepare my database for sharding in the future. But right now I only need 1 node. What I'd like to do is to shard the database into virtual shards, say 12 shards, and put all of them onto the same server node for now. And when I need to scale out, I could just then get a 2nd server and move 6 of the 12 virtual shard onto the ...

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a column to all those tables. Is there a way to do that programmatically? Something like: # pseudo code for i in range(n): tablenam...