http://bbpress.org/forums/ bbPress support forums Tag: mysql en Tue, 02 Dec 2008 21:53:22 +0000 http://bbpress.org/forums/topic/too-many-homepage-queries#post-18611 Sun, 24 Aug 2008 10:15:15 +0000 _ck_ 18611@http://bbpress.org/forums/ <p>Everyone put this in your <code>bb-config.php</code><br /> <code>$bb-&gt;load_options = true;</code><br /> and that number will go down radically.</p> <p>For some reason I don't understand they refuse to make that the default and therefore bbPress just "lazy loads" each option as each plugin requests it.</p> <p>If you are using the 1.0 alpha they still have a bit of work to do with query reduction as they rewrote half the routines and storage layout but left it unoptimized. For example each forum on the front page is loaded as a separate query and then the meta for each forum is loaded as a separate query. It's a bit crazy because if you have a dozen forums that's 24 queries but I have high hopes Sam or MDA will tackle that soon and do it all in just two queries.</p> <p>Last but not least there is a serious optimization problem IMHO in all versions where bbPress will "read before write" every time a meta option is saved, regardless if it's just been loaded and sitting in the object cache. I have to put a bit of extra code in all my plugins to work around this issue. The reason why they do that is to determine if they should do an INSERT vs an UPDATE because you can have duplicate keys on meta data by design and mysql can't be told what to do if the key already exists. But there are better ways to do that - since 99.99% of the time it's going to be an update since the data already exists - do an update and just check for a mysql error on the return (or count rows affected) - then do an insert instead that one time it's needed. </p> http://bbpress.org/forums/topic/too-many-homepage-queries#post-18585 Sat, 23 Aug 2008 10:22:19 +0000 fel64 18585@http://bbpress.org/forums/ <p>This query diagnostics plugin will tell you something. It could be ck's originally. <a href="http://pastebin.ca/1182319" rel="nofollow">http://pastebin.ca/1182319</a> </p> http://bbpress.org/forums/topic/too-many-homepage-queries#post-18575 Fri, 22 Aug 2008 19:51:25 +0000 Thion 18575@http://bbpress.org/forums/ <p>155?! Whoh, and I'm worried about 18 queries in my still-in-development plugin :).</p> <p>It would be much easier to say anything if there would be any link... </p> http://bbpress.org/forums/topic/too-many-homepage-queries#post-18554 Fri, 22 Aug 2008 09:08:12 +0000 Phayze 18554@http://bbpress.org/forums/ <p>OK - I think that was the first query before caching had taken effect, because I reloaded the page and got:</p> <p>0.126 - 33 queries</p> <p>Any ideas why the drastic reduction? </p> http://bbpress.org/forums/topic/too-many-homepage-queries#post-18552 Fri, 22 Aug 2008 08:49:21 +0000 Phayze 18552@http://bbpress.org/forums/ <p>I'm pretty sure that there are too many queries running on my homepage:</p> <blockquote><p> If you like showing off the fact that your server rocks,<br /> 1.463 - 155 queries </p></blockquote> <p>What are the common things that increase the number of queries, and how can I reduce that number - I'm pretty sure it's killing MySQL on my server when it gets overloaded.</p> <p>Thanks, </p> http://bbpress.org/forums/topic/installation-problem-with-bbpress#post-18118 Sun, 10 Aug 2008 17:06:52 +0000 chrishajer 18118@http://bbpress.org/forums/ <p>OK, please let us know if you need more help. </p> http://bbpress.org/forums/topic/installation-problem-with-bbpress#post-18110 Sun, 10 Aug 2008 12:35:27 +0000 MartinOShea 18110@http://bbpress.org/forums/ <p>Thanks chrishajer.</p> <p>That seems to have done the job and bbPress is now installed. But I do find that I am denied access to certain pages. I will see how this proceeds. </p> http://bbpress.org/forums/topic/installation-problem-with-bbpress#post-18092 Sat, 09 Aug 2008 18:17:57 +0000 chrishajer 18092@http://bbpress.org/forums/ <p>How about the php_mysql.dll, not just php_mysql<strong>i</strong>.dll? It seems to be saying it's missing the mysql extension but you've posted only that you have enabled mysqli.</p> <p>Also, be sure to restart the web server after making a configuration change. </p> http://bbpress.org/forums/topic/installation-problem-with-bbpress#post-18084 Sat, 09 Aug 2008 13:09:30 +0000 MartinOShea 18084@http://bbpress.org/forums/ <p>Hello</p> <p>I'm trying to install bbPress but every time I try am greeted by the message 'Your PHP installation appears to be missing the specified MySQL extension (mysql) which is required for bbPress.'</p> <p>I am using Windows XP Pro SP2 and have PHP 5.2.44 and MySQL 5.o installed . Both these applications work in isolation of each other and I have tried to install the MySQL extensions for PHP.</p> <p>To give more detail; I have file php_mysqli.dll (version 5.2.1.1) in the folder C:\Program Files\Ext, file libmysql.dll is in C:\Program Files\MySQL\MySQL Server 5.0\bin and this included in the Windows PATH.</p> <p>I also have extension=php_mysqli.dll defined in section [MySQLi] of file C:\Program Files\php.ini.</p> <p>Can you advise where my PC's configuration is wrong, or if I need to carry out additional steps, because I would like to evaluate bbPress for use in a Java application I'm writing?</p> <p>Thanks</p> <p>Martin O'Shea. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16797 Wed, 18 Jun 2008 12:15:17 +0000 bramruiter 16797@http://bbpress.org/forums/ <p>It indeed was aMySQL issue. It's been solved now. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16794 Wed, 18 Jun 2008 10:12:49 +0000 bramruiter 16794@http://bbpress.org/forums/ <p>Ah, I thought it was something like that. I've just ordered a new hosting, which works on MySQL 5.</p> <p>Thanks for the help. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16762 Sat, 14 Jun 2008 18:13:48 +0000 chrishajer 16762@http://bbpress.org/forums/ <p>bbPress requires MySQL 4.0 minimum. I think 3.23 is too low:<br /> <a href="http://bbpress.org/about/requirements/" rel="nofollow">http://bbpress.org/about/requirements/</a> </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16759 Sat, 14 Jun 2008 10:13:23 +0000 bramruiter 16759@http://bbpress.org/forums/ <p>Sorry, I don't check this forum daily, so here's a late answer:</p> <p>1. From what I know, it has always been like this. It's only when I perform a search.</p> <p>2. The version is bbPress 0.9.0.2 and it was installed somewhere between june 26 and june 31.</p> <p>3. I didn't. I only screwed around with the template files.</p> <p>4. No, they did no update or change whatsoever.</p> <p>5. Like I said, it was there before the plug-ins, but here's the list.<br /> Private Forums, BBPress Private Messaging (not working), Post Count Plus - Dynamic.Titles &#38; More!, Akismet, Avatar, Last-Post, Limit Latest Discussion, Bozo Users, BBcode Lite, Move It, Quote, Simple Onlinelist, Allow Images, Human Test for bbPress &#38; Front Page Topics.</p> <p>6. The second error appears only when someone perform a search. The first error is only noted in the admin area, in the first tab, beneath 'User Registrations'.</p> <p>7. Yes. It does happen.</p> <p>The MySQL version is 3.23.58.</p> <p>I'm not a big guy when it comes to coding/scripting, so I have no idea what these errors mean. I'm glad somebody wants to help. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16671 Mon, 09 Jun 2008 19:32:12 +0000 bobbyh 16671@http://bbpress.org/forums/ <p>Check your mysql version number. Is it really low? </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16667 Mon, 09 Jun 2008 15:52:37 +0000 chrishajer 16667@http://bbpress.org/forums/ <p>Interestingly, I copied and pasted your SQL query from above, and used it on my installation unchanged, and it did not error out, it just return the expected results.</p> <p><code>SELECT t.*, MIN(p.post_id) as post_id, p.post_text, 0 AS search_score FROM bb_topics AS t JOIN bb_posts as p ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = &#39;0&#39; AND p.post_status = &#39;0&#39; AND ( (t.topic_title LIKE &#39;%ja%&#39;) OR p.post_text LIKE &#39;%ja%&#39; ) GROUP BY t.topic_id ORDER BY t.topic_time DESC LIMIT 20</code></p> <p>See the results <a href="http://www.chrishajer.com/bbpress/sqlerror.png" title="no SQL error here">here</a>.</p> <p>This is an old bbPress installation as well, 1.0-alpha from over a year ago. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16666 Mon, 09 Jun 2008 15:25:17 +0000 chrishajer 16666@http://bbpress.org/forums/ <p>1. Has this installation always been like this, or did something change recently?</p> <p>2. What version are you running and when was it installed?</p> <p>3. Did you change hosting or make any other changes to the installation?</p> <p>4. Did your host upgrade PHP or MySQL or your .htaccess file or something else that would have affected this?</p> <p>5. What plugins are installed, and does disabling them help with the error?</p> <p>6. Does the problem described in the first post happen only when searching, or is that from something else and you now have the problem described in the last post as well?</p> <p>7. Does the problem happen when using the stock theme?</p> <p>You don't have a normal run-of-mill type problem that can be easily and simply solved, so people are going to need more info to help. </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16663 Mon, 09 Jun 2008 13:48:29 +0000 bramruiter 16663@http://bbpress.org/forums/ <p>The problem got a bit bigger. When someone tries to find something through the search they get:</p> <p>bbPress database error: [You have an error in your SQL syntax near 'ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE '%ja%' AND p.post_status =' at line 1]<br /> SELECT p.*, 0 AS search_score, MAX(post_time) AS post_time FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE '%ja%' AND p.post_status = '0' AND t.topic_status = '0' GROUP BY t.topic_id ORDER BY p.post_time DESC LIMIT 5</p> <p>bbPress database error: [You have an error in your SQL syntax near 'ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = '0' AND p.post_status = '0' at line 1]<br /> SELECT t.*, MIN(p.post_id) as post_id, p.post_text, 0 AS search_score FROM bb_topics AS t JOIN bb_posts as p ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = '0' AND p.post_status = '0' AND ( (t.topic_title LIKE '%ja%') OR p.post_text LIKE '%ja%' ) GROUP BY t.topic_id ORDER BY t.topic_time DESC LIMIT 20 </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16659 Sun, 08 Jun 2008 22:28:49 +0000 chrishajer 16659@http://bbpress.org/forums/ <p>What do you have to do to get that error to show up? Installation, view profile, post a new topic, post a reply, add a tag, etc... </p> http://bbpress.org/forums/topic/bbpress-database-error-1#post-16657 Sun, 08 Jun 2008 17:39:52 +0000 bramruiter 16657@http://bbpress.org/forums/ <p>bbPress database error: [You have an error in your SQL syntax near 'ON ( t.topic_id = p.topic_id ) WHERE p.post_status != '0' AND t.topic_status = '' at line 1]<br /> SELECT p.* FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_status != '0' AND t.topic_status = '0' ORDER BY p.post_time DESC LIMIT 5</p> <p>What does it mean? </p> http://bbpress.org/forums/topic/i-cannot-use-%c2%b4-on-my-posts#post-16612 Wed, 04 Jun 2008 20:57:00 +0000 motaboy21 16612@http://bbpress.org/forums/ <p>well, when im writing a post and i write something like "it´s" i have an error of SQL (or Mysql) that says there was a problem with this character "´"</p> <p>try it hentaitube.org </p> <p>help please </p> http://bbpress.org/forums/topic/there-was-a-problem-connecting-to-the-database-you-specifiedplease-check-the-s#post-15890 Wed, 30 Apr 2008 13:21:34 +0000 chrishajer 15890@http://bbpress.org/forums/ <p>That is telling you the database connection details are incorrect. You need to check all four of them again. It's possible you need to specify a host name in place of localhost (the thing they say there is a 99% chance you won't need to change.) Since my database is on a different server, I need to change that 100% of the time.</p> <p>Only you will be able to verify that your connection details are correct. Right now, they are not and that's what the message is telling you. </p> http://bbpress.org/forums/topic/there-was-a-problem-connecting-to-the-database-you-specifiedplease-check-the-s#post-15877 Wed, 30 Apr 2008 04:22:46 +0000 rhodzr 15877@http://bbpress.org/forums/ <p>!!There was a problem connecting to the database you specified.<br /> Please check the settings, then try again.</p> <p>hi i'm new to this.. i wanted to install bbpress but after providing the database name and user i get this error.. (on top) </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15140 Tue, 08 Apr 2008 11:12:58 +0000 sambauers 15140@http://bbpress.org/forums/ <p>WordPress.org forum is about 500Mb of data. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15139 Tue, 08 Apr 2008 11:12:02 +0000 sambauers 15139@http://bbpress.org/forums/ <p>Using one server will only ever get you so far no matter how lean the application you are running is.</p> <p>Massive query caches are no use if you don't have the data to fill them. WordPress.com forums (all languages) doesn't amount to more than 200Mb of data. So even a 1Gb query cache would be mostly empty or stale. WordPress.org wouldn't be much bigger (and may be smaller). I don't actually know what the query cache size is on the servers by the way. Query caching is great. Massive query caches aren't anything special IMHO. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15129 Tue, 08 Apr 2008 05:23:32 +0000 _ck_ 15129@http://bbpress.org/forums/ <p>As fascinating as it is, unfortunately the setup that automattic uses can't be compared in any way to a single stand alone server (or VPS) running it's own mysql processes since you can use a radical amount of caching ram on the dedicated db servers.</p> <p>However bbPress could benefit someday from a port of wp-super-cache (or even just wp-cache2) to send non-logged in/non-members cached pages. There's a big difference between a forum with 1000 active logged-in users where pages have to be customised via the core and plugins vs. 1000 guests/bots who all see the same pages. </p> <p>It bothers me that my fully loaded demo at bbshowcase.org has now beached the 100ms mark for front-page generation (bare bbPress is like 40ms) but I can't think of any easy ways to speed that up further without removing features. Maybe when PHP 5.3 comes out which seems to promise a 10-15% code speedup. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15121 Tue, 08 Apr 2008 04:45:53 +0000 sambauers 15121@http://bbpress.org/forums/ <p>I can only give you a vague idea of loads we experience in our environments. They aren't exactly standard setups.</p> <p>On WordPress.com the forums are served by the same infrastructure as the blogs. The forums don't really make a dent in the load on that setup (hundreds of servers). Average of all queries is about 45 queries per second, over 90% of this is handled by MySQL query cache.</p> <p>WordPress.org and bbPress.org are run from the same cluster which has three active load-balanced web servers and two database servers (one for writing and one for reading). The majority of the database load on this cluster is reads initiated by the forums and to a lesser extent reads initiated by the WordPress Codex (MediaWiki). Average load is about 700 reads per second, about 80% of those reads are cache hits.</p> <p>Most of our servers have 2GB of RAM and 4 processor cores. Some DB servers might have more RAM. But there is nothing particularly special about the hardware otherwise. Pretty much the same as you would rent from a dedicated server provider. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15102 Mon, 07 Apr 2008 10:19:25 +0000 _ck_ 15102@http://bbpress.org/forums/ <p><em>The bb-&gt;load_options = true brought the load of the cpu to 5 times that of the one with 30+ queries but I guess that comes from not having that many topics in the newly installed Db so I really don't know what to make of this.</em></p> <p>Turn on (or increase) your mysql caching. It's fairly obvious you are running either without any or not enough of it if you can detect any load increase with load_options=true. The query to load all options would be exactly the same across all instances for all users and mysql would pick up on that immediately and keep it in the cache, always. At least that's what happens on my installs. I don't have a site with 50k views a day but I have a 0.8.2.1 version with 15k views a day and it runs very fast.</p> <p>Also make sure you use a php opcode cache like eaccelerator, xcache, etc. Best thing you can do for bbPress or WordPress.</p> <p>0.9 of bbPress is not some kind of radically different change since 0.8 - there are many bug fixes and a few features added but the db calls are almost identical (some plugins however can be sloppy about not caching queries so that can cause issues). </p> <p>Try my <a href="http://bbpress.org/plugins/topic/bb-benchmark/">bb-benchmark</a> if you want to see what happening behind the scenes for each page generated. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15100 Mon, 07 Apr 2008 09:09:23 +0000 andersson 15100@http://bbpress.org/forums/ <p>:)</p> <p>ok ok, I believe you. 0.9.0.1 is good enough to give a try.</p> <p>Just one more thing: I'm guessing you have something like 100,000 pageviews a day in this forums which would render about 3,000,000 queries (moderate estimate) if you run bbpress 0901 out of the box. Your servers are cool with this? RAM at OK level?</p> <p>No need for exact figures but just a notion of what's been your experience so far would be golden. 3,000,000 queries a day means around 35 queries per second. That's some load.</p> <p>Thanks again.</p> <p>EDIT: The reason why I'm asking is that I'd really like to continue to use bbpress as my primary PHP-framework for all my sites that has logon/user needs as I've had a hard time to find a more suitable framework to my needs. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15096 Mon, 07 Apr 2008 07:04:44 +0000 sambauers 15096@http://bbpress.org/forums/ <p>Oh, and not to mention this forum as well. </p> http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page#post-15095 Mon, 07 Apr 2008 07:03:46 +0000 sambauers 15095@http://bbpress.org/forums/ <p>We have been running revisions which are only slightly older than 0.9.0.1 at WordPress.org and WordPress.com for a while now without fault. </p>