...pg_database ORDER by size_in_mb DESC; Want to see database sizes in MySQL...
...technical tasks which cannot be directly linked to customer value. Things like “Upgrade to MySQL 6.0″ or “replace magic numbers with enums” need to be done. How can you prioritize...
...supported; consistently good performers; failure free as possible; free. Using these criteria they selected: MySQL, Solr, Memcache, and Redis. Cassandra and Mongo were dropped...
...BigDecimal('12.3413') gross = net * VAT_RATE # gross is now a BigDecimal ActiveRecord models represent MySQL's DECIMAL columns as BigDecimal attributes. Keep in mind that values assigned to such attributes...
...json and array take away a lot of the pain that you had on MySQL projects. Example use cases for array are tags or storing foreign keys (instead of a...
Open a MySQL root shell and use this command: PURGE BINARY LOGS BEFORE DATE(NOW() - INTERVAL 3 DAY) + INTERVAL 0 SECOND...
...to migrate to Minidusen, which extracts those parts from Dusen. Minidusen is compatible with MySQL, PostgreSQL and Rails 3.2, 4.2 and 5.0. If you are looking for a full text...
...second SELECT statement with a subselect. Note that sub-queries are extremely slow in MySQL, but they can make cases easier where performance does not matter so much (e.g. a...
...ruby-debug and use e.g. byebug Remove gem oniguruma Remove gem fastercsv Replace gem mysql with mysql2 Update gem capistrano 2.12.0 to ~>2.12 when bound for Ruby 1.8.7 and remove...
...have existing data that needs to be cleaned, do it in a migration, using MySQL's TRIM function: class StripWhitespaceFromOrganisation < ActiveRecord::Migration def change update 'UPDATE organisations SET name = TRIM...
Best results in other decks
If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query:
...to use the less safe log_bin_trust_function_creators variable) login into the mysql container docker exec -it wow-mysql-cont /bin/bash cd /etc/mysql/ cp my.cnf mycnfbk
echo 'log_bin_trust_function_creators = 1' >> my.cnf OR login as root user mysql -h50.0.0.41 -uroot -p mysql> set global log_bin_trust_function_creators=1; cleaning dump database...