8,825 reputation
1923
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 11 months
seen yesterday

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


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
Jul
9
awarded  Nice Answer
Jul
9
comment How can I perform this database backup/sanitization task?
You don't make this "node" part of the cluster; it's an ordinary async slave, whose master is one of the galera nodes. The only issue with this answer is running queries to munge the data (on a slave). That's usually ill-advised, since replication expects identical data. But you can use mysqldump on this system all day long, zero impact to the cluster.
Jul
8
answered MySQL remote connection: Public vs. private IP address
Jul
6
comment Performance: Interleaving several statement handles in MySQL
$sth->execute() is a blocking call, so on the surface, the answer should be that it makes no meadingful difference, as your code is still only executing one thing at a time on the server, and an idle statement handle... is idle. The question seems to lack sufficient specificity for a meaningful answer.
Jul
2
comment Architecture for a MySQL MDBS
Define "external databases." MySQL? Something else? How much administrative access do you have to the external databases and how far away are they (ping/round trip time)?
Jun
30
comment Excesive use of RAM on MysqlServer
How much memory is MySQL using, and how much does the server have?
Jun
25
answered mysqld constant CPU usage when absolutly nothing is connected and no queries
Jun
20
comment Unable to load innodb log file settings from my.cnf
Take a look at the output from $ /Applications/MAMP/Library/bin/mysqld --help --verbose | grep -A 2 ^Default
Jun
4
answered Cannot execute statement: impossible to write to binary log?
May
27
comment Table Not Created On All MySQL Masters
If log_slave_updates is not enabled in any of your my.cnf files, then the real question is not why M2 is wrong. T1 was created separately on M1 and M3 (or why is there data on M3, which you don't show inserting it on M1?). Multi-master requires log_slave_updates on every server.