Big Call Business Scenarios and Solutions - Tasks

background Most mobile APP s will have function modules to do tasks and receive rewards. The purpose of this kind of demand is to cultivate user usage habits, improve user activity, get credit reward for completing tasks, exchange goods or charge charges through credit, WeChat and so on. Draw up a requirement scenario (Fig.), outline: Add a sm ...

Posted on Mon, 06 Apr 2020 09:35:06 -0700 by Chef-Mars

MySQL benchmark tool

1, Benchmarking Benchmark is a kind of stress test for system design. Benchmarking is simplified stress testing. 1.1 common indicators TPS QPS response time Concurrency 1.2 script for data collection and analysis The shell script gather.sh for collecting data #!/bin/sh INTERVAL=5 PREFIX=$INTERVAL-sec-status RUNFILE=/home/benchmarks/running m ...

Posted on Sun, 05 Apr 2020 22:26:11 -0700 by Cheeseweasel

055.Python front end Django model ORM

In the process of centos experiment, pymql always had attribute errors, which made it difficult to find out the problems. A ubuntu desktop system was built again, and pycharm development tool was used as the learning and development tool. The specific reason was that there was a problem in project naming, which was in conflict with its own modu ...

Posted on Sun, 05 Apr 2020 21:30:19 -0700 by OM2

What is the difference between 127.0.0.1 and localhost in connecting to mysql database

1, The difference between 127.0.0.1 and localhost in connecting mysql database 1. Connection of localhost to mysql database mysql -h localhost -uroot -p 2. The following is 127.0.0.1 connecting to mysql database mysql -h 127.0.0.1 root -p I don't know how you see the connection is different. Let me analyze ...

Posted on Sun, 05 Apr 2020 18:07:25 -0700 by elementaluk

Solution to slow page turning with Limit after MySQL data volume increases

1. Problem status The existing MySQL data table event_data has a data volume of 300000 +, as follows: mysql> select count(1) from event_data; +----------+ | count(1) | +----------+ | 367961 | +----------+ 1 row in set (0.05 sec) It takes 382 seconds to use SQL limit paging query, as follows: SELECT a.* FROM event_data a WHE ...

Posted on Sun, 05 Apr 2020 17:18:52 -0700 by CG_dude

Just got a CentOS 7 server, what Java programmers should do

1. Uninstall and install JDK Uninstall the original OPENJDK of the server and install the JDK of ORELOC Check if jdk is installed rpm -qa | grep jdk If so, uninstall and then install rpm -e --nodeps java-1.7.0-openjdk Go to Oracle to download a JDK, upload it to the server, and then install it 2. Installation of maven Download, decomp ...

Posted on Sun, 05 Apr 2020 07:59:16 -0700 by abhic

prepare usage of MySQL

MySQL officially refers to prepare, execute and deallocate as PREPARE STATEMENT, which is used to be called preprocessing statement. The following is a detailed introduction. Sample code PREPARE stmt_name FROM preparable_stmt EXECUTE stmt_name [USING @var_name [, @var_name] ...] - {DEALLOCATE | DROP} PREPARE stmt_name   Here's a chestnut ...

Posted on Sun, 05 Apr 2020 01:42:57 -0700 by dsinghldh

A backup and restore of MySQL database in production environment

Background The company's production environment some application databases are deployed on the VMWare platform. In order to save costs, leaders are now considering migrating all data to the CAS platform living in KVM. The V2V migration was done before, but the efficiency is not high. It combines the time cost and other ...

Posted on Sat, 04 Apr 2020 16:31:01 -0700 by bob_marely

mysql installation and master-slave setup

Main storehouse: MySQL installation on CentOS 6.2: yum -y install mysql mysql-server mysql-devel mysql-libs After installing MySQL, change the configuration / etc/my.cnf: [mysqld] datadir=/data/mysql socket=/var/lib/mysql/mysql.sock user=mysql port=3306 # Disabling symbolic-links is recommended to prevent assorte ...

Posted on Sat, 04 Apr 2020 01:33:38 -0700 by OOP

GCC compilation and cmake installation of percona-server-5.6 under CentOS 6.5

percona-server-5.6.25-73.1 installation notes -- compilation Collection Stone 2012  Published 3 years ago Reading 1744 Collection 1 Point 0 Comment 0 [Tencent cloud] buy domain name and send it to cloud resolution + SSL certificate + website building! >   Absrtact: install the latest version of percona-server-5.6.25 ...

Posted on Fri, 03 Apr 2020 17:09:12 -0700 by bweekly