I've got a Problem with DateTime in PHP. In my Testcase I have 10.000 Rows that are pulled from a MySQL InnoDB Database. This works fine, as my local development is running on a SSD and it takes about ...

I have MySQL tables that are all InnoDB.
We have so many copies of various databases spread across multiple servers (trust me we're talking hundreds here), and many of them are not being queried at ...

I'm working on a customer service queue system, where I have a single alphabetic character to indicate service type (A..Z). I want tickets numbers to be generated in A1, B2 etc. format. So each series ...

I started a new project which is basically an API built in NodeJS (express) so a user can fetch all the files (metadata) from its dropbox account, using the dropbox API.
Basically, clients can make ...

I am working on an embedded Linux system running MySQL 5.1. In rare cases QA reports systems not starting properly because of mysqld not starting. If this happens the MySQL log files looks similar to ...

I am making a system where users can upload any file they want, and not use it to execute any kind of code. As a part of that, I rename every file, and store its original name in a MySQL table. This ...

I am making a system where users can upload any file they want, and not use it to execute any kind of code. As a part of that, I rename every file, and store its original name in a MySQL table. This ...

The storage engines listed on my phpmyadmin page are CSV, MRG_MYISAM, MEMORY and MyISAM. I want to use InnoDB to enable foreign keys. I ran SHOW ENGINES in mysql and InnoDB is listed:
Engine: InnoDB
...

I'm working on a Mac Yosemite and in my local environment I have mysql-5.6.21 installed through homebrew. It suddendly stopped working. I was actually browsing one of the websites I'm working on and I ...

I am diagnosing an intermittent slow query, and have found a strange behaviour in MySQL I cannot explain. It's choosing a different, non-optimal key strategy for one specific case, only when doing a ...

My dev/production MySQL versions and data are nearly identical. I'm using MySQL 5.6 with InnoDB tables in both with the exact same configs, data, table structure and keys.
To be precise, there is a ...

LAMP stack - so code is PHP
I have an innodb table - called queueTable
There is a cron job that runs every 15 minutes that queries the DB to figure out if any records need to be put into queueTable. ...