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 space ...
Search found 335 matches
- Sat Oct 07, 2006 11:02 am
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
- Tue Sep 12, 2006 6:08 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: Captchas and Human Readability - Discussion
- Replies: 74
- Views: 82310
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.
There was an Akismet MOD in the works, but it was abandoned.
- Mon Sep 11, 2006 1:15 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
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 ...
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 ...
- Sat Sep 09, 2006 9:22 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
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 ...
- Sat Sep 09, 2006 10:33 am
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
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 ...
- Thu Sep 07, 2006 7:12 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
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 ...
- Thu Sep 07, 2006 3:18 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: SQL Cache
- Replies: 9
- Views: 16951
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 ...
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 ...
- Mon Apr 24, 2006 10:58 am
- Forum: General EM Discussion
- Topic: Convert this MySQL?
- Replies: 2
- Views: 5455
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
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
- Sat Mar 04, 2006 1:48 pm
- Forum: [3.0/Olympus] New features discussion
- Topic: seo
- Replies: 39
- Views: 43558
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 ...
- Sat Mar 04, 2006 12:53 am
- Forum: [3.0/Olympus] New features discussion
- Topic: seo
- Replies: 39
- Views: 43558
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 ...