Results 1 to 9 of 9
  1. #1
    Join Date
    May 2006
    Posts
    80
    Plugin Contributions
    0

    Default MySQL user crashing servers MySQL

    My Servers MySQL keeps turning off and all the websites on the server can not connect to the respective database.

    This has happened a couple of times in the past week.

    I checked the MySQL logs and its showing 30 or so messages relating to my Zencart database MySQL user:

    MyZenCartdatabaseUser [Warning] /usr/libexec/mysqld: Forcing close of thread

    Im running a modified ZenCart 1.37. The site has been running fine for a couple of years, and I haven't modified anything recently.

    However we are constantly adding new products (about 10,000 currently).

    If anyone has any knowledge or ideas about this it would be greatly appreciated.

    Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: MySQL user crashing servers MySQL

    There are a couple of modules to lighten the mysql loading recently created and these might assist....but with only 10,000 items you should not be having issues...
    We have carts with 100,000+ items running well
    Zen-Venom Get Bitten

  3. #3
    Join Date
    May 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: MySQL user crashing servers MySQL

    Thanks for the reply.

    I have established the problem now, but would like to know the best solution.

    China Hacker is sending thousands of requests to url's that don't exist.

    I have an SEO module installed.
    They are sending requests such as

    contact-us.hblahblahml
    rather than contact-us.html

    I have put into place temporary solution but not sure what the best solution is?

  4. #4
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: MySQL user crashing servers MySQL

    Do you sell to China?
    If not block the country
    Zen-Venom Get Bitten

  5. #5
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: MySQL user crashing servers MySQL

    If they are originating from the same IP address range, block the IP address range on your server.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  6. #6
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: MySQL user crashing servers MySQL

    Heck with that... Redirect the user agent or IP from the china hacker to a page which says, this content has been printed without my permission... But here is my link"

    This is likely a scraper... Automating your content. They very seldom, sometimes never notice that you have done this and you can grab some relevant traffic from their theft.

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  7. #7
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: MySQL user crashing servers MySQL

    Quote Originally Posted by mprough View Post
    This is likely a scraper... Automating your content.
    What could they be scraping from non-existent pages?
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  8. #8
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,009
    Plugin Contributions
    61

    Default Re: MySQL user crashing servers MySQL

    The non existent urls are caused from people linking to their generated content... Many scraper sites use a dynamic platform and sessions to produce real time scraped content... So the user gets urls like

    mysite.com/index.html?jhbdfb or similar... But these pages are produced in real time, so the scraper site visitors link to pages which can never be reproduced.

    A very common one of these is a site which displays content for folks at work behind a firewall... Work Friendly. These use this type of platform and until recently their results for site were allowed to be indexed... In fact duplicating all pages of every user added site in their database.

    Redirecting the user agent effectively prevents this as the visitor is returned to the site of origin respectively. Blocking them if accomplished does nothing to gain from the incident. Many of these site crawl with one IP/User agent and produce results with another so you are forced to search your logs to find the correct IP/agent to deny access for... When if you just grab these urls as they are being called for you can convert this into a positive situation.

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  9. #9
    Join Date
    May 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: MySQL user crashing servers MySQL

    Thanks for everybodys helpful response.

    One thing I have also noticed is we did not have a custom 404 page up i.e. a zencart one with the sitemap. So instead it was linking to a server 404 error document. Im not sure if that was causing problems with the SQL database.

    Anyway I've blocked the IP range for the time being. Im a bit dubious of blocking the whole of China, even though 99% are unwelcome visitors. I do not want it to effect google rankings in other Asia countries.

 

 

Similar Threads

  1. Mysql server constantly crashing
    By PatF in forum General Questions
    Replies: 9
    Last Post: 4 Jul 2010, 11:42 AM
  2. My MYsql dilemma when hopping servers
    By one1 in forum General Questions
    Replies: 7
    Last Post: 17 Jun 2009, 03:47 AM
  3. MySQL User ID/Password
    By MajorMinor in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 31 May 2009, 12:43 AM
  4. User Tracking mySQL error
    By gcceric in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 14 Sep 2007, 07:37 PM
  5. Installing MySQL database on different servers
    By ztotheetothen in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 9 Apr 2007, 05:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR