Archive for the ‘PHP / Mysql’ Category

Newer Entries »

Installing mytop ..

Thursday, April 19th, 2007

MySQL is one of the most important programs on a server, unfortunatly it is also pretty resource intensive. One a server it is not uncommon for a single user or even a query to take up the bulk of the servers cpu cycles. Mytop is a very useful program to see what queries a server is currently processing as well as which user is executing them. Think of mytop as top for mysql. If you see a lot from a user that means they are probably the hog. Mytop can also be useful for figuring out exactly which queries are causing the problem in the case of a self-designed website. The following is how to install mytop on the server and run it. Thanks to carlos for the actual commands

We are going to install 2 perl modules in addition to mytop to ensure that it will work.

Install TermReadKey:

cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/JS/JSTOWE/TermReadKey-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..

Now install DBI:

wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..

Finally install mytop:

wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install

Now simply run “mytop” and your done!

Thanks to eth0 :)

Posted in Articles -- Webhosting, Direct Admin, Ensim, HSP, Linux, PHP / Mysql, Plesk, VPS, WHM/cPanel | No Comments »

MySql Date Time

Thursday, April 19th, 2007

Date and Time Functions

Name Description
ADDDATE()(v4.1.1) Add dates

ADDTIME()(v4.1.1)

 Add time
CONVERT_TZ()(v4.1.3) Convert from one timezone to another
CURDATE() Return the current date
CURRENT_DATE(), CURRENT_DATE Synonyms for CURDATE()
CURRENT_TIME(), CURRENT_TIME Synonyms for CURTIME()
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP Synonyms for NOW()
CURTIME() Return the current time
DATE_ADD() Add two dates
DATE_FORMAT() Format date as specified
DATE_SUB() Subtract two dates

DATE()(v4.1.1)

 Extract the date part of a date or datetime expression
DATEDIFF()(v4.1.1) Subtract two dates
DAY()(v4.1.1) Synonym for DAYOFMONTH()
DAYNAME()(v4.1.21) Return the name of the weekday
DAYOFMONTH() Return the day of the month (1-31)
DAYOFWEEK() Return the weekday index of the argument
DAYOFYEAR() Return the day of the year (1-366)
EXTRACT Extract part of a date
FROM_DAYS() Convert a day number to a date
FROM_UNIXTIME() Format date as a UNIX timestamp
GET_FORMAT()(v4.1.1) Return a date format string
HOUR() Extract the hour
LAST_DAY(v4.1.1) Return the last day of the month for the argument
LOCALTIME(), LOCALTIME Synonym for NOW()
LOCALTIMESTAMP, LOCALTIMESTAMP()(v4.0.6) Synonym for NOW()
MAKEDATE()(v4.1.1) Create a date from the year and day of year
MAKETIME(v4.1.1) MAKETIME()
MICROSECOND()(v4.1.1) Return the microseconds from argument
MINUTE() Return the minute from the argument
MONTH() Return the month from the date passed
MONTHNAME()(v4.1.21) Return the name of the month
NOW() Return the current date and time
PERIOD_ADD() Add a period to a year-month
PERIOD_DIFF() Return the number of months between periods
QUARTER() Return the quarter from a date argument
SEC_TO_TIME() Converts seconds to ‘HH:MM:SS’ format
SECOND() Return the second (0-59)
STR_TO_DATE()(v4.1.1) Convert a string to a date
SUBDATE() When invoked with three arguments a synonym for DATE_SUB()
SUBTIME()(v4.1.1) Subtract times
SYSDATE() Return the time at which the function executes
TIME_FORMAT() Format as time
TIME_TO_SEC() Return the argument converted to seconds
TIME()(v4.1.1) Extract the time portion of the expression passed
TIMEDIFF()(v4.1.1) Subtract time
TIMESTAMP()(v4.1.1) With a single argument, this function returns the date or datetime expression. With two arguments, the sum of the arguments
TIMESTAMPADD()(v5.0.0) Add an interval to a datetime expression
TIMESTAMPDIFF()(v5.0.0) Subtract an interval from a datetime expression
TO_DAYS() Return the date argument converted to days
UNIX_TIMESTAMP() Return a UNIX timestamp
UTC_DATE()(v4.1.1) Return the current UTC date
UTC_TIME()(v4.1.1) Return the current UTC time
UTC_TIMESTAMP()(v4.1.1) Return the current UTC date and time
WEEK() Return the week number
WEEKDAY() Return the weekday index
WEEKOFYEAR()(v4.1.1) Return the calendar week of the date (1-53)
YEAR() Return the year
YEARWEEK() Return the year and week

By,
Ajay

Posted in PHP / Mysql | No Comments »

Remotely Access MySQL Database

Wednesday, April 18th, 2007

The following article explains how to access your MySQL database remotely.
1)Go to Cpanel >> MySQL® Databases >> Access Hosts: >> Add IP of the machine from which you want to access databse.
2)Click on Add host.

In order to access your MySQL database, please follow these steps:

1. Log into your machine from which you want to access database remotely.
2. Open the MySQL client program on the server in the /usr/bin directory.
cd /usr/bin

Give the command
# mysql

3.Type in the following syntax to access your database:

$ mysql -h {hostname} -u username -p {databasename}
Password: {your password}
mysql >
* hostname: the name of the MySQL server that you are assigned to, for example, domainname/servername
* databasename: The name of your MySQL database
* password: The password you use to access your MySQL database

;)

Posted in PHP / Mysql, WHM/cPanel | No Comments »

Hello world!

Thursday, April 12th, 2007

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Posted in Articles -- Webhosting, C# / VB/ ASP .net, Direct Admin, Domains, Ensim, Fantastico / Installatron, HSP, Internet, Kayako Helpdesk, Kernel, Linux, ModernBill, PHP / Mysql, Plesk, SEO, Ubersmith, Virtuozzo, VPS, WHM Auto Pilot, WHM/cPanel, WHMCS, Windows | No Comments »

Newer Entries »