Monthly Archives: November 2014

MySQL Indexing Stuff

Posted on November 20, 2014 by vicki

#Determine whether a table is indexed show index from [table name] #Display a table’s index mysql> show index from mysql.user; +——-+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+—————+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | … Continue reading →

Posted in Linux, MySQL | Comments Off on MySQL Indexing Stuff

How to create a local yum repository

Posted on November 14, 2014 by vicki

Yum Server Side Take a look at the available repositories with the repolist option to yum: $yum repolist Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile epel/metalink | 13 kB 00:00 * base: mirror.symnds.com * epel: epel.mirror.constant.com * extras: … Continue reading →

Posted in Linux | Comments Off on How to create a local yum repository

Understanding rpm Verify output

Posted on November 14, 2014 by vicki

rpm -V output: S file Size differs M Mode differs (includes permissions and file type) 5 MD5 sum differs D Device major/minor number mismatch L readLink(2) path mismatch U User ownership differs G Group ownership differs T mTime differs

Posted in Linux | Comments Off on Understanding rpm Verify output

Differences in useradd command in different Linux Distributions

Posted on November 5, 2014 by vicki

In Ubuntu and Debian: By default, each user in Debian GNU/Linux is given a corresponding group with the same name. In RedHat/CentOS,Gentoo If not specified, the behavior of useradd will depend on the USERGROUPS_ENAB variable in /etc/login.defs. If this variable … Continue reading →

Posted in Linux | Comments Off on Differences in useradd command in different Linux Distributions