Hi, I made a java program where much database queries are processed in MySQL. After some time running, I got an error message:
How to fix java.io.EOFException: Can not read response from server for MySQL
H
How to find a column name in all tables in MySQL
H
Sometimes, it could be handy to know in which tables a certain column name is specified. To do so, use the query below.
select distinct table_name
from information_schema.columns
where column_name in ('columnA','ColumnB')
and table_schema = 'YourDatabase';
Note: you need to fill in your own column names and table_schema. Enjoy!
How to optimize MySQL
H
On , you find two interesting tools for MySQL. A configuration wizard that recommends a MySQL configuration based on your server settings. There is also a query analyzer tool that analyzes your SQL query and provides feedback. To use the tools, you need to log in, but they are free! MySQL settings optimizer The MySQL optimizer will ask you to fill in your server configuration and database...