Category
Sort By
In this blog we will setup the jmeter and we will see how to create a simple test plan to test the database server.We will use MySql database server for our test purpose or you can use any-other database. Setup requirement Download the latest jmeter from here and untar jmeter in you home directory. Download JDBC driver is...
Amazon RDS provides us with three different types of logs : 1) General Logs 2) Slow Query Logs 3) Error Logs You can enable these logs by modifying the DB Parameter Group. 1) Enable General Log [js] Parameter Name : general_log Value : set the value to 1. Default is 0. [/js] 2) Enable Slowquery Log [js] ...
MySQL and MongoDB are a very popular open-source databases these days. Through this blog, I wanted to share a use case of migrating MySQL database to MongoDB database and perhaps want to share few lessons during the migration process which would be helpful. There are three steps to the migration process: Suppose you have a user...
To import data from a MySQL database that is running external to Amazon RDS, you can configure replication from that database to a MySQL RDS instance. The external MySQL database you are importing from can be running either on-premises in your data center, or in an Amazon EC2 instance. The MySQL RDS instance must be running either MySQL...
This time I am going to explain a very basic CRUD operation on MySql database via NodeJs using Sequelize. Here Sequelize become's a bridge between NodeJs and MySql database, it is a Object Relational Mapping Library written on javascript. Let us quickly learn the things with the help of Examples and we will use Item Table to perform...
Amazon RDS doesn't allow you to change timezone, It keeps same UTC time zone across all regions. time_zone variable in the parameter group is read only.You can change the time zone on each connection or session by making a procedure in default mysql database and call this function on each init connection.1. Create a procedure for...
While working on my current application, I had to import a large database using mysql from a sql dump. The size of the sql dump was around 1.5 GB and hence the import was taking long time. I just felt the need of some tool that could help me check the progress of the import. The command I used was: [sql] mysql --user=username...
While developing a mobile app using phonegap ( or otherwise also :) ), we can access remotely hosted mysql database using jquery ajax calls. But this interaction between jquery and mysql database cannot happen directly. We will need to specify a server side script (in PHP terminology) or a controller action (in Grails Terminology) that...
Very often, we all need to access a remote database for debugging or any other related stuff. The simplest thing that comes to mind is to take the dump of remote database and bring it to the local and run the application using that data. We can avoid that, if we can connect our local mysql client to a remote machine over a SSH...
Recently in my project, we needed to import database dumps of a legacy database in MySQL, which was involved in a nested relationship where one tuple could be the parent record of another tuple. We created the appropriate domain structure and checked that the foreign key references were created accordingly. All well and good. So we...
Recently in one of my project i faced a problem that database was having special character, which is shown as space on the User Interface. So as to solve this issue i found a very simple solution which consists of following steps: 1. First, you just need to identify which type special character to be removed/replaced like in my case...
Hi all, Here is a simple function that can allow you to clear time from the DATETIME field of your database table [sql] DROP FUNCTION IF EXISTS cleartime; delimiter // CREATE FUNCTION cleartime(dt datetime) RETURNS DATETIME NO SQL DETERMINISTIC BEGIN DECLARE t varchar(15); -- the time part of the dt ...
