pollywogs

I tried finding someone to make something like this when 3.0 first came out, but no one was interested :(

AFAIK, that was pre-3.0.2 and is no longer the case. Based on what I was told, those *should* now use Sphinx as well, however I will yield that question to Brandon for 100% confirmation.

Okay I finally figured out the problem. I made my sphinx.conf file WHILE upgrading, and apparently it still grabbed the 3.0.1 file :( Now I ran killall searchd and started over, utilizing the changes you have specified. All is well now, thanks for the assistance! ;) EDIT @ .om: You have you killall searchd, then run: /usr/local/bin/indexer --config /path/to/sphinx.conf --all then: /usr/local/bin/searchd --config /path/to/sphinx.conf ...after uploading the new sphinx.conf of course :P and don't forget to update your crontab too!

But it can't do anything if there are no indexes on the server <_<

root@server:~# /usr/local/bin/indexer --config /var/www/domain/forums/sphi nx.conf core_search_delta members_search_delta forums_search_posts_delta forums _search_topics_delta --rotate Sphinx 0.9.8.1-release (r1533) Copyright © 2001-2008, Andrew Aksyonoff using config file '/var/www/domain/forums/sphinx.conf'... indexing index 'core_search_delta'... collected 0 docs, 0.0 MB total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec indexing index 'members_search_delta'... collected 335 docs, 0.0 MB collected 0 attr values sorted 0.0 Mvalues, 100.0% done sorted 0.0 Mhits, 100.0% done total 335 docs, 12315 bytes total 0.010 sec, 1231500.00 bytes/sec, 33500.00 docs/sec WARNING: no such index 'forums_search_posts_delta', skipping. WARNING: no such index 'forums_search_topics_delta', skipping. rotating indices: succesfully sent SIGHUP to searchd (pid=10001). root@server:~# So seems like there is no such index, therefore it isn't working. Also I tried changing my sql_port to 3312 in my data source definitions, but no luck with that either. It appears as if somewhere those indexes weren't created, but the forums are looking for them while searching.

http://resources.invisionpower.com/index.php?appcomponent=cms&module=articles&article=7813 ;)

You already can purchase "upgraded" support for an extra fee ;)

The only *new* thing I know is full support for Sphinx, which I'm super excited for! :D

Just keep in mind that the articles on the resource site are NOT the official documentation for IP.Board or any other IPS, it is merely a wiki that is user-editable by ANY other customer. The official documentation *I believe* you have access to still, even if you don't have an active support license (I could be wrong on that though). The point is, the articles on the resource site aren't the documentation, therefore your argument is totally invalid.

Wait until 3.0.2 to setup Sphinx, as 3.0.1 doesn't fully support it.

...what are you talking about?!?

I just had a great idea from this thread! What about making the ACP another "module" similar to forums and members and stuff, and display it inside a tab for easy use and access:

Lindy/Charles, Last week I submitted a ticket in my client center regarding mySQL slow queries, and server optimization. I know the latter isn't fully relevant to IPS and their product IP.Board, however it really is in the company's best interest to make sure every installation is running at its peak efficiency. Being the operator of a pretty big board, optimizing everything to make sure everything is running in tip-top shape is one of my #1 priorities. Jason took my issue and treated it like it was his own, never once implying anything like it was outside of the realm of support, and helped in every way he could. This is my first experience with Jason, but boy do I hope it's not my last! It is support like this that is one of the reasons I stay with IPS, and will for a long time to come. In a different ticket, after a late night exchange of replies, he can even appreciate some kidding around: I also noticed after him logging in that his IP did not go back to your main office (also, responding well after business hours...big plus as well), and I know it's sometimes tough to gauge the level of work a telecommuter is doing - but rest assured Jason is the best employee you have. Aside of the developers of course :P I've also had really great luck with Brandon as well, you guys really made a great decision offering him a job with IPS. He also treats your issue like it were his own, and is extremely well rounded in servers, PHP coding, different versions of software, etc. (really valuable skills to have). It is because of these two gentlemen that I choose to stick with IPS for the life of my site.

