User Michael - sqlbot - Database Administrators Stack Exchange

43 votes

Accepted

Is there a graceful or safe restart for mysql like for apache httpd?

mysql

answered Feb 26, 2013 at 1:43

40 votes

What is the optimal way to upgrade production RDS instance?

mysql amazon-rds

answered Dec 26, 2013 at 16:39

36 votes

Accepted

intermittent MySQL crashes with error "Fatal error: cannot allocate memory for the buffer pool"

mysql innodb mysql-5.5 crash

answered Sep 30, 2012 at 19:27

34 votes

Accepted

MySQL InnoDB crash post-mortem

mysql innodb mysql-5.5 crash

answered Sep 28, 2012 at 5:12

32 votes

Accepted

Is it possible to modify an existing trigger definition in MySQL?

mysql trigger update

answered Oct 6, 2014 at 4:37

27 votes

Accepted

MySQL -> Loop through a table, running a stored procedure on each entry

mysql stored-procedures

answered May 15, 2016 at 2:43

26 votes

Accepted

Is there a tool to check if my database is normalized to the third normal form?

database-design schema database-recommendation normalization

answered Sep 23, 2012 at 2:47

25 votes

Accepted

MySQL 5.6 DateTime Incorrect datetime value: '2013-08-25T17:00:00+00:00' with Error Code 1292

mysql datetime

answered Aug 26, 2013 at 16:25

21 votes

Accepted

mysqladmin not taking inline password

mysql authentication mysqladmin

answered Aug 27, 2013 at 14:05

21 votes

Accepted

What's the difference between POINT(X,Y) and GeomFromText("POINT(X Y)")?

mysql performance spatial

answered Jan 23, 2013 at 23:12

21 votes

Accepted

Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes

mysql performance cache query-cache

answered Jan 31, 2013 at 4:30

20 votes

Accepted

Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance

mysql amazon-rds amazon-ec2

answered Feb 13, 2013 at 5:39

20 votes

Why does MySQL ignore the index even on force for this order by?

mysql innodb index optimization explain

answered Aug 14, 2013 at 3:41

20 votes

Error while restoring a Database from an SQL dump

mysql mysqldump restore

answered Jun 18, 2013 at 0:37

19 votes

Accepted

How to determine master in mysql master-slave

mysql replication

answered Jul 10, 2013 at 4:07

18 votes

How long will it take to rename table

mysql alter-table

answered Nov 23, 2013 at 16:34

18 votes

Accepted

Making sense of INNODB buffer pool stats

mysql innodb buffer-pool

answered Jan 10, 2014 at 2:07

16 votes

Accepted

Mysql Performance optimization, max CPU load, low qps

mysql performance

answered Nov 28, 2013 at 20:40

16 votes

Accepted

Autoincrement primary key in CREATE TABLE ... AS SELECT

mysql select primary-key auto-increment ctas

answered Aug 2, 2013 at 13:43

16 votes

Accepted

How to get MAX and MIN in GROUP BY query?

mysql mysql-5.5 select group-by

answered Aug 15, 2013 at 19:01

15 votes

Accepted

What is wrong with table_cache hit rate?

mysql performance optimization my.cnf cache

answered Jun 19, 2013 at 20:39

15 votes

Accepted

MySQL possibility to create global routines (stored procedures and/or functions)

mysql stored-procedures trigger functions

answered Sep 27, 2013 at 20:32

13 votes

Accepted

How to "warm up" a cold DB server?

mysql performance

answered Oct 22, 2013 at 15:29

13 votes

Create a trigger to update table data on another Server's database

mysql trigger

answered Jun 19, 2013 at 1:36

12 votes

ERROR 1067 (42000) at line 7: Invalid default value for 'LAST_UPDATED'

mysql mysql-5.5

answered Oct 18, 2016 at 11:11

12 votes

format of mysql query log

mysql performance slow-log

answered May 20, 2013 at 2:10

11 votes

Accepted

Mysqldump treats some table as View

mysql backup mysqldump

answered Sep 4, 2015 at 20:56

11 votes

Accepted

How to optimize table_cache?

mysql

answered Jul 2, 2013 at 6:17

11 votes

What are the ports and directionality of the TCP connections used in MySQL replication?

mysql replication network

answered Aug 23, 2013 at 13:56

11 votes

Accepted

Can I configure MySQL's typecasting to consider 0 != 'foo'?

mysql security configuration

answered Mar 6, 2013 at 19:27

Stack Exchange Network

current community

your communities

more stack exchange communities

493 Answers

Is there a graceful or safe restart for mysql like for apache httpd?

What is the optimal way to upgrade production RDS instance?

intermittent MySQL crashes with error "Fatal error: cannot allocate memory for the buffer pool"

MySQL InnoDB crash post-mortem

Is it possible to modify an existing trigger definition in MySQL?

MySQL -> Loop through a table, running a stored procedure on each entry

Is there a tool to check if my database is normalized to the third normal form?

MySQL 5.6 DateTime Incorrect datetime value: '2013-08-25T17:00:00+00:00' with Error Code 1292

mysqladmin not taking inline password

What's the difference between POINT(X,Y) and GeomFromText("POINT(X Y)")?

Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes

Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance

Why does MySQL ignore the index even on force for this order by?

Error while restoring a Database from an SQL dump

How to determine master in mysql master-slave

How long will it take to rename table

Making sense of INNODB buffer pool stats

Mysql Performance optimization, max CPU load, low qps

Autoincrement primary key in CREATE TABLE ... AS SELECT

How to get MAX and MIN in GROUP BY query?

What is wrong with table_cache hit rate?

MySQL possibility to create global routines (stored procedures and/or functions)

How to "warm up" a cold DB server?

Create a trigger to update table data on another Server's database

ERROR 1067 (42000) at line 7: Invalid default value for 'LAST_UPDATED'

format of mysql query log

Mysqldump treats some table as View

How to optimize table_cache?

What are the ports and directionality of the TCP connections used in MySQL replication?

Can I configure MySQL's typecasting to consider 0 != 'foo'?