Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Log into your backend, use the customer maintenance dropdown to find the entry Online Customers and check the quantity. Sort by IP and stuff the results from the largest quantity into Bots Vs Browsers to see if they're legit web indexers. You can temporarily 403 the traffic from specific IPs if it's not.</p> <p>If you cannot log into the back end, then you need to start doing server access log analysis to find out where all the traffic is coming from.</p> <p>How to fix this problem. If you're on shared hosting, you need to find something better. While increasing the max connections for MySQL on a dedicated server will help, that's dependent on having enough iron on the backend to actually run the database with the increased load. Increasing max_connections indiscriminately can stop the error, but make the site deadly slow if the server is below par.</p> <p>Get a page caching module so Magento isn't being run every time a guest account loads a page. Combine this with APC cache to do opcode caching.</p> <p>We've been intermittently experiencing this message during the last week because we got hit by Google, Bing, Yahoo, Baidu and Yandex deciding to refresh all at once. There was a security update for Litespeed web server that rendered its version 5.1 of php incompatible with APC cache and we had to disable it till we run an upgrade.</p> <p>With Magento, the errors involving "Too many connections" or "Max connections exceeded" are telling you that your server is being overloaded. This can be because a) you have a weak server and it cannot keep up with your customers, b) your server was adequate for the number of users you expected, but you forgot that the requests generated by web indexers like Google are the majority of your traffic and must be calculated for, or c) you're being hit by a DDOS attack.</p> <p><strong>Note:</strong> Under certain conditions, if you are not noticing overwhelming incoming traffic at this point in time, the mysql server may need to be restarted in order to reset record locks from a previous traffic spike that's caused MySQL to exceed its connection limit.</p>
    singulars
    1. This table or related slice is empty.
    1. PODon’t know whats wrong with MAGENTO?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USFiasco Labs
    1. USFiasco Labs
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODon’t know whats wrong with MAGENTO?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload