[L5] Database connection time

set_time_limit($seconds)

$seconds being the maximum execution time, in seconds. If set to zero, no time limit is imposed.

The error you are getting is PHP-related, not database related.

Hope I could help.

if your query gets > 30 s to execute something is wrong, you should focus on optimizing it.

It is not a good solution to increase the max execution time.

I agree with @pmall though.

@toniperic @pmall Yes I know, But it is for Admin panel where Admin register an organization and in background I will perform some tasks like:

1. create database
   
2. Migrate
   
3. Create view
   
4. add default values to database
   etc
   That is why it will take more than 30 secs.
   
   

@toniperic Thank you that solved my prob. But why dint

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);

worked? And is that set_time_limit() laravel helper or php function()?

Because you are setting mysql.connect_timeout, and the error says the script has exceeded maximum execution time limit. It doesn't mention anywhere it has anything to do with mysql, it's only your presumption.

set_time_limit is a PHP function. It should work if you tried this.

ini_set('max_execution_time', $seconds);

@toniperic that makes sense. Thank you for explanation. :D

Sure, no problem.

btw making someone wait 30 seconds in 2015 is a terrible idea. :)

@SachinAgarwal this is a canonical example of a job you should make an artisan command for and queue it.

Don't modify the time limit it is not an solution. What if you server start to slow down and exceed your new time limit

@toniperic I'm making myself wait for more than 30 secs :P Its like for general public it will be faster. But when I (SuperAdmin) register the organization Then have to perform some task. And instead of doing it one by one, I made a script to do them all in once.

@pmall That is nice idea. I will give it a shot. Thank you for suggestion :D