apt-get install qemu-kvm virt-manager virt-viewer libvirt-bin bridge-utils
If it doesn’t work, use this:
apt-get install qemu-kvm qemu virt-manager virt-viewer libvirt-bin bridge-utils
Unfortunately, you don’t get the bridged network by default, so this is what has to be done:
echo "manual" | tee /etc/init/network-manager.override
And you need to change your interface file like this:
iface br0 inet static
Also add the ‘/etc/sysctl.conf’ settings to the end of the file:
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
Apply the changes:
sysctl -p /etc/sysctl.conf
To my surprise even this is needed:
Add to /etc/rc.local:
/sbin/sysctl -p /etc/sysctl.conf
iptables -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu
Root or run something like this:
ifdown eth0 && ifup br0
And last but not least, with br0, beloved eth0 seems gone forever, I don’t like this, but what other choice I have.
And Do below changes:
Comment the line GRUB_CMDLINE_LINUX_DEFAULT=”quiet splash”, by adding # at the beginning, which will disable the Ubuntu purple screen.
Change GRUB_CMDLINE_LINUX=”” to GRUB_CMDLINE_LINUX=”text”, this makes Ubuntu boot directly into Text Mode.
Uncomment this line #GRUB_TERMINAL=console, by removing the # at the beginning, this makes Grub Menu into real black & white Text Mode (without background image)
And run this after:
Show table schema and execution plan:
show create table
show index on
drop index on
create index on
show the running process:
Also from stackoverflow:
Do you have an index on key_1?
Without it, each query by itself will already be slow just looking for 123.
Do you have an index on (key_1, key_2)?
Because select distinct key_2 where key_1 = 123 is really fast if it can get all the necessary data from the index alone. No need to access the table.
Are the rows/indexes fixed-size?
Traversing a fixed-size table/row can be faster because one always knows where the x-th record is by just calculating the offset. Variable row sized tables are slower.
Have you tried adding an autoincrement surrogate primary key?
Indexes work way better when all they have to store is the column, and a small primary key. Composite primary keys are slower.
Did you consider a read-only table?
You can pack myisam table for fast access, but they become read-only. It’s a hack that has its uses though.
One step further, have you considered a datawarehouse?
If the tables don’t change often, it might be best to duplicate the information for fast access.
Can you post a show create table statement? Seeing the columns and indexes would help. Can you post an explain select statement? Seeing which indexes are used would help.
axel – a command line based multithread downloader
Very powerful and could improve your download speed magically, install with the aptitude tool in ubuntu
Use something like this:
ALTER TABLE table_name DROP INDEX index_name;
And you can use mysqldump to find out the name of your unique constraint
youtube-dl –format ‘bestvideo+bestaudio’ https://www.youtube.com/watch?v=qd-tKr0LJTM
First of all need a linux system, if you have a windows try to find a windows version of mp4box
On ubuntu, install the package that contains mp4box：
aptitude install gpac
then run the command like this to join or merge the mp4 files
MP4Box -cat path/to/video1.mp4 -cat path/to/video2.mp4 -cat path/to/video3.mp4 -new path/to/output.mp4
I tried quite a few command, only this one works:
ifconfig eth0 down
ifconfig eth0 up
ifup and ifdown commands don’t work no matter how I tried them.
if you want to remove ipv6 address run the below command:
sysctl -w net.ipv6.conf.all.autoconf=0
sysctl -w net.ipv6.conf.eth0.autoconf=0
sysctl -w net.ipv6.conf.all.accept_ra=0
to make it permanently add it to the sysctl.conf
Also on Debian Etch (probably on newer too), without setting the accept_ra, the system will autoconfigure using the Link local adress (fe80..)
Further more, automatic address configuration and router discovery will be disabled if the host itself is a router and accept_ra is not 2, i.e
net.ipv6.conf..accept_ra=0 or net.ipv6.conf..accept_ra=1.
use this command to apply the hostname if changed without reboot:
hostname -F /etc/hostname