Databases
StackOverflow2013
Usersdbo
USuser8109
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USuser8109
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. POjQuery droppable issue
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COrunning top shows the system doesn't running out of physical RAM while the query is running. It dropped to around 60MB just before crashing, but still had 1.6GB of swap space. This was a great suggestion and it may have lead me to the actual answer, so thanks for that. I'm just testing now.
      singulars
      1. PO
      1. USuser8109
    2. COThanks pcguru - this makes sense and fits the facts. To answer your questions: PHP is run as a module. There is swap space available and being used - it's a virtual server running 8 sites. There are some largish DB tables - biggest has 2.4 million records. There are plenty of site visitors, and this report is one of dozens their staff could be running. Your explanation also answers another puzzle, which is why did the report succeed in the wee small hours the night before (when I thought I'd fixed the problem :-). I'm about to watch it run with top in another window.
      singulars
      1. PO
      1. USuser8109
    3. CO@LotusH I see what you mean - on clicking the 'log in' link (for example), the page doesn't load the way an HTML page normally loads. But neither is the content being pulled in by Ajax. Have you examined Tumbler's source as suggested above? You'll find they're using Prototype, have a very interesting set of body tag parameters, and a suspicious looking log-in link. The parameters in the body tag and log-in link remind me of the way pages are handled by jQuery Mobile, and I suspect are the key to the effect you're after.
      singulars
      1. PO
      1. USuser8109
 

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