(Ubuntu server) Im running
sudo iptables -A INPUT -s 127.0.0.1 -j ACCEPT
sudo iptables -A INPUT -p tcp -m tcp --tcp-flags FIN,SYN,RST,ACK SYN -m limit --limit 4/sec -j ACCEPT
and then
sudo iptables-save
To get the function of the iptables rules, is it enough to doing only above command (without restarting iptables)?
I'm confused because as I know, CentOS doesn't support ReiserFS.
But my previous CentOS VPS is running on ReiserFS.
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/vzfs reiserfs 314572800 10694756 303878044 4% /
none tmpfs 262144 4 262140 1% /dev
In system admin view, What make it possible to install CentOS with ReiserFS in VPS?
I just ordered server which the hard disk spec is 2 x 1.5TB
but when using df -T only showing 1.5TB:
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/hda1 ext3 1417219800 1243220 1342824608 1% /
tmpfs tmpfs 4150720 0 4150720 0% /dev/shm
running mount:
/dev/hda1 on / type ext3 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
When running df -T:
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/hda1 ext3 1417219800 1197276 1342870552 1% /
tmpfs tmpfs 4150720 0 4150720 0% /dev/shm
How to convert /dev/hda1 to reiserfs?
Im looking for website which contains OS distro benchmarks (comparing in 32 & 64 bit, comparing PHP execution on the distro, etc.)
Previously, I use this:
USE dbname;
ALTER TABLE tablename ENGINE=MYISAM;
I'm looking for simpler way to convert all tables in a database, rather than writing every table name one by one
(in my.cnf) I've tried default-storage-engine = myisam, skip-innodb, and commented out every innodb features, but none of them works
Im trying to use Percona Server with XtraDB with Drupal
But the documentation not describe the basic usage like how to login to the
CLI (MySQL usemysql -u root -p), how to create database, etc
Connecting Drupal with MariaDB is very easy because all the commands are same. How about Percona Server?
Previously, on every database created, I use:
mysql -u root -p
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL ON dbname.* TO 'dbuser'@'localhost';
and then use the database without thinking about MyISAM or InnoDB
How to know storage engine used of a database?
— I have a plan to use OpenSolaris in this year, but now, the development has been discontinued.
The server OS is CentOS, with Memcached installed
Before Memcached installed, I use
mysqldump -u root -p --lock-tables --add-locks --disable-keys --skip-extended-insert --quick wcraze > /var/backup/backup.sql
But now, Memcached has been installed.
According to Wikipedia;
When the table is full, subsequent inserts cause older data to be purged in least recently used (LRU) order.
This means new data entry is not directly saved in MySQL, but saved in Memcached instead, until limit_maxbytes is full, the least accessed data will be saved in MySQL.
This means, some data is not in the MySQL but in Memcached. So, when backup, the new entry is not in the backup data
What is the right way to backup?