MySQL shutsdown after 10-20 mins

All MAMP discussions around troubleshooting and anything related to MAMP. Be as detailed as possible here when posting an issue.
Post Reply
Posts: 1
Joined: Sun Oct 15, 2023 3:37 pm

MySQL shutsdown after 10-20 mins

Post by type11 »

Hello all and thanks in advance for your help this one is driving me nuts. I am on MAMP Pro 6.8.1 on Apple Silicon M2 Mini. I have a VERY simple php site with a very simple MYSQL site (1 table) that I use at our business to control an AV system I wrote. This worked fine in the past on some intel Mac Minis I had but I just switched them out for a couple M2s at both of our locations.

What I am seeing at one location (which honestly is configured exactly like the other that does not show this issue I keep comparing the config trying to find something...) is that MySQL will shutdown randomly (or seemingly) after 10-30 mins. MAMP Pro app just hangs when this happens until I force quit it and then manually restart everything. There is nothing interesting in the Apache or PHP logs and really nothing in the mysqld log either other than it just starts shutting down for no reason I can tell. I have increased the logging on the error log to 3 and I also enabled the access log to look at that but nothing stands out and the startup looks the same in the log as the other location that works. I also just totally uninstalled MAMP Pro got rid of all the configs and the DB and redid all of it and yet it still keeps happening. I have increased the memory and the threads in the config (but again this is a very simple DB with very very little traffic). Below is the log thanks for any help I am at a loss at this point. IN the logs you can see it start up ok and then 13 mins later just start to shutdown (2023-10-15T04:11:49.399136Z 0 [Note] Giving 0 client threads a chance to die gracefully
) and I really don't get any more info about where a signal or command came to start it.


Thanks again

2023-10-15T03:58:13.6NZ mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error.log'.
2023-10-15T03:58:13.6NZ mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql57
2023-10-15T03:58:15.972321Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-10-15T03:58:15.990883Z 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.7.39) starting as process 744 ...
2023-10-15T03:58:16.127435Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ is case insensitive
2023-10-15T03:58:16.176832Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-10-15T03:58:16.176867Z 0 [Note] InnoDB: Uses event mutexes
2023-10-15T03:58:16.176879Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-10-15T03:58:16.176887Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-15T03:58:16.176911Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2023-10-15T03:58:16.182270Z 0 [Note] InnoDB: Number of pools: 1
2023-10-15T03:58:16.214099Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2023-10-15T03:58:16.215526Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-10-15T03:58:16.251153Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-15T03:58:16.335484Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-10-15T03:58:16.431553Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-15T03:58:16.431708Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-15T03:58:16.436269Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-10-15T03:58:16.437046Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-10-15T03:58:16.437071Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-10-15T03:58:16.437442Z 0 [Note] InnoDB: 5.7.39 started; log sequence number 2695626
2023-10-15T03:58:16.437543Z 0 [Note] InnoDB: Loading buffer pool(s) from /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2023-10-15T03:58:16.444621Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-10-15T03:58:16.488259Z 0 [Note] InnoDB: Buffer pool(s) load completed at 231014 22:58:16
2023-10-15T03:58:16.533651Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-10-15T03:58:16.533703Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-10-15T03:58:16.533718Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-10-15T03:58:16.533729Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-10-15T03:58:16.537328Z 0 [Warning] CA certificate ca.pem is self signed.
2023-10-15T03:58:16.537924Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-10-15T03:58:16.538611Z 0 [Note] Server hostname (bind-address): ''; port: 8889
2023-10-15T03:58:16.538638Z 0 [Note] - '' resolves to '';
2023-10-15T03:58:16.538707Z 0 [Note] Server socket created on IP: ''.
2023-10-15T03:58:16.539582Z 0 [Warning] Insecure configuration for --pid-file: Location '/Applications/MAMP/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2023-10-15T03:58:16.555235Z 0 [Note] Failed to start slave threads for channel ''
2023-10-15T03:58:16.619715Z 0 [Note] Event Scheduler: Loaded 0 events
2023-10-15T03:58:16.619910Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: '5.7.39' socket: '/Applications/MAMP/tmp/mysql/mysql.sock' port: 8889 MySQL Community Server (GPL)
2023-10-15T04:11:49.399136Z 0 [Note] Giving 0 client threads a chance to die gracefully
2023-10-15T04:11:49.400703Z 0 [Note] Shutting down slave threads
2023-10-15T04:11:49.401258Z 0 [Note] Forcefully disconnecting 0 remaining clients
2023-10-15T04:11:49.401298Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-10-15T04:11:49.401480Z 0 [Note] Binlog end
2023-10-15T04:11:49.402767Z 0 [Note] Shutting down plugin 'ngram'
2023-10-15T04:11:49.402803Z 0 [Note] Shutting down plugin 'partition'
2023-10-15T04:11:49.402825Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-10-15T04:11:49.402847Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-10-15T04:11:49.402866Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-10-15T04:11:49.402932Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-10-15T04:11:49.402951Z 0 [Note] Shutting down plugin 'MyISAM'
2023-10-15T04:11:49.403038Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-10-15T04:11:49.403059Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-10-15T04:11:49.403076Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-10-15T04:11:49.403093Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-10-15T04:11:49.403109Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-10-15T04:11:49.403126Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-10-15T04:11:49.403142Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-10-15T04:11:49.403168Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-10-15T04:11:49.403186Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-10-15T04:11:49.403203Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-10-15T04:11:49.403220Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-10-15T04:11:49.403277Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-10-15T04:11:49.403295Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-10-15T04:11:49.403312Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-10-15T04:11:49.403328Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-10-15T04:11:49.403345Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-10-15T04:11:49.403362Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-10-15T04:11:49.403379Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-10-15T04:11:49.403395Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-10-15T04:11:49.403412Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-10-15T04:11:49.403428Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-10-15T04:11:49.403444Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-10-15T04:11:49.403461Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-10-15T04:11:49.403477Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-10-15T04:11:49.403494Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-10-15T04:11:49.403510Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-10-15T04:11:49.403527Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-10-15T04:11:49.403543Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-10-15T04:11:49.403559Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-10-15T04:11:49.403576Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-10-15T04:11:49.403593Z 0 [Note] Shutting down plugin 'InnoDB'
2023-10-15T04:11:49.403762Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-10-15T04:11:49.403874Z 0 [Note] InnoDB: Starting shutdown...
2023-10-15T04:11:49.642206Z 0 [Note] InnoDB: Dumping buffer pool(s) to /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2023-10-15T04:11:49.645046Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 231014 23:11:49
2023-10-15T04:11:50.792719Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2695654
2023-10-15T04:11:50.793341Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-10-15T04:11:50.793376Z 0 [Note] Shutting down plugin 'MEMORY'
2023-10-15T04:11:50.793392Z 0 [Note] Shutting down plugin 'CSV'
2023-10-15T04:11:50.793406Z 0 [Note] Shutting down plugin 'sha256_password'
2023-10-15T04:11:50.793416Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-10-15T04:11:50.793752Z 0 [Note] Shutting down plugin 'binlog'
2023-10-15T04:11:50.794635Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete

2023-10-15T04:11:50.6NZ mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/ ended
Post Reply