Timeline for Why is MySQL caching data on our dynamic PHP site?
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 20, 2011 at 16:06 | comment | added | user1867 | Further to that, phpinfo(); produces a blank page =\ | |
| May 20, 2011 at 15:59 | comment | added | user1867 | I'm going to look into any possible PHP caching programs that may be hidden from me, maybe i can find something in phpinfo(). Wouldn't these PHP headers prevent it from caching though? | |
| May 20, 2011 at 15:54 | comment | added | Derek Downey | You might ask on serverfault.com . I can only speculate you have a php-caching program enabled (APC or some such). @Rolando nice answer! | |
| May 20, 2011 at 15:54 | comment | added | user1867 | I managed to log in via shell (this Website OS 4.0 is total garbage), and sure enough I am unable to connect to the MySQL server using the shell. I get an ERROR 2003: Can't connect to MySQL server on ourserver.megasqlservers.com (110). | |
| May 20, 2011 at 15:49 | vote | accept | user1867 | ||
| May 20, 2011 at 15:18 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 242 characters in body; added 153 characters in body |
| May 20, 2011 at 15:04 | comment | added | user1867 | I've just found another abnormality here; when I host the exact same PHP files on a different host, the database updates show immediately in my PHP pages. Is there some kind of PHP result caching possible? I know something is caching the data somewhere in the chain on that server, because when I go back and visit the PHP page on that server, it's still out of date! | |
| May 20, 2011 at 14:55 | comment | added | user1867 | Unfortunately when I added SQL_NO_CACHE to the query, it stopped providing data altogether. I think these tables might be MyISAM. | |
| May 20, 2011 at 14:24 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 14 characters in body |
| May 20, 2011 at 14:13 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 247 characters in body |
| May 20, 2011 at 14:06 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 | added 223 characters in body; added 4 characters in body |
| May 20, 2011 at 13:26 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |