Tag: tweaks

  • Multiple MySQL Instances

    —

    by

    Christian Noel
    in

    I have seen a lot of versions of this in the web but I decided to create my own copy for ease of setup and simplicity. First, download the file “mysql55rev.rar” as seen in this post then extract it somewhere in your harddrive. Follow these steps: note: extract-dir is the location which you extracted the…

  • Composite Indexes in MySQL

    —

    by

    Christian Noel
    in

    I’m sure many have came across this scenario when you have to consider scalability with respect to data growth. For instance you have a database table that contains a million or more rows and you have to query from it often; you have to ensure that the system can provide data in a short amount…

  • The Port 80 – what service is using it and how to make it available

    —

    by

    Christian Noel
    in

    I stumbled upon this problem this morning when I was trying to activate my apache but was being hindered by a “Port 80 Unavailable” issue. Upon installing apache you usually use port 80 which is the standard HTTP port on any platform. What you have to do is check the port in use and what…