meta user
network profile
| bio | website | |
|---|---|---|
| location | Cincinnati, OH | |
| age | 42 | |
| visits | member for | 8 months |
| seen | 4 hours ago | |
| stats | profile views | 104 |
If you question the superiority of the relational model... you're doing it wrong.
|
May 13 |
answered | Dealing with empty strings while loading a table from a CSV |
|
May 13 |
comment |
Repair with 1 thread Also, the question only mentions one index on the table ("1 primary key") so that would just be one thread in any case. |
|
May 12 |
comment |
mysql replication successful but slave not replicating If you SHOW PROCESSLIST on the master, do you see the incoming connection from the slave? You should. Also, I would try STOP SLAVE IO_THREAD; then START SLAVE IO_THREAD; on the slave and see how the output of SHOW SLAVE STATUS (on the slave) changes, if at all. |
|
May 12 |
comment |
mysql replication successful but slave not replicating Do not look at SHOW MASTER STATUS on the slave. This information is not relevant unless the slave is also serving as a master for other slaves further downstream. |
|
May 12 |
comment |
mysql replication successful but slave not replicating When Replicate_Do_DB is not set, all databases are replicated. |
|
May 12 |
answered | Drop database locked the server |
|
May 12 |
answered | Synchronise data from one table to another & vice-versa using triggers |
|
May 12 |
comment |
'Offline' MySQL backup - server not starting The "partition" is too full? Meaning the hard drive partition? What's the exact error message? |
|
May 10 |
answered | Slow query joining on subqueries with max |
|
May 10 |
revised |
mysqlslap chokes on strings that contain “;” delimiter? add info |
|
May 10 |
comment |
How to use and optimize subquery on 100 million rows The answer depends, in part, on whether domain_ID is the primary key or is at least a unique key in domain_setting. I'm resisting the temptation to assume that it is. |
|
May 9 |
comment |
Req: Typical location of mysql query cache CodeIgniter stores queries on disk and calls this the "query cache.“ This is unrelated to the MySQL query cache: ellislab.com/codeigniter/user-guide/database/caching.html... |
|
May 9 |
comment |
Master updates Slave but not Master itself Then, unless I failed to find the relevant place in the source for the documented trimming behavior, I would suggest it must have been the first alternative, the event was sent to the slave and never committed to the master binlog on disk ... you had a hardware crash and sync_binlog = 0 making this scenario very probable. |
|
May 9 |
comment |
how to avoid the maximum--execution time error This is a PHP configuration issue, not MySQL. |
|
May 9 |
revised |
Master updates Slave but not Master itself additional info |
|
May 8 |
comment |
Plugin 'FEDERATED' is disabled EasyPHP apparently (gasp) installs MySQL with an empty root password... so unless you have set that password, you should probably not specify the -p. |
|
May 7 |
revised |
mysqlslap chokes on strings that contain “;” delimiter? added 66 characters in body |
|
May 7 |
answered | mysqlslap chokes on strings that contain “;” delimiter? |
|
May 7 |
answered | Plugin 'FEDERATED' is disabled |
|
May 6 |
comment |
Error “#1118 - row size too large” on the first row of the table only Ah, sorry, since there are some skipped numbers, I assumed you had omitted some columns. What is the major/minor/release version of your server? (e.g., 5.1.67) |
