Are you using PHP's mysql extension?

Yes it is using the mysql.so extension.

jDoG

JDog, if you do nothing else today do this one thing; listen to hive. he knows his shit.

Here. I will make this easy for you.

http://cvs.sourceforge.jp/cgi-bin/vi...viewcvs-markup

That is the source code to the mysql extension.

Here is the function to take note of, it sets the variables you see in the mysql section when you call phpinfo().

PHP_MINFO_FUNCTION(mysql)
{
char buf[32];

php_info_print_table_start();
php_info_print_table_header(2, "MySQL Support", "enabled");
sprintf(buf, "%ld", MySG(num_persistent));
php_info_print_table_row(2, "Active Persistent Links", buf);
sprintf(buf, "%ld", MySG(num_links));
php_info_print_table_row(2, "Active Links", buf);
php_info_print_table_row(2, "Client API version", mysql_get_client_info());
#if !defined (PHP_WIN32) && !defined (NETWARE)
php_info_print_table_row(2, "MYSQL_MODULE_TYPE", PHP_MYSQL_TYPE);
php_info_print_table_row(2, "MYSQL_SOCKET", MYSQL_UNIX_ADDR);
php_info_print_table_row(2, "MYSQL_INCLUDE", PHP_MYSQL_INCLUDE);
php_info_print_table_row(2, "MYSQL_LIBS", PHP_MYSQL_LIBS);
#endif

php_info_print_table_end();

DISPLAY_INI_ENTRIES();

}

This line here:
sprintf(buf, "%ld", MySG(num_links));
sets the value of 'buf' to the value of MySG(num_links)

This line here:
php_info_print_table_row(2, "Active Links", buf);
Is the value you see in phpinfo() for "Active Links".

in the function 'php_mysql_do_connect' MySG(num_links) is INcremented.
And in the function '_close_mysql_link' MySG(num_links) is DEcremented.

Well that explains it, now I'm just surprised why this other server would always show 0 even tho there are 300 queries a seconds on it.

jDoG

Is PHP / Apache responsible for those 300 queries per second or is it something running in the background or perhaps another server connecting to this database?

You make a good point of that. The server that has Active Links 0, is only Apache/PHP But the server that has Active Links 1 was just moved from another server. And they might have done a master-slave setup to do that, but I'm not 100% sure about that.

jDoG

Here's the actual problem, the forums on the server were upgraded to vBulletin 3.0.3 and since then the server has been have slow performance issues. I had a php programmer tell me that the Active Links 1 was causing the problem. But now I'm not too sure about that.

But this problem happened when moving servers and doing the upgrade at the same time.

jDoG

vBulliten =(

Do yourself a favor and test everything 1 step at a time until it gets fixed. I know your pain first hand, I did it with GFY when we moved her to JH.

The thing is, I've never set this up, and the real tech is gone til Sun or Mon, so I don't know exactly where to start, and don't know exactly what he has setup.

So probably just ride it out, since he's touchy about other people touching his setup.

jDoG

50 Apache/PHP/MySQL Config Questions

hive,

could you give me a short list of the "critical" things to test? I'm sure there's 100's lol but just like the critical ones? I have like 0 experience with vBulletin. :(

jDoG

Did you upgrade from 2.x to 3.x ?

Yes that is what we just did!

jDoG

Give me an idea of which part of vbulliten is 'slow'.
which page and what action of that page is slow.

forumdisplay,showthread,newreply?

Those three are exactly the pages are having problems. They hang most of the time, while other times, it's ok. It goes back and forth.

jDoG

So loading forumdisplay is slow?

Do 1 thing at a time. Do you have access to the mysql server the vb database runs on?

All three of those pages are random slowness, it'll just hang. Then somestimes, it'll be faster then hell, then slow again.

jDoG

Yes :)

jDoG

Shit I didn't know we had a bunch of programmers here, who'd thought :321GFY

Sorry are we bothering your normal flow of quality substance?