How to get size of a mysql database? Login as root and check the next query: SELECT table_schema "Database", ROUND(SUM(data_length + index_length)/1024/1024, 1) "Size (MB)" FROM information_schema.tables GROUP BY table_schema;SELECT …
Category: MySQL
Unable to export database in MySQL Workbench – delayed-insert error
In case you’re using MySQL Workbench for creating dumps please keep in mind that version 6.3.5 has one annoying bug. After update, the first time I tried do create dump, …
MyDumper – CentOS HowTo
Mydumper – MySQL backup tool created by Domas Mituzas and later supported by several other devs. The main benefits are multi-threaded and fast backups with almost no locking (if not …
How to clone MySQL database
Here is a way to create a duplicate of one database, with all its tables and their data Dump your source database into sql file # mysqldump -uroot -p production …
Slow InnoDB insert/update
If you’re migrating from MyISAM to InnoDB or you’re using MySQL 5.5.x or newer (InnoDB default engine) you’ll probably be disappointed with INSERT/UPDATE queries (with InnoDB tables). InnoDB is a …
Oracle MySQL yum repositories
If you’re using MySQL and you prefer yum and rpm, Oracle announced availability of Yum repositories for MySQL database and related products. Initial release is focused on EL6-based distros as …
Extra Packages for Enterprise Linux – EPEL HowTo
EPEL (Extra Packages for Enterprise Linux) is a volunteer-based community effort from the Fedora project to create a repository of high-quality add-on packages that complement the Fedora-based Red Hat Enterprise …
How to disable foreign key checks – MySQL
From time to time you’ll need to delete something from your database and when you try to do it, the MySQL will complain on foreign keys (beside the fact that …
MySQL DATE_FORMAT() letter representations
Here is a quick chart with MySQL DATE_FORMAT letter representation so you can format date how ever you want… Specifier Description %a Abbreviated weekday name (Sun..Sat) %b Abbreviated month name …
FreeRadius install howto (4) – populating tables
In the last article about FreeRadius (Here), I wrote about basic settings and now I’ll write something about inserting users into database (MySQL). The FreeRadius database schema contains several tables: …