Showing entries 1 to 3
Displaying posts with tag: Guides (reset)
How to Manage MySQL Databases and Users from the Command Line

MySQL is the most popular database server used by websites to store their important data. In addition to using phpMyAdmin ...

Read More

The post How to Manage MySQL Databases and Users from the Command Line appeared first on RoseHosting.

10 Useful mysqladmin Commands for Database Administration

In this blog post, we will show you ten useful mysqladmin commands for database administration. Mysqladmin is a client for ...

Read More

The post 10 Useful mysqladmin Commands for Database Administration appeared first on RoseHosting.

Why does Vitess recommend 250GB per MySQL server?

Vitess has an opinionated approach to database scalability. Some of those opinions have minimal controversy such as how durability should be provided via replication, but the one I find interesting is the 250GB per MySQL server recommendation. Is this a physical MySQL Limit? # In short: no. By “physical limit” I mean is there a file format restriction that says databases can not be greater than 250GB? The physical limit for InnoDB is 64TB per tablespace, and in the default configuration each table is its own tablespace.

Showing entries 1 to 3