User greenlitmysql

13 votes

Accepted

MySQL - How to make a DATEDIFF in years?

answered Aug 28, 2015 at 22:01

2 votes

How can we create a table from stored procedure?

answered Sep 1, 2015 at 17:48

2 votes

Creating a MySQL db from an Informix database

answered Sep 24, 2015 at 17:40

2 votes

Average value of a row in MySQL

answered Sep 29, 2015 at 6:31

2 votes

How costly is opening and closing of a DB connection?

answered Feb 17, 2016 at 4:23

2 votes

INFORMATION_SCHEMA.GLOBAL_VARIABLES alternative in 5.7? More info about show_compatibility_56

answered Sep 23, 2020 at 2:50

1 vote

Percona XtraDB - Random deadlock

answered Aug 28, 2015 at 21:48

1 vote

Datatype for phone number: VARCHAR, INT or BIGINT?

answered May 1, 2017 at 20:24

1 vote

Database design for millions of posts

answered Nov 21, 2015 at 7:12

1 vote

Indirect constraints (foreign keys amongst three/four tables)

answered Sep 28, 2015 at 17:30

1 vote

Is there any reason not to use foreign keys in MySQL?

answered Sep 28, 2015 at 17:40

1 vote

Accepted

Same SQL stall on server but work on local ( on slower machine )

answered Sep 4, 2015 at 4:50

1 vote

Optimization of variables in my.cnf (mysql) for Drupal

answered Sep 4, 2015 at 16:37

1 vote

Anyway to identify mysql slaves have read upto which binary logs

answered Aug 27, 2015 at 6:28

1 vote

Select highest id of each type in mysql

answered Aug 27, 2015 at 6:50

1 vote

Disaster recovery solution for MySQL

answered Aug 27, 2015 at 6:57

1 vote

Slow SQL query with LEFT JOIN

answered Aug 27, 2015 at 7:14

0 votes

Anyway to identify mysql slaves have read upto which binary logs

answered Aug 28, 2015 at 15:05

0 votes

Is it good to save Keywords stored by users in a new DB schema?

answered Aug 28, 2015 at 15:16

0 votes

Unique full text index?

answered Aug 28, 2015 at 15:29

0 votes

Slow query - just error count

answered Aug 27, 2015 at 7:03

0 votes

MySQL Monitoring Script in Shell or Perl for Linux

answered Sep 4, 2015 at 0:37

0 votes

Duplicate Same Table for Multiple locations

answered Sep 4, 2015 at 0:45

0 votes

Is it safe to run optimze on mutliple tables in parallel in mysql (percona)

answered Sep 4, 2015 at 1:12

0 votes

How to preseve Execute permissions for MySQL procedure with alter procedure (Drop/Create)

answered Aug 30, 2015 at 1:46

0 votes

MySQL users not visible after import

answered Aug 30, 2015 at 1:49

0 votes

Optimize mysql --> 'show global status'

answered Sep 8, 2015 at 18:10

0 votes

Using mysqldump on RDS to export a large file in TSV format

answered Sep 8, 2015 at 19:43

0 votes

MariaDB server with 80K-100K DataBases

answered Sep 4, 2015 at 16:24

0 votes

MYSQL: used variable on IN condition

answered Sep 29, 2015 at 5:38

Stack Exchange Network

36 Answers

MySQL - How to make a DATEDIFF in years?

How can we create a table from stored procedure?

Creating a MySQL db from an Informix database

Average value of a row in MySQL

How costly is opening and closing of a DB connection?

INFORMATION_SCHEMA.GLOBAL_VARIABLES alternative in 5.7? More info about show_compatibility_56

Percona XtraDB - Random deadlock

Datatype for phone number: VARCHAR, INT or BIGINT?

Database design for millions of posts

Indirect constraints (foreign keys amongst three/four tables)

Is there any reason not to use foreign keys in MySQL?

Same SQL stall on server but work on local ( on slower machine )

Optimization of variables in my.cnf (mysql) for Drupal

Anyway to identify mysql slaves have read upto which binary logs

Select highest id of each type in mysql

Disaster recovery solution for MySQL

Slow SQL query with LEFT JOIN

Anyway to identify mysql slaves have read upto which binary logs

Is it good to save Keywords stored by users in a new DB schema?

Unique full text index?

Slow query - just error count

MySQL Monitoring Script in Shell or Perl for Linux

Duplicate Same Table for Multiple locations

Is it safe to run optimze on mutliple tables in parallel in mysql (percona)

How to preseve Execute permissions for MySQL procedure with alter procedure (Drop/Create)

MySQL users not visible after import

Optimize mysql --> 'show global status'

Using mysqldump on RDS to export a large file in TSV format

MariaDB server with 80K-100K DataBases

MYSQL: used variable on IN condition