Upload large < 100MB of PDFS to MySQL using PHP, Is my settings ok?
| From: | Louie Miranda | Date: | Thu, 02 Apr 2009 07:33:24 +0000 |
| Subject: | Upload large < 100MB of PDFS to MySQL using PHP, Is my settings ok? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-290946@lists.php.net to get a copy of this message | ||
Guys,
I need help on the php and mysql configurations.
I want to be able to upload < 100MB to MySQL using PHP.
On PHP, php.ini is as follows:
> max_execution_time = 1000000 ; Maximum execution time of each script, in
> seconds
> max_input_time = 1000000 ; Maximum amount of time each script may
> spend parsing request data
> memory_limit = 100M ; Maximum amount of memory a script may consume
> (8MB)
> post_max_size = 100M
> upload_max_filesize = 100M
>
On MySQL, my.cnf:
> key_buffer = 500M
> max_allowed_packet = 5M
> table_cache = 256
> sort_buffer_size = 1M
> read_buffer_size = 1M
> read_rnd_buffer_size = 4M
> myisam_sort_buffer_size = 128M
> thread_cache_size = 16
> query_cache_size= 64M
>
The mysql field is set to LONGBLOB
What configurations could I alter more? Because right now, it is just
uploading around 30mb or something? And, no error. Maybe, something is wrong
on the config?
--
Louie Miranda (lmiranda@gmail.com)
http://www.louiemiranda.net
Quality Web Hosting - www.axishift.com
Pinoy Web Hosting, Web Hosting Philippines