עשיתי פקודה להגדלת איחסון mysql ועכשיו זה לא עובד לי
-
לאחרונה קיבלתי שגיאות על ייבוא כמויות גדולות של נתונים (בגודל כולל של כ 2.5 GB), שאלתי את GPT מה לעשות, והוא נתן לי את הפקודה הבאה
ALTER TABLE stop_times MAX_ROWS=100000000 AVG_ROW_LENGTH=100;אבל מאחרי הפקודה mysql קרס לי ולא נדלק
בהרצתsystemctl status mysql.serviceהתגובה היא
mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Thu 2024-06-13 21:11:36 IDT; 3min 53s ago Process: 968703 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Process: 968711 ExecStart=/usr/sbin/mysqld (code=exited, status=3) Main PID: 968711 (code=exited, status=3) Status: "Server startup in progress" CPU: 489ms Jun 13 21:11:35 shmuel-sh systemd[1]: mysql.service: Failed with result 'exit-code'. Jun 13 21:11:35 shmuel-sh systemd[1]: Failed to start MySQL Community Server. Jun 13 21:11:36 shmuel-sh systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5. Jun 13 21:11:36 shmuel-sh systemd[1]: Stopped MySQL Community Server. Jun 13 21:11:36 shmuel-sh systemd[1]: mysql.service: Start request repeated too quickly. Jun 13 21:11:36 shmuel-sh systemd[1]: mysql.service: Failed with result 'exit-code'. Jun 13 21:11:36 shmuel-sh systemd[1]: Failed to start MySQL Community Server. Jun 13 21:11:39 shmuel-sh systemd[1]: mysql.service: Start request repeated too quickly. Jun 13 21:11:39 shmuel-sh systemd[1]: mysql.service: Failed with result 'exit-code'. Jun 13 21:11:39 shmuel-sh systemd[1]: Failed to start MySQL Community Server.ובהרצת
journalctl -xeu mysql.serviceהתגובה היא
Jun 13 21:11:36 shmuel-sh systemd[1]: mysql.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'. Jun 13 21:11:36 shmuel-sh systemd[1]: Failed to start MySQL Community Server. ░░ Subject: A start job for unit mysql.service has failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A start job for unit mysql.service has finished with a failure. ░░ ░░ The job identifier is 252819 and the job result is failed. Jun 13 21:11:39 shmuel-sh systemd[1]: mysql.service: Start request repeated too quickly. Jun 13 21:11:39 shmuel-sh systemd[1]: mysql.service: Failed with result 'exit-code'. ░░ Subject: Unit failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'. Jun 13 21:11:39 shmuel-sh systemd[1]: Failed to start MySQL Community Server. ░░ Subject: A start job for unit mysql.service has failed ░░ Defined-By: systemd ░░ Support: http://www.ubuntu.com/support ░░ ░░ A start job for unit mysql.service has finished with a failure. ░░ ░░ The job identifier is 252901 and the job result is failed.אשמח לעזרה