Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I found that server performance can be "upgraded" by a various of things, some of them are:</p> <ol> <li><p>Figuring out how much memory you need to let MySQL go through all your data but also providing a cash of executed SQL queries. You can read all memory related stuff <a href="http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html" rel="nofollow">here</a> and <a href="http://dev.mysql.com/doc/refman/5.5/en/memory-use.html" rel="nofollow">understand how it works</a>. After that you can <a href="http://dev.mysql.com/doc/refman/5.5/en/large-page-support.html" rel="nofollow">Enabling Large Page Support</a></p></li> <li><p>I found that you can improve performance by enabling <a href="http://chrisgilligan.com/wordpress/how-to-configure-apc-cache-on-virtual-servers-with-php-running-under-fcgid/" rel="nofollow">APC</a> where you can actually see how it improves your performance. Also have a look at <a href="http://chrisgilligan.com/consulting/tuning-apache-and-mysql-for-best-performance-in-a-shared-virtual-hosting-environment/" rel="nofollow">this</a>.</p></li> <li><p>Using <a href="https://www.varnish-cache.org/" rel="nofollow">varnish</a>, but thats a long story to type out here. It comes down to it that you need a very good config for it to work perfectly.</p></li> <li><p>If you're still having problems, try using <a href="http://code.google.com/p/webgrind/" rel="nofollow">Xdebug</a> to find out what is holding up each process. You could do that last one from the start though, as your MySQL will try to execute everything u ask from it, but 1 process at a time. Therefor it will store every process it can't execute in the memory and if that happens allot, it will overflow your memory.</p></li> </ol> <p>My conclusion was that, how more php/mysql related stuff (what your server needs time/resources for) that you can re-use by getting it from your cash (Varnish, APC, MySQL mem), the more connections it can handle without creating high server load.</p>
    singulars
    1. This table or related slice is empty.
    1. POHigh server load caused by mysql
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgelleby
    1. USgelleby
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COHello Gelleby, 1. okay I will look into that. 2. we have apc-enabled. I will add it to my original post, forgot to mention it. 3. we have varnish installed version 3.0.4. 4. Okay good tip I will try it.
      singulars
      1. PO
      1. USSander
    2. COHi Sander, what does APC tell you? Can you post the graph please? What config do you use for varnish? And finally are u sure each WP and Magento site is running with good coding?
      singulars
      1. PO
      1. USgelleby
    3. COHello Gelleby, Please see our APC diagram here: http://www.emega.nl/apc-diagram.jpg Regarding our Varnish configuration we have integrated the Phoenix PageCache extension and it comes with a configuration file which we modified to our ports and ip address. I can post the configuration file above if you would like but I think there is something wrong in our mysql configuration which I am unable to find, hence my post here.
      singulars
      1. PO
      1. USSander
 

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