Recherche avancée

Médias (5)

Mot : - Tags -/open film making

Autres articles (37)

  • List of compatible distributions

    26 avril 2011, par

    The table below is the list of Linux distributions compatible with the automated installation script of MediaSPIP. Distribution nameVersion nameVersion number Debian Squeeze 6.x.x Debian Weezy 7.x.x Debian Jessie 8.x.x Ubuntu The Precise Pangolin 12.04 LTS Ubuntu The Trusty Tahr 14.04
    If you want to help us improve this list, you can provide us access to a machine whose distribution is not mentioned above or send the necessary fixes to add (...)

  • Selection of projects using MediaSPIP

    2 mai 2011, par

    The examples below are representative elements of MediaSPIP specific uses for specific projects.
    MediaSPIP farm @ Infini
    The non profit organizationInfini develops hospitality activities, internet access point, training, realizing innovative projects in the field of information and communication technologies and Communication, and hosting of websites. It plays a unique and prominent role in the Brest (France) area, at the national level, among the half-dozen such association. Its members (...)

  • Encoding and processing into web-friendly formats

    13 avril 2011, par

    MediaSPIP automatically converts uploaded files to internet-compatible formats.
    Video files are encoded in MP4, Ogv and WebM (supported by HTML5) and MP4 (supported by Flash).
    Audio files are encoded in MP3 and Ogg (supported by HTML5) and MP3 (supported by Flash).
    Where possible, text is analyzed in order to retrieve the data needed for search engine detection, and then exported as a series of image files.
    All uploaded files are stored online in their original format, so you can (...)

Sur d’autres sites (3528)

  • Evolution #3916 : perf mysql : ne pas surcharger les recherches

    4 janvier 2018, par jluc -

    Même diff mais avec adresse de fichier plus normalisée

  • Laravel MySQL DB not updating after long process

    11 mai 2022, par slanginbits

    I'm doing some video encoding using Laravel and FFMpeg using https://github.com/protonemedia/laravel-ffmpeg

    


    During the video conversion, I can perform some db updates to update the percentage complete in hls_percent field :

    


            $ffmpeg_cmd = FFMpeg::fromDisk('local_videos')
            ->open($video->filename)
            ->exportForHLS()
            ->toDisk('local_videos')
            ->setSegmentLength(3) // optional
            ->setKeyFrameInterval($key_interval) // optional
            ->onProgress(function ($percentage, $remaining = 0, $rate = 0) use ($id) {
                ItemVideo::where('id', $id)->update(['hls_percent' => $percentage]);                
            });


    


    This process works fine and the hls_percent value gets updated to 100 and the encoded video files are generated.

    


    After some files are moved, (takes several seconds) a final db update is not done.

    


    ItemVideo::where('id', $id)->update(['hls_complete' => 1]);


    


    The timeout only happens while encoding a large 150MB (10 min duration) mp4 file. Smaller/shorter videos complete the process without any issues.

    


    I have increased the following in php.ini

    


    memory_limit = 512M 
post_max_size =  1024M
upload_max_filesize = 1024M
max_execution_time = 2400
max_input_time = 2400
default_socket_timeout = 2400


    


    I modified the global variables in the MySQL database server to higher timeouts
as instructed here https://sebhastian.com/lost-connection-mysql-server-during-query/

    


    connect_timeout 2400
delayed_insert_timeout 300
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 28800
lock_wait_timeout 31536000
mysqlx_connect_timeout 30
mysqlx_idle_worker_thread_timeout 60
mysqlx_interactive_timeout 28800
mysqlx_port_open_timeout 0
mysqlx_read_timeout 30
mysqlx_wait_timeout 28800
mysqlx_write_timeout 60
net_read_timeout 2400
net_write_timeout 2400
replica_net_timeout 2400
rpl_stop_replica_timeout 31536000
rpl_stop_slave_timeout 31536000
slave_net_timeout 2400
ssl_session_cache_timeout 2400
wait_timeout 28800


    


    apache2handler :

    


    Max Requests Per Child : 0 - Keep Alive : on - Max Per Connection : 100
Timeouts Connection : 300 - Keep-Alive : 5

    


    I'm not getting an error messages in laravel or /var/log/apache2/error.log

    


    What else am I missing ? How can I keep the MySQL connection alive to make the final update ?

    


  • Revision 78050 : Nouvelle fonctionnalité (uniquement sous MySQL, dans le cadre d’une ...

    8 novembre 2013, par real3t@… — Log

    Nouvelle fonctionnalité (uniquement sous MySQL, dans le cadre d’une installation mutualisée capable de créer des bases avec un login root) :
    si jamais le config/connect.php a été rempli avec les infos de connexion "root", rajoute un bouton "Correct DB credential" qui permet :
    1) de créer l’utilisateur qui va bien, de lui donner les droits qui vont bien et de l’affecter à la base
    2) de modifier le fichier config/connect.php en conséquence

Navigation