Hi
I have two separate Drupal instances (Pressflow 6.19) In first one the local cache works fine. Sql log: 326 Query SET NAMES "utf8" 326 Query SELECT 1 FROM access WHERE type = 'host' AND '195.50.208.170' LIKE mask AND status = 0 LIMIT 0, 1 326 Query SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' 326 Query SELECT data, created, headers, expire, serialized FROM cache_page WHERE cid = 'http://IP/path/to/node' 326 Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC 326 Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC 326 Quit
But If I request the same node in the second machine. The code is same, then the Sql log is: 122 Quit 123 Query SET NAMES "utf8" 123 Query SELECT 1 FROM access WHERE type = 'host' AND 'IP' LIKE mask AND status = 0 LIMIT 0, 1 123 Query INSERT INTO semaphore (name, value, expire) VALUES ('variable_cache_regenerate', '17865562914d37e5d81acd80.47344784', 1295508982.1098) 123 Query SELECT * FROM variable 123 Query DELETE FROM semaphore WHERE name = 'variable_cache_regenerate' AND value = '17865562914d37e5d81acd80.47344784' 123 Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC 123 Query SELECT * FROM languages ORDER BY weight ASC, name ASC 123 Query SELECT dst FROM url_alias LIMIT 0, 1 123 Query SELECT src FROM url_alias WHERE dst = 'hoiused-ja-investeerimine' AND language IN('et', '') ORDER BY language DESC, pid DESC 123 Query SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC 123 Query INSERT INTO semaphore (name, value, expire) VALUES ('locale_cache_et', '17865562914d37e5d81acd80.47344784', 1295508982.4035) 123 Query SELECT s.source, t.translation, t.language FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'et' WHERE s.textgroup = 'default' AND s.version = '6.19' AND LENGTH(s.source) < 75 123 Query DELETE FROM semaphore WHERE name = 'locale_cache_et' AND value = '17865562914d37e5d81acd80.47344784' 123 Query SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'et' WHERE s.source = 'Stores details about batches (processes that run in multiple HTTP requests).' AND s.textgroup = 'default' .... .... loads of SQLs
The main question why does the last one ask something from semaphore? In both servers access table is empty. At first I thought the condition came from that SQL: SELECT 1 FROM access WHERE type = 'host' AND 'IP' LIKE mask AND status = 0 LIMIT 0, 1 but as I said in both servers access table is empty.
In both solutions caches are enabled.
Any hints?