WassUp Forums

• Forums
• WassUp

1. 

   rtiger
   Member

   I have been using Wassup for months and it works great. It has a lot of the information I'm looking for. But recently my site got ranked #1 on a couple major terms. The result was over 100,000 page views in a single day. Now Wassup won't even load. It just stalls. Sometimes the page will load with no graph and no data, it will just be blank.

   Is this a timeout issue or is there a way to optimize the queries. I am saving all data because I wanted to run year-over-year comparisons eventually as well as view monthly trends, but now even the last 24 hours won't load. I guess I'm just wondering if there is a threshold where Wassup wasn't really intended to pass. It would be a shame because it is the best traffic tracking software I've seen. I was using Slim-Stat too but it really doesn't tell me anything I really want to know about how users interact with the site.

   Not sure if this is a real "bug" or not. I'm running WP 2.5 and using FAST CGI install of PHP 5.

   Posted 3 years ago #
2. 

   Michele
   Key Master

   rtiger we know the problem, WassUp slows down its query when there are a very lot of records per day. I'm working on it to optimize the queries but it's an hard work.
   We apologize.

   Michele - WassUp Project

   Posted 3 years ago #
3. 

   helene
   Moderator

   Hi rtiger,
   Congrats on your site's success!
   I've got some ideas on possible work-arounds for your problem, if the trouble you are having in only in the "visitor details" screen:

   • Like Michele said, lots of records causes visitor detail queries to slow down. But it is probably your browser that is timing out, not WassUp. Try switching to another browser. I find that IE does a better job than Firefox when it comes to giving a slow page enough time to load.
   • Pagination may have failed or is also slowing down the page load even more because of the large number of records. Go to Wassup==>Options==>General Setup and adjust setting for "Number of items per page". Try experimenting by doubling or tripling the number, and if that makes no difference, try halving the number, instead. If you can't select Wassup "Options" submenu, you can type this direct address in your browser, instead: http://mywordpressURL.com/wp-admin/admin.php?page=wassup-options replace "mywordpressURL.com with the URL of your wordpress install.
   • Your web server's PHP memory allocation setting could be too low. Some servers have a default of 8MB which is too low. This value should be between 32-128M and is set in your php startup file, php.ini or php5.ini. If you know how to edit this file, add or change the memory_limit to:
     

     memory_limit = 64M ; Maximum memory per script

   Good luck and let us know if any of these help.

   -Helene D.
   http://techfromhel.webege.com

   Posted 3 years ago #
4. 

   rtiger
   Member

   I set the memory_limit to 64M (it was set at 32M). I then restarted IIS to make sure it took effect. I also upgrade to the most recent Wassup version which I believe was released today.

   The Current Visitors loads great.
   The Spy Visitors loads great.

   But the Visitor Details stalls. I tried changing the number of posts per page to 10 and that didn't help.

   Posted 3 years ago #
5. 

   Michele
   Key Master

   @rtiger thank you very much for your reports it is very useful for us.
   I'm planning to find some solutions to speed up the visitor details, I'll open a new ticket to the trac site (http://trac.wpwp.org) with the highest priority because this is an understimated problem I have to fix as soon as possible.

   Please could you tell me how much big is the WassUp db table? You can find the right size in the "options view" under the "Manage Files & Database" tab ("Current WassUp table usage is ...").
   Thank you again

   Posted 3 years ago #
6. 

   rtiger
   Member

   The current size is 333 MB and 567,707 records. It would be a lot higher but after it crashed I disabled the plugin for over a week. There would probably be close to 1 million records at the rate I was going.

   The whole site was slowing down due to the overwhelming traffic but that was another issue. I optimized the code as much as I could, started caching some of the pages, switched to Fast CGI PHP install, removed some plugins that were causing needless hits to the web server (like social bookmarking links that go and get the gif icon for each bookmarking site). There were about 57 hits to the web server on each page load. I've cut that in half.

   So far the site is performing much better but Wassup still isn't loading.

   By the way, I'm using PHP 5, Windows XP on a dedicated web server and dedicated SQL Server. Hope that helps.

   Posted 3 years ago #
7. 

   helene
   Moderator

   Hi rtiger,
   I have one more thing for you to try. The slow load of the large number of Wassup records on your site could be triggering PHP script timeout and that could be why Visitor detail hangs. To fix, increase your PHP script execution timeout limit to a value higher than the default of 30 seconds, but not too much higher because it could affect page load. In php.ini or php5.ini, add or change the setting:

   max_execution_time = 45 ; Maximum time for a script to run, in secs

   Good luck.

   Posted 3 years ago #
8. 

   Vlad
   Member

   Helene, Rtiger, just take a look at the queries WassUp is executing:

   SELECT timestamp, urlrequested FROM wp_wassup WHERE wassup_id='9cc94d7fc4822905663ec536fcd2e99e' ORDER BY timestamp ASC

   This makes MySQL use filesort. Filesort on a large table can literally kill the server. I have done this:

   ALTER TABLE wp_wassup DROP KEY wassup_id, ADD KEY wassup_id (wassup_id, timestamp)

   Now the page loads in 2 seconds instead of 12.

   Another problem is INSERTs. Every visit results in two INSERTs - one goes to wp_wassup table, the other - to wp_wassup_tmp. When MySQL is doing INSERT, it has to update all indices in the table (waasup_id is VARCHAR(100)... omg). This is slow. To make it faster use INSERT DELAYED instead of INSERT and/or

   ALTER TABLE wp_wassup DELAY_KEY_WRITE = 1
   ALTER TABLE wp_wassup_tmp DELAY_KEY_WRITE = 1

   PS - just run all queries WassUp performs through EXPLAIN and you will see why it is so slow.

   Posted 3 years ago #
9. 

   Michele
   Key Master

   Thank you very much Vlad, your changes will be available in the next WassUp version

   Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.