Search found 335 matches

by markus_petrux
Sat Oct 07, 2006 11:02 am
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

Re: SQL Cache

Hi, After a couple of weeks of testing, I would like to post our experience... During peaks, looking at SHOW PROCESSLIST I noticed some of those "cached" queries running at the same time. All our tables are InnoDB, so that functions such as COUNT() or SUM() need to traverse the whole data ...
by markus_petrux
Tue Sep 12, 2006 6:08 pm
Forum: [3.0/Olympus] New features discussion
Topic: Captchas and Human Readability - Discussion
Replies: 74
Views: 80604

Re: Captchas and Human Readability - Discussion

This "centrally hosted database where spam user names, I.P.'s, and any other pertinent information" exists for the bloggin community: akismet

There was an Akismet MOD in the works, but it was abandoned.
by markus_petrux
Mon Sep 11, 2006 1:15 pm
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

Re: SQL Cache

Hi, Just found an article about MySQL function GET_LOCK . For those that use MySQL 4.x, it looks like a good alternative to do the locks with, probably, little performance impact (the mysql connection is already there) ...and looks pretty easy to implement within the sql_query method itself (at leas...
by markus_petrux
Sat Sep 09, 2006 9:22 pm
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

Re: SQL Cache

There was another option, it is to create the cache file using cron jobs. That would ensure the job is done just once, however it makes the whole thing a bit more complex. In fact, there was already a cron in place that was reading the users online query into a temporary table of type MEMORY, but it...
by markus_petrux
Sat Sep 09, 2006 10:33 am
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

Re: SQL Cache

Oh, let me explain a little. All tables are MySQL/InnoDB, so we can count on some hits for certain queries to be resolved from the query cache or from the innodb buffer pool. Still we have found that caching improves the overall performance of the board. We're using 2 dedicated servers (apache and m...
by markus_petrux
Thu Sep 07, 2006 7:12 pm
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

Re: SQL Cache

The problem I'm thinking is more about several users hitting the DB server to perform a potentially heavy query (otherwise it wouldn't worth caching? ) at the same time. Such queries might degrade the connections involved, but also the overall board performance, if running them forces other data tha...
by markus_petrux
Thu Sep 07, 2006 3:18 pm
Forum: [3.0/Olympus] New features discussion
Topic: SQL Cache
Replies: 9
Views: 16401

SQL Cache

Hi, I just noticed something with the Cache method used in Olympus that I'm not sure if that may be a problem on high loaded boards. As far as can see, this is how it works: 1: IF get from cache THEN 2: return cached data 3: ENDIF 4: perform query 5: put data into cache 6: return data When this is c...
by markus_petrux
Mon Apr 24, 2006 10:58 am
Forum: General EM Discussion
Topic: Convert this MySQL?
Replies: 2
Views: 5318

Re: Convert this MySQL?

It contains syntax errors. Try contacting the MOD author.

Then you could tell EM to execute the SQL statements by putting them into the MOD template, within a SQL section. See this for further info:
http://www.phpbb.com/kb/article.php?article_id=39" target="_blank
by markus_petrux
Sat Mar 04, 2006 1:48 pm
Forum: [3.0/Olympus] New features discussion
Topic: seo
Replies: 39
Views: 42701

Re: seo

Still, this is relative, it depends. If you know Drupal's pathauto module (for other readers: it may automatically create friendly URLs for several types of objects such as content, users, catagories, etc.), well, if you have enabled pathauto for content and you have thousands of nodes... you probab...
by markus_petrux
Sat Mar 04, 2006 12:53 am
Forum: [3.0/Olympus] New features discussion
Topic: seo
Replies: 39
Views: 42701

Re: seo

http://www.google.com/webmasters/bot.html#www" target="_blank Thanks. Have you typed that URL? ...or have you just copy/pasted it? :mrgreen: Would you rather have a URL like forums/index.php?c=5 or forums/science_and_philosophy as a URL? Well, 99% of the population would say the latter is...