mysql-5.5 Archives - IT Nursery

Mysql load from infile stuck waiting on hard drive

I’ve got a windows 7 64 bit machine that I’m using for some load testing of a mysql db. My program uses sqlalchemy … Read more

I am a novice in SQL and I have a problem as follows. There are two tables TRNSCTN_TAB: CREATE TABLE TRNSCTN_TAB( `transactionId` int … Read more

This question already has answers here: CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard? (2 answers) Closed 6 years … Read more

I am replicating from a MySQL v 5.5.50 master, to a MySQL v 5.5.46 slave hosted in RDS. I’ve followed the AWS documentation … Read more

I use PHP 5.4.3 and I want to connect to a MySQL database (DB for brevity) remotely (the PHP script resides on a … Read more

I am new to MySQL and I’m having problems creating a BEFORE INSERT trigger. I get an unexpected END error. I have a … Read more

I would like to disable accounts after x failed login attempts. Is it possible? 2 Answers 2 Also you can use fail2ban for … Read more

We have a MySQL database (InnoDB) on our live Ubuntu 12.04 server which has grown quite large (25gb+). Every month or so we … Read more

I am using Amazon RDS db.m1.medium instance. It has at least 40-50 database and atleast 10k table. For last one year it was … Read more

We have deployed REDIS to hold some frequent query result to reduce number of connections made on Database server. We need to find … Read more