Docker MySQL Stress test Task: Create environment to run series of read/write queries to real MySQL server. Before make real experiments I tried to… Continue reading “Docker MySQL Stress test”…
Fix import huge database into Docker MySQL container When I tried to import dump file using mysql command I saw ‘lost connection’ or ‘server has gone away’ error…… Continue reading “Fix import huge database into Docker MySQL container”…
WP fix run site locally WordPress has option(s) with site URL. To change them to new one use next SQLs: UPDATE `wp_options` SET `option_value` =… Continue reading “WP fix run site locally”…
WP set category to post within SQL I have a stored procedure and want put posts in the MySQL event to some category (such Archive). wp_term_relationships (object_id,… Continue reading “WP set category to post within SQL”…
Mongo DB: Sharding scripts Configuration of few mongoDB servers to work as one: Continue reading “Mongo DB: Sharding scripts”…
Bank bills database application PP: Application for preparing bank bills Continue reading “Bank bills database application”…
Bank bills database (Pro) application PP (Pro): Application for preparing bank bills with addition functions Continue reading “Bank bills database (Pro) application”…
Subway union database application PP: Application for Subway Union Continue reading “Subway union database application”…
Railway Union database application PP: Application for Railway Union Continue reading “Railway Union database application”…
RCKTO database application PP: Application for Railway Center Continue reading “RCKTO database application”…