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?
...
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 ...
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...
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 ...
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...