Skip to content

Instantly share code, notes, and snippets.

@gebi84
Last active June 18, 2019 09:03
Show Gist options
  • Save gebi84/6cee36ecb4ff8813e2356c213cd6e4dc to your computer and use it in GitHub Desktop.
Save gebi84/6cee36ecb4ff8813e2356c213cd6e4dc to your computer and use it in GitHub Desktop.
debug environemnt xdebug and mysql
#http://www.serhatdundar.com/blog/import-huge-databases-faster-in-mysql
innodb_buffer_pool_size = 12G
# 60% - 70% of your RAM size
innodb_log_buffer_size = 16M
# 16M or 32M is fine
innodb_log_file_size = 3G
# 25% of buffer pool size
innodb_write_io_threads = 32
# 32 is fine, 64 is maximum
innodb_flush_log_at_trx_commit = 0
[xdebug]
xdebug.default_enable=0
xdebug.remote_autostart=0
xdebug.remote_connect_back=1
xdebug.remote_enable=1
xdebug.remote_handler=dbgp
xdebug.remote_port=9000
xdebug.idekey=PHPSTORM
xdebug.max_nesting_level=200
xdebug.profiler_enable = 0
xdebug.profiler_enable_trigger = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment