Category: mysql

  • How to follow repeatable steps that keep your MySQL databases tuned

    This article explains how MySQL settings can be optimized following a set of predetermined steps. The results are pretty reliable and we keep using this with a very high degree of success. This is something regularly done at Leanservers.

  • Revoking MySQL Permissions

    Usage: Example: See Also Granting MySQL Permissions Show Permission MySQL Commands

  • Dumping a mysql database excluding one or several tables

    If we need to dump a MySQL database and want to exclude table(s) we should use the option: –ignore-table=db_name.tbl_name Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times. This option also can be used to ignore views. Citation. […]

  • How to install MySQL Server on Debian Linux

    While installing MySQL Server it is always good to keep in mind that the logs and data folders will potentially have a big size. By default MySQL keeps them in the root mount point (i.e. ‘/’). That may cause your database server system disk to get full, which is never a good idea. This article […]

  • Having HAProxy check mysql status through a xinetd script

    HAProxy is able to load balance MySQL wonderfully. The main issue is how to make sure that the backend MySQL server to forward the request to is up and running (I mean not just to establish a connection to port 3306, I mean something more “complete”, that performs a little operation against the MySQL server). […]

  • Using ejabberd with MySQL native driver

    Get mysql driver (if ejabberd < 2.0.0) If you are using an ejabberd version previous to 2.0.0 (about end of 2007) then you need to put the MySQL .beam files somewhere in your Erlang path (possibly with your ejabberd .beam files): Mysql initialization Empty database creation: Schema creation: Check that the database structure has been […]

  • Showing MySQL Permissions

    Usage: Example: See Also Granting MySQL Permissions Show Permission MySQL Commands

  • Granting MySQL Permissions

    Usage Examples Notes WITH GRANT OPTION should only be added when really needed; this privilege allows a user to grant to others (more info). The location from where a user can connect (i.e. ‘username’@’server’) can be also a network if specified asĀ  ‘username’@’10.120.%.%’ See Also Showing MySQL Permissions GRANT Syntax