[Plugin: Twitter Tools] Made server very slow (6 posts)

  1. thefreshpage
    Posted 6 years ago #

    The latest twitter tools plugin was slowing down my entire server incredibly...as soon as we disabled it the server was back up and running extremely fast. This plugin needs to be written better, the code is obviously very flawed.


  2. gnozu
    Posted 6 years ago #

    I'd agree that the plugin isn't very well thought out. I'm now considering removing it from the wordpress mu system I maintain at my university. The problem seems to be that even for blogs which aren't using it, the default option to display the sidebar causes links to js and css files. These take seconds to load for some reason.
    Anyone using wordpress mu should avoid this plugin. Likewise busy single wordpress sites.

  3. staze
    Posted 6 years ago #

    I was having the same issue, but it turned out that it's because twitter tools keeps a DB table of all tweets you've had. Problem is, there seems to be a bug that's causing it to grab the same tweets more than once. My table grew to over 80k rows (I've tweeted less than 1000).

    Duplicated the table, then emptied out the original, and things are back to normal. It still seems to be downloading them multiple times... so until that's fixed (either a bug in the twitter api, or twitter tools), I'm just going to empty the table every couple weeks.

    Might check it out. Table is called <wordpress-prefix>_ak_twitter (so, with a default install, it would be wp_ak_twitter.

    That, combined with the SQL query to grab the tweets from the DB, made it really quite slow with 80k rows.

  4. Ted Mann
    Posted 6 years ago #

    Any good alternatives to Twitter Tools you'd recommend?

  5. staze
    Posted 6 years ago #

    Figured out (with the help of google), that if you have access to your mysql database that wordpress resides on, you can do this:

    delete from wp_ak_twitter using wp_ak_twitter,wp_ak_twitter as vtable where vtable.id > wp_ak_twitter.id and vtable.tw_id = wp_ak_twitter.tw_id;

    That will delete all the duplicate records from the table. You'll want to do an optimize table after the fact.

    This took my twitter tools table from 85693 rows (10.5MB) to 470 rows (59kb).

    Obviously twitter tools needs to implement a check before inserting rows that makes sure the twitter id doesn't already exist... but for now, this works.

    Please make sure to do a mysqldump before attempting this. I don't want to be liable for you losing your data.

    Good luck!

  6. akky
    Posted 6 years ago #

    I became to be suspecting this plugin makes my WordPress slow, and checked my DB. But the duplicated records in MySQL seems not happening on my instance now, that is, (wp_)ak_twitter table has one record for each article already tweeted. So it must be fixed on the recent version (maybe 2.1? changelog has one related DB bug fix).

    Besides this, I am seeing that the Twitter Tools plugin's Javascript and CSS files (aktt_js and aktt_css) are called a lot on web server access log. But not sure yet.

Topic Closed

This topic has been closed to new replies.

About this Topic