-- Create temporary table
CREATE TABLE temp_table LIKE table1;
-- Add constraint
ALTER TABLE temp_table ADD UNIQUE(category);
-- Copy data
INSERT IGNORE INTO temp_table SELECT * FROM table1;
-- Rename and drop
RENAME TABLE table1 TO old_table1, temp_table TO table1;
DROP TABLE old_table1;
/dev/sda.
print.
print, it will also display the hard disk information and model. Here is example from a real hard disk (not virtual as shown on the image above) :select” command. In the example below, I will switch from /dev/sda to /dev/sdb which is a secondary drive on my system.
"X" with the letter of the disk to which you wish to switch.mkpart“. You can give it additional parameters like "primary" or "logical" depending on the partition type that you wish to create.
mkpart. The listed units are in megabytes (MB). We will create a 10 GB partition starting from 1 to 10000:
"quit" command. We will format our new partition in ext4 file system using mkfs. To make this happen run the following command:
"resizepart". As you have probably figured this out by now, "resizepart" helps you resize a partition."print":
"1". Now run the resizepart command:"print":
"rm" command within parted. To delete a disk partition you will need to know it’s number."print". In our example, we will delete the partition with number 1 from our secondary drive /dev/sdb1:
rescue" utility that helps you recover a lost partition between a starting and ending point. If a partition is found within that range, it will attempt to restore it."on" or "off". To change a flag simply run "set" command within parted:lba flag to on for second partition. Verify the results with print:
MariaDB [(none)]> show global variables like "%slow%";+------------------------------+--------------------------------------+
mv /var/lib/mysql/slow-query.log /var/lib/mysql/slow-query.log.rm1
MariaDB [(none)]> flush logs;Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> set global slow_query_log=1;
MariaDB [(none)]> select @@global.long_query_time;+--------------------------+
ls -lh /var/lib/mysql/up-slow.log
MariaDB [(none)]> set slow_query_log=0;
wget percona.com/get/pt-query-digest
chmod 755 pt-query-digest
cp /var/lib/mysql/up-slow.log /var/lib/mysql/up-slow.log.out
perl pt-query-digest /var/lib/mysql/up-slow.log
CREATE INDEX col ON tbl(col);
mkdir /home/bench/ cd /home/bench/
dd if=/dev/zero of=diskbench bs=1M count=1024 conv=fdatasync
1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 0.553284 s, 1.9 GB/s
echo 3 | sudo tee /proc/sys/vm/drop_caches
dd if=diskbench of=/dev/null bs=1M count=1024
1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 0.425812 s, 2.5 GB/s
dd if=diskbench of=/dev/null bs=1M count=1024
1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 0.135034 s, 8.0 GB/s
rm diskbench
lscpu
nproc
dd if=/dev/zero bs=1M count=1024 | md5sum
1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 2.5454 s, 422 MB/s cd573cfaace07e7949bc0c46028904ff -
wget -O speedtest-cli https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py chmod +x speedtest-cli
curl -Lo speedtest-cli https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py chmod +x speedtest-cli
./speedtest-cli
./speedtest-cli -h
[root@droplet ~]# dd if=/dev/zero of=diskbench bs=1M count=1024 conv=fdatasync 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 2.51205 s, 427 MB/s [root@droplet ~]# dd if=/dev/zero of=diskbench bs=1M count=1024 conv=fdatasync 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 2.84208 s, 378 MB/s [root@droplet ~]# dd if=/dev/zero of=diskbench bs=1M count=1024 conv=fdatasync 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 2.09716 s, 512 MB/s [root@droplet ~]# echo 3 | sudo tee /proc/sys/vm/drop_caches 3 [root@droplet ~]# dd if=diskbench of=/dev/null bs=1M count=1024 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 1.55411 s, 691 MB/s [root@droplet ~]# dd if=diskbench of=/dev/null bs=1M count=1024 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 0.348052 s, 3.1 GB/s [root@droplet ~]# dd if=diskbench of=/dev/null bs=1M count=1024 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 0.202393 s, 5.3 GB/s [root@droplet ~]# rm diskbench rm: remove regular file `diskbench'? y [root@droplet ~]# nproc 4 [root@droplet ~]# dd if=/dev/zero bs=1M count=1024 | md5sum 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 3.34115 s, 321 MB/s cd573cfaace07e7949bc0c46028904ff - [root@droplet ~]# dd if=/dev/zero bs=1M count=1024 | md5sum 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 3.17004 s, 339 MB/s cd573cfaace07e7949bc0c46028904ff - [root@droplet ~]# dd if=/dev/zero bs=1M count=1024 | md5sum 1024+0 records in 1024+0 records out 1073741824 bytes (1.1 GB) copied, 3.09961 s, 346 MB/s cd573cfaace07e7949bc0c46028904ff - [root@droplet ~]#
Source
server {
listen 80 default_server;
listen [::]:80 default_server;
root /var/www/html;
server_name _;
location / {
root /data/frontend;
try_files $uri $uri/ /index.html;
}
location /api {
proxy_pass http://localhost:5000;
}
location /socket.io {
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
proxy_http_version 1.1;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header Host $host;
proxy_pass http://localhost:5000;
}
}