Tags » Mysql

Using the word 'function' in a comment in a MySQL stored procedure causes the RESTORE command to fail

Recently our support team had a call from a customer who suspected that their nightly MySQL backup/restore job wasn’t working.

At most of our customer sites, once the nightly backup has been run, there is a job to restore the backup to a read-only copy of the live database that is used for reports. 543 more words

MySQL

Columns to Rows Query

This post describes how to convert columns to rows the following table:

ID Colu

mn1 Colu
mn2
Colu
mn3
Colu
mn4
Colu
mn5
Colu
mn6…
165 more words

SQL

Cakephp Search Record Based on to columns

$conditions[‘CONCAT(ShortApplication.applicant_first_name , ” “, ShortApplication.applicant_last_name) LIKE’] = ‘%’.$this->params[‘url’][‘search’].’%’;

Enjoy

CakePHP

Authenticating nginx using Mysql

In the last post I talk about Basic HTTP Authentication on nginx server.

In that tutorial, we useĀ ngx_http_auth_basic_moduleĀ to provide basic authentications mechanism for our server. 214 more words

Six Month Training

Command line QPS (Queries Per Second) Quick and Dirty

Ever wanted to just look at QPS in real time while logged into your server?

Well here’s a little command line hackery to do it quick and dirty. 89 more words

MySQL

Fetch CSV of MySQL table size vs .ibd container size

This only works if you’re using innodb_file_per_table.

Purpose: import this csv quickly into google sheets (or other spreadsheet) and compare MySQL’s internal data size to the container size on disk to determine tables needing to be optimized (or “null altered”) to reclaim disk space and maybe increase performance due to defragmentation. 134 more words

MySQL