[solved] IIS 8 Performance > tweaking MySQL

Home Forums Troubleshooting Generic Help [solved] IIS 8 Performance > tweaking MySQL

Tagged: , ,

Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • #80873
    Profile photo of abolfazl
    Anonymous

    Hi,

    I am having performance issues when loading workspace, navigating through directories and settings page. Everything is slow, it takes about 4s complete anything.

    I am running a fresh install of Windows 8 with IIS, PHP 5.6 with wincache.
    The diagnostics page lists:
    – The PHP APC module is enabled
    – The output buffering is disabled

    Looking at the developer tools on the web browser pretty much every object has a 4 second wait time before loading in miliseconds. The issue happens on localhost computer and other computers on the network running chrome.

    Any tips on how to improve speed would is greatly appreciated.

    Thank you.


    • This topic was modified 5 years, 10 months ago by Profile photo of Charles Charles.
    #80886
    Profile photo of abolfazl
    Anonymous

    Windows 8 is a client operating system, which isn’t optimized for such things like web applications.
    Run the performance monitor to get an impression, how your PC performs under load.


    #80892
    Profile photo of Charles
    Charles
    Keymaster

    it could also be your DB? Are you using MySQL ? My personal latests tests with iis8 were actually giving surprisingly good results.
    You should try some other PHP application without DB for example…


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #81101
    Profile photo of abolfazl
    Anonymous

    @Martin: I don’t think it is my PC, I am able to transcode HD video from a Plex Server to a Chromecast with no issues.

    @Charles: I ran a benchmarking PHP code I found online and it was able to run fine and quickly. I am running a MySQL database but I did a little more testing with developer tools on the web browser and found it was ‘index.php?secure token’ was is causing about a 4 second wait time when I try to load a new page.

    Thank you again for help.


    #81300
    Profile photo of abolfazl
    Anonymous

    Charles you are correct in that it is an issue with the database. When I install an instance of Pydio without a database it run quickly.

    I still need determine how to fix the issue when using a database.


    #81321
    Profile photo of Charles
    Charles
    Keymaster

    Are you running latest stable version?
    How big is your pydio DB?
    If it’s a “MySQL on Windows” specific issue, it’s out of my knowledge…
    It could also be a super simple connection configuration, if the PHP takes some time to actually find the DB?


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #81342
    Profile photo of abolfazl
    Anonymous

    I would check the configuration file of MySQL. The settings there has influence to the performance of the database.
    MySQL needs some memory. This can be obeserved by using MySQL Workbench. The dashboard shows some graphs about the memory status.

    As i sayed before, a client operating system is not optimized for server stuff. The server is optimized for background operations like services. A desktop OS is optimized for foreground operations. I think, any PHP/MySQL software should run on a Windows PC, if no high performance and high load is expected. Usually a PC comes with *one* disk, which will cause performance problems for sure.

    We have our pydio installations on IIS 7.5 with MySQL. I never had an issue with performance at all.


    #81417
    Profile photo of abolfazl
    Anonymous

    Thank you Martin, I will keep your points in mind when my needs for Pydio increase.

    I was able to get Pydio to work great with a non database setup and considering I currently only have a handful of users accessing Pydio I don’t really have the need for a database. So again thank you Martin and Charles for your input and helping me out.

    Below is information on my current setup for anyone who has ran into the same issues I had, And when I do look into and solve my issue with the database I will make sure to post my solution.

    Operating System: Windows 8.1
    Web Server: IIS 8
    PHP: 5.6.0 with wincache extension (installed from Web Platform)
    Database: currently none, tried MySQL 5.5 from Web Platform
    Pydio Verison: 5.3.3
    Client Network: 2.4n wifi

    My current application is for a handful of Chromebooks and other computers (Chromebooks being the limiting factor, HTTP only… for now) to have access to a centralized local storage. The server os is running off a ssd with 3 harddrive ~ 3TB each for storage. The idea is to allow the computers to share files between each other and also for each user to have their own private storage folder. I was able to get PHP to allow my to upload files about 1GB to the server.

    I noticed when I had a database setup that Pydio was taking forever to switch between Workspaces or load anything. By using the Developers Tools on Chrome I noticed that index.php?secure_token was taking about 4 to 5 seconds to complete. My next steps when I need to integrate a database would to be to follow Martin’s advise above to install the MySQL Workbench to get a graphical interface to better locate my issue.

    Again thank you Martin for the pointers and Charles for beautiful software.


    #81476
    Profile photo of Charles
    Charles
    Keymaster

    Alex
    I really discourage you of using the NoDB setup. You’ll get into trouble at one point or another.
    Did you try using DB but Sqlite instead of Mysql? It’s a “no-server” small DB that should do more or less the same. You’d just have to have sliqte3 and corresponding php extension on your server.
    -c


    Charles, Pydio author - doing my best to help !
    If you like the software or want to say thanks, pay by a tweet, mention #pydio or follow us

    #81551
    Profile photo of abolfazl
    Anonymous

    Good news,
    I spent a little more time trying to setup a database and I got it to work. :)
    With Martin’s advise to install MySQL Workbench and updating to MYSQL 5.6 Pydio is lightening quick. Using MySQL Workbench I modified the innodb_buffer_pool_size and innodb_log_file_size in the “Options File” (my.ini) after following advise from this website:

    http://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/

    I know I will need to tweak a few more setting but things are running smooth.

    Thank you for your help.


    #81552
    Profile photo of abolfazl
    Anonymous

    Glad to here, that your DB is now working better. MySQL is a mess in terms of tweaking and tuning. I hate it 😉
    I will compare the settings we have with the article from the percona.com. The have some interesting statements there, like “disabling the cache completely”.


Viewing 11 posts - 1 through 11 (of 11 total)

The forum ‘Generic Help’ is closed to new topics and replies.