user avatar
user avatar
user avatar
Michael - sqlbot
  • Member for 9 years, 11 months
  • Last seen more than a month ago
  • Cincinnati, OH
43 votes
Accepted

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

40 votes

What is the optimal way to upgrade production RDS instance?

36 votes
Accepted

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

34 votes
Accepted

MySQL InnoDB crash post-mortem

32 votes
Accepted

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

27 votes
Accepted

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

26 votes
Accepted

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

25 votes
Accepted

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

21 votes
Accepted

mysqladmin not taking inline password

21 votes
Accepted

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

21 votes
Accepted

Qcache_free_memory not full yet I get alot of Qcache_lowmem_prunes

20 votes
Accepted

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

20 votes

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

20 votes

Error while restoring a Database from an SQL dump

19 votes
Accepted

How to determine master in mysql master-slave

18 votes

How long will it take to rename table

18 votes
Accepted

Making sense of INNODB buffer pool stats

16 votes
Accepted

Mysql Performance optimization, max CPU load, low qps

16 votes
Accepted

Autoincrement primary key in CREATE TABLE ... AS SELECT

16 votes
Accepted

How to get MAX and MIN in GROUP BY query?

15 votes
Accepted

What is wrong with table_cache hit rate?

15 votes
Accepted

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

13 votes
Accepted

How to "warm up" a cold DB server?

13 votes

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

12 votes

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

12 votes

format of mysql query log

11 votes
Accepted

Mysqldump treats some table as View

11 votes
Accepted

How to optimize table_cache?

11 votes

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

11 votes
Accepted

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

1
2 3 4 5
17