개발/DataBase
gsjava mysql marked as crashed and should be repaired.
철권
2021. 7. 19. 08:52
728x90
복구시도
repair table 테이블명;
에러 확인
check table 테이블명;
접속 가능한 수
MariaDB [(none)]> SHOW VARIABLES LIKE '%max_connection%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| extra_max_connections | 1 |
| max_connections | 151 |
+-----------------------+-------+
2 rows in set (0.003 sec)
현재 접속수
MariaDB [(none)]> SHOW STATUS LIKE 'Threads_connected';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 18 |
+-------------------+-------+
1 row in set (0.002 sec)
728x90
반응형