Databases
StackOverflow2013
Usersdbo
USQuantico773
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USQuantico773
    primarykey
    data
    text
    plurals
    1. PODebugging Memory Leak, PHP and MySQL Blob Streaming File Download
      singulars
      1. PTQuestion
    1. POMySQL Binary Storage using BLOB VS OS File System: large files, large quantities, large problems
      singulars
      1. PTQuestion
    2. PODebugging Memory Leak, PHP and MySQL Blob Streaming File Download
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COOk, i put in the mysql_unbuffered_query and it works perfectly. Just to expand on the function of mysql_unbuffered_query, it locks the table for any writes/reads while its getting the result set, but this is fine for the application i require. Also, in reply to your advice to move the files out of the database, i have many good reasons for having them in the database, and (now) not one reason for using the file system! I have many reasons for now using the file system though. All to do with Security, storage, collating, access privs, etc.. Hafichuk, once again thank you so much for your help!
      singulars
      1. PO
      1. USQuantico773
    2. COHi hafichuk, I added this line into the while loop, and as I replied in comment above, it appears to work but only to the limit of the memory_limit directive. If I am to be downloading files that could be say 500mb, would I need to increase the memory_limit directive in php.ini? or is the ob_flush able to handle any file size, regardless of the directive, but just that my code is incorrect in another place? Many thanks for your help.
      singulars
      1. PO
      1. USQuantico773
    3. COhafichuk you are a legend! That works (almost) perfectly. Just to let you know, it appears to work to the full allowance of the memory_limit directive, so if I have it set to 128M, and try a 140mb file, it works, but if I try to download a 250mb file, it gets to about 200mb streamed and fails, with the php error: [31-Oct-2011 11:46:01] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 132392961 bytes) in /root/htdocs/file_manager/file_manager_download.php on line 125, which is the ob_flush(); line.
      singulars
      1. PODebugging Memory Leak, PHP and MySQL Blob Streaming File Download
      1. USQuantico773
 

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