meta user
network profile
| bio | website | |
|---|---|---|
| location | Cincinnati, OH | |
| age | 42 | |
| visits | member for | 8 months |
| seen | 8 mins ago | |
| stats | profile views | 102 |
If you question the superiority of the relational model... you're doing it wrong.
|
1h |
comment |
MySQL version confusion It looks like Oracle has a history of not setting this value correctly: bugs.mysql.com/bug.php?id=67024 ... I found some 5.5 systems on solaris 10 in my network that show 'i386' even though the mysqld executable is identifiable as "ELF 64-bit LSB executable AMD64" while MySQL 5.1 on Solaris 10 reports 'x86_64' ... so I'm guessing this value is never particularly trustworthy. |
|
1d |
answered | Will creating a view on a MySQL replication slave break the replication? |
|
May 20 |
answered | format of mysql query log |
|
May 19 |
comment |
MySQL Master/Slave. Actual use of Slave Machine +1 very good point about "split brain" since MySQL replication will not detect this condition until one of the mismatched (or missing) (or extra) rows on the slave is referenced by, or causes a constraint violation in response to, an event replicated from the master. |
|
May 19 |
answered | Make rows immutable allow Insert mysql5 |
|
May 19 |
answered | Master/Slave without populating tables |
|
May 19 |
revised |
How to recover/restore corrupted Innodb data files? additional content in response to comments |
|
May 18 |
answered | How to recover/restore corrupted Innodb data files? |
|
May 17 |
comment |
Mysql 5.6 and install php5-mysql , mysql-common Have you tried it? |
|
May 17 |
answered | Federated tables and triggers |
|
May 16 |
answered | Why does copied MySQL database have different data than source? |
|
May 15 |
comment |
Why does copied MySQL database have different data than source? Are the source tables MyISAM or InnoDB? |
|
May 15 |
comment |
How do I use subquery on the same table in MySQL? Posting the output of SHOW CREATE TABLE table_name; might be helpful, as might the output of EXPLAIN SELECT * FROM table_name WHERE value_was IS NULL OR value_was <= value_now; Also, the (value_was,value_now) index should still improve performance of the first query, depending on what other indexes are already there... have you tried that? |
|
May 15 |
answered | Creating database/tables in SequelPro (or MySQL) from External FTP Server |
|
May 14 |
answered | Unable to use mysql_upgrade: |
|
May 14 |
revised |
Stored procedure with and without preparing statement respond to comments; formatting |
|
May 14 |
answered | Stored procedure with and without preparing statement |
|
May 14 |
awarded | Caucus |
|
May 13 |
comment |
InnoDB Failure of some kind Try to make it 4 does not make sense. You need 0 (default) at all times unless you are in the middle of trying to recover from data corruption. You cannot do inserts with innodb_force_recovery set to any nonzero value. It is an emergency only setting. If it was already 6 you likely have an unstable installation and should not be deploying new databases on it. |
|
May 13 |
answered | Dealing with empty strings while loading a table from a CSV |
