ursitesion
  • Member for 8 years, 1 month
  • Last seen more than a month ago
How to determine if open_table_cache is set properly?
2 votes

You have not mentioned but looks like you are using MySQL 5.6 version. Opened_tables is a counter variable which stores the value of all tables opened by queries since start of the MySQL service. ...

View answer
Unable to start mysql
2 votes

I found my answer and I want to laugh on myself... What a silly mistake I did! Sharing this solution so that others can save their time. I just prefix sudo command in the below statement and mysql ...

View answer
Trying to recover/import/transfer database from MySQL data dir
0 votes

How can I find the MySQL version from my old data directory? $mysql> select version(); Before taking the backup, you should know few things: 1. Default storage engine: select * from ...

View answer
Large database - too much time spent opening and closing tables
0 votes

You have 90,000 tables in your DB server. Increasing RAM certainly helps you to overcome from this situation. Using Disks, swapping and open/close tables are negative points for DB performance. When ...

View answer