network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 11 months |
| seen | 16 hours ago | |
| stats | profile views | 43 |
|
Jun 10 |
awarded | Popular Question |
|
Jun 3 |
awarded | Notable Question |
|
May 30 |
awarded | Popular Question |
|
May 25 |
comment |
Setting mysql slow query to less than 1 second dev.mysql.com/doc/refman/5.5/en/slow-query-log.html |
|
May 9 |
awarded | Popular Question |
|
May 3 |
comment |
How to avoid lagging when enabling log-slave-updates? @Michael-sqlbot: yes. With my current settings: innodb_max_dirty_pages_pct = 0, sync_binlog = 1, the slave can keep up normally. But if I enable the log-slave-updates, the slave may lag behind the master for a long time. Looks like the sync_binlog is the main culprit: mysqlperformanceblog.com/2009/01/21/… |
|
May 1 |
comment |
How to avoid lagging when enabling log-slave-updates? Almost of tables are InnoDB. Updated my question to provide my.cnf. |
|
May 1 |
revised |
How to avoid lagging when enabling log-slave-updates? added 76 characters in body; edited tags |
|
May 1 |
asked | How to avoid lagging when enabling log-slave-updates? |
|
Apr 22 |
revised |
/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? added 5 characters in body |
|
Apr 22 |
revised |
/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? added 1217 characters in body |
|
Apr 22 |
comment |
/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? No, I didn't shutdown the master before that. But I don't understand what does it matter? |
|
Apr 22 |
revised |
/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? added 2 characters in body |
|
Apr 22 |
revised |
/usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? added 78 characters in body |
|
Apr 22 |
asked | /usr/libexec/mysqld: Normal shutdown, but my team doesn't do that? |
|
Apr 19 |
comment |
Need Permissions Granted: INTO OUTFILE for Mac OS X Don't do that. 775 and add mysql user to the ryan group is better. |
|
Apr 19 |
comment |
Need Permissions Granted: INTO OUTFILE for Mac OS X superuser.com/questions/60150/… |
|
Apr 18 |
comment |
Need Permissions Granted: INTO OUTFILE for Mac OS X OK. Add the mysql user (or whatever user that the MySQL is running as) to the ryan group, then try again: usermod -a -G ryan mysql. |
|
Apr 18 |
comment |
Need Permissions Granted: INTO OUTFILE for Mac OS Xls -ld Users/Ryan/Desktop/SQL/? |
|
Apr 18 |
comment |
Need Permissions Granted: INTO OUTFILE for Mac OS X 1. Which user you're using to log in to MySQL? 2. ls -ld /path/to/Users/Ryan/Desktop/SQL/. |