It's very sporadic for me too, I had a ticket today with a response within 5 minutes. Another ticket that I created YESTERDAY has sat unattended to for over 24 hours (which is more important to me than my other ticket) :(

Well I'm all setup right now, but the question that still remains is the caching system. I currently am using the Disk Cache, but think a PHP Caching system would perform best. There are 3 major kinds though, eAccelerator, XCache, and APC. APC is going to be included in PHP6, so one would think it is the best and everything - but it can depend on the software, and version. I know on the resources site a number of years ago for 2.1 bfarber recommended eAccelerator, but I'm not sure if that's the same case for IPB 3.0 or not. I want to make best use of it, including adding it into my conf_global.php so I'd like a recommendation please, from staff if at all possible :) Or maybe the disk cache is the best? Or maybe I can/should use both? Sorry if these are stupid questions, but I just want best setup possible. Thanks!

I can't seem to be able to get PHP 5.2.10 on Debian/ubuntu, I can only get 5.2.6 :( mySQL 5.0 is the default, but I'm pretty sure I can get 5.1 installed though!

Fair enough. I think I'm gonna take your (and everyone elses) advice and give Apache 2.2 a try. I haven't tried Apache since 1.3 I think, or if I tried 2.* it was 2.0 and they might have improved it since then. If worse comes to worse, I can switch to lighttpd as that isn't a huge deal. I'm more interested in PHP accelerators though, I understand you don't use one rct2dotcom, but I'd like to see if anyone else has an opinion on that. Thanks for the advice :)

So with that said, you're still recommending Apache? How can I make sure Apache is tuned correctly with all those settings you talked about? I've used lighttpd for the last couple of years with no problem, but would be willing to use Apache if I could get the same performace - I guess I just don't know how to :( Also which PHP accelerator would you recommend?

Well the only thing I've really been "ignoring" is the fact that I'm pratcially limited to ubnutu server instead of debian. As for Apache though, in my experience, it's too slow. I have 2000 users online at a time on my site, and need everything fast fast fast. If Apache has changed recently and it's faster and can be used for 2000 users at a time and if that's what's being recommended by the pros then so be it.

Alright well I think I can convert ubuntu server to Debian 5.0, unsure though, but the most important thing to me is what PHP accelerator to use with IPB 3.0 :)

Well I'd like to use Debian, but for some reason the datacenter doesn't have it - only Ubuntu Server :( And Ubuntu is the closest thing I can get to Debian, it's practically the same damn thing, no?

I also have decided to use ubuntu server instead of debian!

In my experience Apache has horrible performance, and on a super large site should be your last choice <_<

Well obviously I'm going to go with one of the latest versions, not like you can get what I was running before. But questions I was wondering were like what web server to use, and what version - I'm not sure which one is the best for IPB (this server EXCLUSIVELY runs IPB and just static images), or if I should use PHP 5.2 or 5.3? What version of mySQL, 5.0, 5.1, 5.4? What PHP accelerator works best with IPB 3.0? It's questions like these that I'd like help with, because like I said I run a very large site.

I'm currently upgrading from an aging server to a new one, and am looking for recommendations as to what to run on it. I currently have an Intel Q6600 @ 2.4Ghz with 4GB RAM. The software is as follows: Debian 4.0 x86 lighttpd (lighttpd 1.4.19-4) mySQL (MYSQL 5.0.51a-9-log) PHP (5.2.6-2 [cgi-fcgi]) XCache (1.2.2 I think?) This server is aging for us, so I'm upgrading to Dual Xeon 5420+ processors with 16GB of RAM. I'd like recommendations on the best setup of software to install, if I should go with mySQL 5.1 or if I should use a newer version of PHP or if I should use a different PHP accelerator besides XCache, etf. I'm installing Debian again (x64 obviously this time), but I'm open to pretty much anything else. Would also like input from developers if at all possible since this is such a large site going on such a powerful server. Thanks!