September 2020
« Apr    

MySQL : How do I store Slow sql queries in to a Table

One of the Dev. find difficulties to populate the large slow queries file which he ask to fix the Application performance issue. After few checking he informed me we can log slow queries on one the system table in MySQL version 5.5. So that we can pragmatically manipulate and explore it easily.

But I do […]

web-based MS SQL administration tool for MSSQL server 2012

While I’m setting up a Windows 2012 server for a small .Net project, I have a need of providing MSSQL server 2012 Express access to Developers. Following are the options normally a admin will do,

1. Create a normal user having Remote Desktop access and provide SQL user account. 2. Open Remote MSSQL server access […]

MySQL 5.5 : How do I enable slow query log

Prior to optimize the performance of a busy MySQL Database server, I need to enable all the queries those consume more than 10 second to complete the execution. This server load is high most of the time and being hit on performance issue due to this load.

I’m using the server which have 32 CPU’s […]

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol

While I’m accessing MySQL server 5.5 remotely from a windows server which was MySQL 5.6 libraries installed, I got the following errors.

C:\Documents and Settings\Administrator>mysql -h -ureadusr -p Enter password: ************ ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)

How do I skip this error and able […]

PHP 5.5 : MySQL error – The server requested authentication method unknown to the client

Recently I had to upgrade the php version to 5.5 on one of the servers for the enhancement. All the php hosted sites showing database errors after the switching to new PHP version. The error is shown below,

Could not connect: The server requested authentication method unknown to the client. So I had to revert […]

Elastic BeansTalk : Rails deployment using PostgreSQL back end.

Elastic BeanTalk is a cool,easily and scalable deployment tool for deploying any applications. This would be a simple administrative approach to scale up servers to N.. numbers. ie if you are working on a long term product type business, you can try this feature or you can use the application which will have short term […]