UPWORK/ODESK guru: Tips and Tricks for clients

skype: odesk.by / upwork.link , email: [email protected]/upwork.link

Archive for February, 2014

How to Get Your php.ini Path with SuPHP

without comments

You can specify which php.ini file is used within a certain directory if you have multiple php.ini files.

To do this, edit your .htaccess file located in the directory you wish to use and add the following .htaccess code:

Read the rest of this entry »

Written by spectre

February 18th, 2014 at 1:56 am

Posted in Php

Optimization and tuning of the threads in MYSQL.

without comments

So. As it is known, mysqld it “one process – is a lot of threads”.In approached enough understanding thread it when process copies itself, and parental process transfers to threads what that a task for the decision.

Creation thread differs from usual fork () basically that fork generates +1 process whereas division on threads uses other, more productive technology of branching without cloning of the data in memory.

At each connection of the client, mysql creates thread which this connection processes.

Read the rest of this entry »

Written by spectre

February 15th, 2014 at 11:58 am

Posted in Mysql

Create root privilege user on MySQL server.

without comments

MySQL root privileges user is “root”, I always remove “root” userid once I got MySQL installed, mainly for security purpose, secondly I do not want stupid thing happened like someone able to brute force into MySQL database.

Read the rest of this entry »

Written by spectre

February 14th, 2014 at 12:39 am

Posted in Mysql

How to list all locked account in linux?

without comments

passwd -S user
passwd -S -a | grep LK | cut -d " " -f1
cat /etc/passwd | cut -d : -f 1 | awk '{ system("passwd -S " $0) }'

Written by spectre

February 8th, 2014 at 6:21 pm

Posted in Tips and Tricks