1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Buying Looking for a Wordpress Expert figure out why site keeps going down

Discussion in 'Programming' started by YesBoss, Aug 3, 2017.

  1. #1
    Hello,

    I have a site which uses an auto draft post plugin and everytime its turned on it brings out the site numerous times. I need to prevent this from keep happening.

    The plugin is used on other sites and works normally. Its causing issue on one of the site.

    I will not give you access to my site unless you are an active user or have a good rep here.

    Thanks
     
    YesBoss, Aug 3, 2017 IP
  2. Nigel Lew

    Nigel Lew Notable Member

    Messages:
    4,642
    Likes Received:
    405
    Best Answers:
    21
    Trophy Points:
    295
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Have you tried increasing the memory usage allotted to wp?

    This typically would go on line 39 of wp-config
    define('WP_MEMORY_LIMIT', '256M');
     
    Nigel Lew, Aug 4, 2017 IP
    YesBoss likes this.
  3. Allen James

    Allen James Active Member

    Messages:
    120
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    53
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Increasing the memory is helping in similar cases, but you can write it almost everywhere in the file, the number of the line can vary and you can't say that exactly there is the place as you are not sure how his wp-config.php file looks like.
     
    Allen James, Aug 4, 2017 IP
  4. YesBoss

    YesBoss Well-Known Member

    Messages:
    255
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #4
    Thanks for the advice but it did not work. It still brings the server down.
     
    YesBoss, Aug 4, 2017 IP
  5. YesBoss

    YesBoss Well-Known Member

    Messages:
    255
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #5
    More Details on the Issue:

    The site publishes around 400 posts a day. But initially its saved in DRAFT and the plugin takes those Draft posts and publishes them in certain intervals. Soon as the plugin is turned on it starts the publishing process but randomly the site will show Error establishing a database connection.

    It does get the job done eventually, but due to server downtime it affects the site. The plugin does thru this process for about 5 hours and the site would be done for total of 1 hour throughout the 5 hour process.

    As mentioned before, I use this plugin on other sites and there is no issue there. Also - NOTE: the site it causes issue in has massive amount of published posts... inc
     
    YesBoss, Aug 4, 2017 IP
  6. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,197
    Likes Received:
    818
    Best Answers:
    7
    Trophy Points:
    320
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    So, according to this, your process is working for one hour and sitting idle for four hours? Four hours of useless downtime is a lot. Why is your process idling for those four hours? Is there an infinite loop somewhere in the process?
     
    mmerlinn, Aug 5, 2017 IP
  7. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    As Seller:
    100% - 2
    As Buyer:
    100% - 0
    #7
    Are you on Shared Hosting Server? You should find out the limit of concurrent MySQL connections?
    As your plugin is unable to establish database connections => the above limit could be the issue.
     
    krishmk, Aug 5, 2017 IP
  8. YesBoss

    YesBoss Well-Known Member

    Messages:
    255
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #8
    Im on a GRID server with MediaTemple. Can the limit be increased by asking the Host?
     
    YesBoss, Aug 5, 2017 IP
  9. krishmk

    krishmk Well-Known Member

    Messages:
    1,376
    Likes Received:
    40
    Best Answers:
    0
    Trophy Points:
    185
    As Seller:
    100% - 2
    As Buyer:
    100% - 0
    #9
    Yes your Hosting guys would be the best to contact to find out if the MySQL limit can be increased.
    Alternatively you could also check if you could optimize your plugin settings (# of posts to process per run and the cron frequency) to work within your available Server resources.
     
    krishmk, Aug 5, 2017 IP
  10. YesBoss

    YesBoss Well-Known Member

    Messages:
    255
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #10
    No it doesnt sit idle. The plugin publishes 3 draft post every 120 sec. When performing this task it brings the site down several times for 5-10min. But it gets the job done when its not down. Something is causing the site to go down and thats the solution im looking.
     
    YesBoss, Aug 5, 2017 IP
  11. creativeGenius

    creativeGenius Well-Known Member

    Messages:
    273
    Likes Received:
    5
    Best Answers:
    1
    Trophy Points:
    120
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #11
    the log should give you valuable info on why the site goes down, based on what you said, "this particular site contains a lot of posts", there could be a problem with the way it queries the database to select the posts to publish
     
    creativeGenius, Aug 6, 2017 IP
  12. YesBoss

    YesBoss Well-Known Member

    Messages:
    255
    Likes Received:
    24
    Best Answers:
    0
    Trophy Points:
    128
    As Seller:
    100% - 0
    As Buyer:
    66.7% - 2
    #12
    Yes i believe that is the issue as well. Any solution how i can fix this mess?
     
    YesBoss, Aug 7, 2017 IP
  13. robert4u

    robert4u Greenhorn

    Messages:
    46
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    8
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #13
    It seem that your current draft plugin need many resources either move to vps or get another plugin there are many plugins for specific job which may need less resources.
     
    robert4u, Aug 7, 2017 IP
  14. creativeGenius

    creativeGenius Well-Known Member

    Messages:
    273
    Likes Received:
    5
    Best Answers:
    1
    Trophy Points:
    120
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #14
    Well, i cant see your code but a good guess would be to optimize the queries, create indexes in the db if possible, worst case scenario is you will have to move your site to a better host.

    I could look at the plugin and check the queries, just drop me a pm
     
    creativeGenius, Aug 8, 2017 IP