Hall of Fame

[Abraham]

Files over  300 mb do not play on the site. They are being converted, if enter directly through the link www.site.com/media/ 0b3d48e943366092ad4a5a6324ba4150.mp4 they are playing.   But in site always seen
This video is currently being processed. Please check in a few minutes.
What's the problem?

[PHPVibe A.]

Hi, videocron.php timeout.
Increse the max execution time, ffmpeg conversions are heavy and take time.

[Abraham]

Hi,
Increase

Code Select Expand

//Run conversions
$crons = $db->get_results("select id,tmp_source,token from ".DB_PREFIX."videos where tmp_source != '' and source = '' limit 0,100000");

to limit 0,1000000 - but there are no changes.
Can you specify which parameter be increase or need  add videocron .php to server cron?
The videocron .php  path is   /home/admin/web/xxx.com/public_html/videocron.php
OS Centos 6.5

[PHPVibe A.]

You need to increase the limit in the server for execution, not code
http://stackoverflow.com/questions/5140258/increase-php-script-execution-time
http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/CronJobs#Adding a cron job

[Abraham]

Ok.
Only increase max_execution_time or increase and add to cron job?

[PHPVibe A.]

Ok.
Only increase max_execution_time or increase and add to cron job?

Do the cron job also.
But remove the shell_exec if you do the cron:

file lib/upload-ffmpeg.php

right after

Code Select Expand

//Needs converting
$db->query("INSERT INTO ".DB_PREFIX."videos (`date`,`pub`,`token`, `user_id`, `tmp_source`, `thumb`) VALUES (now(), '0','".$token."', '".user_id()."', '".$file."','uploads/processing.png')");

Remove this lines:

Code Select Expand

$binpath = get_option('binpath','/usr/bin/php5');
$command = $binpath." -f ".ABSPATH."/videocron.php";
exec( "$command > /dev/null &", $arrOutput );

[Abraham]

I did as you said, but again while uploading large files they are converting but don't play on the site. An error accures from CRON, in case of outting whitout /dev/null   this error appears.

Code Select Expand

video:4kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: unknown
PHP Warning:  MySQL server has gone away in /home/admin/web/xxxx.com/public_html/lib/class.ezsql.php on line 249
PHP Warning:  MySQL server has gone away in /home/admin/web/xxx.com/public_html/lib/class.ezsql.php on line 249

or another

Code Select Expand

    Metadata:
      encoder         : Lavc55.67.100 mjpeg
Stream mapping:
  Stream #0:0 -> #0:0 (mpeg4 (native) -> mjpeg (mjpeg))
Press [q] to stop, [?] for help
frame=    1 fps=0.0 q=4.7 Lsize=N/A time=00:00:00.04 bitrate=N/A    
video:14kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: unknown
PHP Warning:  MySQL server has gone away in /home/admin/web/xxx.xx/public_html/lib/class.ezsql.php on line 249
PHP Warning:  MySQL server has gone away in /home/admin/web/xxx.xx/public_html/lib/class.ezsql.php on line 249
PHP Warning:  chmod(): Operation not permitted in /home/admin/web/xxx.xx/public_html/lib/class.ezsql.php on line 329
PHP Warning:  chmod(): Operation not permitted in /home/admin/web/xxx.xx/public_html/lib/class.ezsql.php on line 329

[PHPVibe A.]

Code Select Expand

MySQL server has gone away in

This is the problem. The ffmpeg conversion puts down the system.
What hardware config you use?

[Abraham]

Intel® Core™ i7-4770
Quadcore Haswell,
32 GB DDR3 RAM,
2 x 240 GB SATA 6 Gb/s SSD
Nginx as front, with Apache for backend.
Panel - Vesta

[PHPVibe A.]

Then most probably it's an system optimization issue, since the hardware looks solid.
When converting a video file, have you checked your processes and load rate? From ssh or the panel...

[Abraham]

Ok. I have one configurations file
/etc/my.cnf
***********************************************
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

#innodb_use_native_aio = 0
innodb_file_per_table

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
***************************************

[PHPVibe A.]

https://forums.cpanel.net/f189/best-optimization-my-cnf-269391.html#post1139451
[This one even explains it] http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm
http://www.cyberciti.biz/tips/enable-the-query-cache-in-mysql-to-improve-performance.html

Thanks Alex, decided everything.   
as you said, it was necessary to optimize mysql do.
in general, who will be a similar problem, here is the solution:

wait_timeout = 600
max_allowed_packet = 64M

[Abraham]

Thanks,
max_allowed_packet = 128M fix it.