9,356 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 1 month
seen 51 secs ago

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


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 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.
Jul
13
answered Which files in the “MySQL-5.0.27-win32” folder do i need to backup?
Jul
13
comment Which files in the “MySQL-5.0.27-win32” folder do i need to backup?
Also here: stackoverflow.com/questions/24719242/…
Jul
10
comment Access Sharing database over Network vs Mysql multiple users
I've never known a database professional who considered Access to be anything other than cumbersome, frustrating, corruption-prone product scarcely worthy of the label "database." To compare Access favorably against MySQL or even SQLite is ludicrous. There is no magic in Access.
Jul
9
awarded  Enlightened