-
Install and setup MySQL on Debian
-
by
Pierre-Yves Landuré
—
published
Jul 18, 2011
—
last modified
Nov 11, 2017 09:37
—
filed under:
Debian 5.0 Lenny,
Debian 6.0 Squeeze,
Ubuntu 10.04 Lucid Lynx,
Ubuntu 11.04 Natty Narwhal,
mysql
MySQL is a lightweight database management system. It is particularly suited to manage simple databases storing a large number of records. This is the preferred database management system for Web applications.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Ease MySQL server administration with mysql-tools
-
by
Pierre-Yves Landuré
—
published
May 30, 2012
—
last modified
Jul 24, 2016 10:40
mysql-tools is a script written with the intent to ease and automate the daily administration tasks of a MySQL server. This howto describe howto to install and use it.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Setup a regular analyze and optimization / defragmentation of MySQL tables
-
by
Pierre-Yves Landuré
—
published
May 24, 2012
—
last modified
Nov 14, 2017 01:39
With the flow of inserts and deletes, the MySQL tables performances can drop. Regularly optimize and analyze MySQL tables allow to rebuild the indexes and limit the disk space used by MySQL on the server.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Optimize MySQL on Debian
-
by
Pierre-Yves Landuré
—
published
Apr 25, 2012
—
last modified
Nov 11, 2017 03:07
The performances of a MySQL server are greatly dependant of the hardware where it is hosted. The hard drive latency, the available memory and the processor computation power are the main parameters of the equation. This howto help you to adjust MySQL server settings to the hardware where it is hosted.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Install the database firewall GreenSQL on Debian
-
by
Pierre-Yves Landuré
—
published
Jul 18, 2011
—
last modified
Feb 08, 2014 06:42
—
filed under:
Debian 6.0 Squeeze,
security,
postgresql,
mysql
GreenSQL is a proxy server preventing SQL injections. Once inserted between the MySQL server and the application using a database, it protect the database from malicious attacks. This howto ease its installation on Debian GNU/Linux.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Install the Pinba PHP extension on Debian
-
by
Pierre-Yves Landuré
—
published
Jun 21, 2013
—
last modified
Aug 16, 2018 11:03
Pinba is a PHP extension gathering performance informations on the web applications hosted on the server using it.
Located in
Debian GNU/Linux
/
Servers
/
PHP
-
Administration
-
by
Pierre-Yves Landuré
—
published
Jul 21, 2013
—
last modified
Jul 21, 2013 08:33
Web applications easing system administration.
Located in
Debian GNU/Linux
/
Web applications
-
Install PHPMyAdmin on Debian
-
by
Pierre-Yves Landuré
—
published
Jul 21, 2013
—
last modified
Nov 11, 2017 09:29
PHPMyAdmin is a Web application easing MySQL server administration. This howto helps its install on Debian.
Located in
Debian GNU/Linux
/
Web applications
/
Administration
-
MySQL tips and tricks
-
by
Pierre-Yves Landuré
—
published
Jan 07, 2013
—
last modified
Oct 25, 2015 06:05
Various tips on the use and debugging of MySQL.
Located in
Debian GNU/Linux
/
Servers
/
MySQL
-
Install Pinba MySQL engine on Debian
-
by
Pierre-Yves Landuré
—
published
Jun 21, 2013
—
last modified
Jan 12, 2019 06:47
Pinba is a MySQL engine engineered to collect statistical data. Its main usage is to collect performance informations on PHP applications.
Located in
Debian GNU/Linux
/
Servers
/
MySQL