MySQL

Hints on import big sql 50GB above to MariaDB or MySQL

MySQL /

Access to MySQL You have to be root to set those settings # mysql -u root -p Maximize all Buffer and Packet Set network buffer length to a large byte number and set maximum allowed packet size to a large byte number set global net_buffer_length=1048576; set global max_allowed_packet=1073741824; SET foreign_key_checks = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; Import your SQL file Import your sql dump file, you can import more than one file source file-to-import.sql; Set back to default Reme[…]

Hints on import big sql 50GB above to MariaDB or MySQL Read More »

An error occurred while installing mysql2 (0.5.2), and Bundler cannot continue.

2 Comments / MySQL, Ruby /

Gem files will remain installed in /var/www/discourse/vendor/bundle/ruby/2.5.0/gems/mysql2-0.5.2 for inspection. Results logged to /var/www/discourse/vendor/bundle/ruby/2.5.0/extensions/x86_64-linux/2.5.0-static/mysql2-0.5.2/gem_make.out An error occurred while installing mysql2 (0.5.2), and Bundler cannot continue. Make sure that gem install mysql2 -v ‘0.5.2’ –source ‘https://rubygems.org/‘ succeeds before bundling. In Gemfile: mysql2 I found the best way to solve the problem. I think that you may missing

An error occurred while installing mysql2 (0.5.2), and Bundler cannot continue. Read More »