8,615 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 10 months
seen 7 hours ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Jul
29
comment Replication of a remote MySQL database to local MySQL database
Replication seems unlikely to be a possibility in this case, depending on what exactly OP means by "shared hosting."
Jul
28
answered mysqldump --single-transaction, yet update queries are waiting for the backup
Jul
23
revised Auto-increment ids with multiple inserts in mysql/mariadb
how many "rows" (not columns) was (afaik) the intended meaning
Jul
23
comment MySQL Code Works in PHPMyAdmin but not in PHP Page
@Justin, welcome to DBA.SE... Stop, and research SQL injection vulnerabilities. You should never concatenate your variables into queries like this. There are massive potential security holes waiting for you. Even if the values come from a safe place now, that's not a good reason to build queries this way. xkcd.com/327
Jul
23
comment Can I use mysql/mariadb databases on different OS?
+1, I agree that dump and reload is always the safest approach, but was primarily curious whether there was a specific or definitive reference we could cite, since the docs are unfortunately vague: "Like MyISAM data files, InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format. If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: simply copy the relevant files." I've done binary data migrations from Solaris to Linux, but both were 64-bit.
Jul
22
comment Can I use mysql/mariadb databases on different OS?
What is your source for the statement that migrating between 32-bit and 64-bit systems requires a dump and reload?
Jul
22
comment MySQL getting killed by AppArmor
How about /var/log/syslog? (/var/log/messages?) Anything in the mysql error log about "number of processes running now 0"?
Jul
22
comment mysqldump --single-transaction, yet update queries are waiting for the backup
What is your full command line for mysqldump? In particular, are you using --flush-logs or --master-data...? There are potential interactions among the options.
Jul
19
reviewed Close Pgpooladmin pcp commands does not work
Jul
19
reviewed Close How to add attachment from email to Sharepoint database
Jul
19
reviewed Leave Closed “Replicate” Table structures with sp_addscriptexec
Jul
19
reviewed Close single table or different tables
Jul
18
answered How to disable HTML output in mysql console?
Jul
18
answered MySQL 5.6: Slave_IO thread stops working
Jul
15
comment MySQL Stored Procedure Requiring SUPER
Definer context is actually the default in MySQL unless SQL SECURITY INVOKER is specified, but, yes, this is a common and viable approach.
Jul
15
comment Mysql 5.5+ replication heartbeat feature
"Before considering the first heartbeat failed, it must fail the TCP connection." -- why do you say that? Which "it" are you referring to, here?
Jul
15
comment Question on MySQL insert race condition
Actually @Sebas, I think that's a misinterpretation. Fluahes to disk are asynchronous in MyISAM but the actual write to the OS (cache)-- where the other query would read from -- isn't.
Jul
14
comment Are there benefits to using more than 4 CPUs for MySQL?
I think @chris you are taking away the wrong impression from this answer. More CPU is almost always better than less, it's just that core speed is often more beneficial than core count, since no single running query runs on more than one core. If you are hitting 100% and running multiple queries at the same time, then yes, add more, and configure accordingly.
Jul
13
comment How could I prevent the mysql cli-/terminal client from converting/altering multiline-statements (in the process of logging)?
It sounds like you're referring to the "MySQL Command Line Client" and the way it stores queries with newlines in such a way that you can't easily "up-arrow" back through those queries in order to run them again, because they're stored in the history as individual lines. Right?
Jul
13
comment Can I generate binary logs if they weren't turned on?
Don't forget about the --events option.