MAMP Websites taking more than 20-25 secs to load, but sometimes

Arturo

5/6/24, 8:11 AM

I'm using MAMP Pro on my Mac (Monterrey) and since a couple weeks I've been having a strange problem. After several tests I've been unable to find out where the problem is, but this is what happens.

The main issue is, when I load any local php/postgre/laravel website, it takes forever to load. 20-30 secs and sometimes it loads, sometimes it doesn't.

Strange thing is, all of the sudden, sometimes websites start loading normally again for some minutes... and then, all of the sudden, they go slow again. Even pages that don't do anything in particular besides just loading an empty view.

Another strange thing is, when the 'slow mode' thing is happening, I tried loading a plain html page and it works normally, so the problem must be mamp/php/library/laravel related?

I'm not using wordpress, my websites are mostly using laravel (5.8.x, 6.x, 8.x) with a couple old exceptions using old plain PHP.

I tried changing my database host from localhost to 127.0.0.1 and the problem persists. Also, I was using SSL for all my local websites, so I tried removing the SSL, changing apache ports from 80 to 8080 and back... didn't work, problem persists.

I tried changing MAMP PHP Settings from Module to CGI and back... didn't work. I tried using cache, not using cache, reinstalling MAMP, reinstalling PHP, using different PHP versions for different websites, using nginx instead of apache... Nothing worked.

One thing that surprised me was, when MAMP was working slow and every website was taking 15-20 secs to load, I ran a php artisan migrate in command line, just to test how long did it take to connect to DB and execute the migration and it worked normally, even tho the websites were in the 'slow mode'. So that just added more questions to my confusion.

What I do know is:

It's not a slow query problem (a simple php with a 'echo "hello world";' and no database connection takes forever to load aswell).
A HTML file doesn't have a problem, loads normally even when MAMP is in the 'slow mode'. Tested with PHP/MySQL websites aswell, problem persists, so I guess it's not 'postgres related' problem.

After a couple weeks dealing with this, I'm out of ideas.. anyone?

Any help will be appreciated.

pd: Sorry if my english is not very good, not my primary language.

318

0 + 3

php

performance

mac-osx

mamp

TomTom

5/6/24, 9:02 AM

You mistake us for your end user support.

Wilson Hauck

5/8/24, 1:15 PM

Additional DB information request, please. RAM size, # cores, any SSD or NVME devices on MySQL Host server? Post TEXT data on justpaste.it and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*), sum(data_length), sum(index_length), sum(data_free) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) STATUS; not SHOW STATUS, just STATUS; G) SHOW ENGINE INNODB STATUS; for server workload tuning analysis to provide suggestions.

Wilson Hauck

6/21/24, 1:21 AM

@Arturo Do you still need assistance?

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: MAMP Websites taking more than 20-25 secs to load, but sometimes

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.