MySQL client does not use the port parameter
It will happen if you use localhost as the server address. The client will then use the Unix sockets. Use 127.0.0.1 instead. This issue is common when using SSL tunnels.
Get the MySQL database schema using SQL
A complete database schema can be retrieved using the following MySQL statement from the information\_schema database:
Move and secure the MySQL data directory
By default, the data directory of MySQL is /var/lib/mysql. This can be a security issue, especially on a laptop. If your home directory is encrypted, you can easily secure you MySQL data. Backup you data before using this information. Read the procedure until the end before doing anything.
First, follow these steps to move the data directory of MySQL.
Tomcat and MySQL benchmarks
Benkmarks made using a Tomcat and a MySQL database. These figures are provided to give you an idea of the performance you should expect.
The tests were done in the following conditions:
Tags
- All
- 3D Printing
- ABS
- Android
- apache
- Arduino
- ARPI600
- ASUS
- automation
- Battlefield
- Blogroll
- Certificate
- Chrome
- Cree
- Cura
- Database
- Debian
- Eclipse
- Electronic Component
- ESP8266
- Firewall
- Games
- GCode
- General
- GIT
- GitHub
- GO2NFC
- Handbrake
- Hardware
- Internet of Things
- IoT
- Java Applets
- Linux
- MAC OS X
- Management
- Mantis
- Marlin
- memcache
- Mountain Lion
- MySQL
- Networking
- NodeMCU
- NVIM
- object
- Octoprint
- openssl
- Photos
- PHP
- phpMyAdmin
- PN532
- postfix
- Prusa Mendel
- Ralink
- Raspberry PI
- RaspberryPI
- Raspbian
- Router
- RT5572
- SSH
- STM32
- Tomcat
- Trinket
- Ubuntu
- Ubuntu 11.04
- Ubuntu 11.10
- Ubuntu 12.04
- Ubuntu 14.04
- Ubuntu 15.04
- Ubuntu 20.04
- Unity
- Unix
- Video
- Virtual Box
- Wheezy
- WiFI
- Windows
- Windows 8
- Wink
- WordPress