MySQL - PHP BuiltIn / External

  • by
  • on 01.08.09
  • creampiesca.com
  • edit
  • OK,

    I was originally running Mandrake Linux with the RPM install of Apache, PHP, and MySQL. I later found out the default configurations for the packages really sucked, and I couldn't upgrade anything without requiring a million other programs which I never use, so I said forget RPMs.

    I then backuped my database and files and completely formated the server clean.

    I then reinstalled Mandrake, since I can't seem to get RedHat to get Apache to listen through Port 8080. But with Mandrake it works, kind of weird, plus I like the userdrake and stuff.

    I compilied MySQL 3.23.51 and installed it to /usr/local/mysql

    Then I downloaded Apache 1.3.26 and PHP 4.2.1 and compilied and installed them and I told PHP --with-mysql=/usr/local/mysql which is where I installed MySQL.

    Now I dumped my .sql's that I backedup the DB with, including vbulletin.sql.

    And I ran it, everything worked fine except there was maybe a 1 or 2 second delay longer wait time on long querys then before I formatted.

    Then about 3 hours ago I went to my forum and the custom avatars weren't working. So I went here and read a post about this problem occuring, I did everything everyone else did but it didn't seem to work. And how I work with Linux is, if it don't work right delete it and reinstall. So I deleted /usr/local/apache & /usr/local/php but of course my website files are in /var/www so I didn't delete anything that would take hours to put back.

    I then downloaded Apache and PHP again and installed them again instead I added mod_negotiate with Apache cause I forgot to add it last time, and this time with PHP I said --with-mysql and thats it.

    I was hoping that would kill that delay I noticed, but it didn't.

    Anyway thats the way it's running right now. Only thing is if it's running the builtin version of MySQL in PHP, then how come I still need to run MySQL (the one I installed first) inorder to access the database?

    And I am still accessing through /usr/local/mysql/var that hasn't changed since I configure PHP again. And vbulletin and everything else seem to still be using the original MySQL and not the one builtin to PHP, I don't even know where the directory for the PHP MySQL is.

    And PHPMYADMIN is still saying MySQL version 3.23.51 while in phpinfo() it's saying MySQL version 3.23.39.

    Can someone help me?

    My PhpInfo - http://www.imahosting.com/phpinfo.php


  • OK - I don't notice any difference.

    Anyway to reduce the time on long querys?


  • Hello?


  • I'm guessing no one knows the answer ... :(


  • Wont that degrade performance?


  • Originally posted by DexterII
    Doesn't zlib reduce server performance?

    Also, whats the optimal compression level for zlib? no zlib compresses txt in php pages in vB thereby reducing page loading time

    optimal level = 1


  • Well the small delay only started after I formatted the server.

    Also I got a 100MBit connection to the server so I don't think it's lag.


  • Doesn't zlib reduce server performance?

    Also, whats the optimal compression level for zlib?


  • Ok, I'll remove it.


    But why am I recieving that small delay now? Also why did the avatars stop working for no reason...?


    Also is that enough stuff under the config command line for PHP do I need other things like GD or XML or ZLIB .....?


  • Holy sh*t zlib really does increase speed even with a 100MBit conn, but it doesn't decrease the query time :(

    Plus I found out I had zlib all along but zlib 1.1.3 so i deleted all the zlib files i could find and installed zlib 1.1.4, and that was a bitch cause all the make files are f***ed up. Anyway I got down to it and compiled it and it seems to run great. Execept those damn querys...

    At the moment the server is only 350MHz, it doesn't get much traffic so I don't have to worry about cpu ussage going sky high it normally stays at about a load of 1.10 or so...


  • Ok, did that ... now?


  • Originally posted by DexterII
    Ok, did that ... now? you're all set check http://www.imahosting.com/phpinfo.php under MySQL heading :)


  • *BUMP*


  • Originally posted by DexterII
    Wont that degrade performance? nope .. try it and see


  • your forum loads fine for me... i noticed one thing though you compiled PHP without zlib support which means you can't use vB admin's gzip compression support to reduce vB php page size and hence speed up page loading

    you need to install zlib and recompile PHP with zlib support


  • you need to recompile PHP and specify the location of mysql in the --with-mysql=/path/to/mysql

    in the php source directory where you compiled PHP type

    make clean

    and delete the config.cache file in that directory

    and recompile PHP

    and remember to restart apache after


  • the small delay can be network related as well...


  • Originally posted by DexterII
    Ok, I'll remove it.


    But why am I recieving that small delay now? Also why did the avatars stop working for no reason...?


    Also is that enough stuff under the config command line for PHP do I need other things like GD or XML or ZLIB .....? yeah leave the GD and zlib stuff..

    you might want to increase apache httpd.conf's maxclients setting from 50 back to default 150 and restart apache


  • also please read the forum rules regarding sig image sizes etc http://www.vbulletin.com/forum/showthread.php?s=&threadid=42918

    your sig image is too large







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about MySQL - PHP BuiltIn / External , Please add it free.