11,737 reputation
43269
bio website
location Knoxville, TN
age 32
visits member for 3 years, 9 months
seen yesterday

I started my professional career as a PHP application developer. A few years later, as the company I worked for grew, I started migrating into the server world. Now I find myself as the DBA and beginner Server Admin.


8h
awarded  Explainer
Sep
5
awarded  Popular Question
Sep
3
awarded  Good Answer
Sep
3
awarded  Popular Question
Aug
13
awarded  Nice Answer
Aug
13
comment Restoring data from dumped sql file gives: mysql: unknown option '--innodb_file_per_table
Hmph, I swear I looked at [mysql] vs [mysqld]. Ah, I did...but you edited it earlier in the process...Oh well, glad you figured it out :)
Aug
12
comment Restoring data from dumped sql file gives: mysql: unknown option '--innodb_file_per_table
What version of MySQL?
Aug
6
comment MySQL buffer pool usage + high load
Specifically, I am referring to the swapping that might occur to a full innodb_buffer_pool. Read the last update of this answer to see if multiple innodb_buffer_pool_instances makes sense for you: dba.stackexchange.com/a/1185/180
Aug
6
comment MySQL buffer pool usage + high load
Did you notice any swapping leading up to this point? What's swappiness set to?
Jul
19
awarded  Nice Answer
Jul
3
awarded  Favorite Question
Jul
2
awarded  Curious
Jun
27
comment Audit DML operations on MySQL Tables
what version of MySQL?
Jun
26
awarded  Nice Question
Jun
12
awarded  Notable Question
Jun
7
awarded  Notable Question
Jun
6
reviewed Leave Closed Search, filter and group across all columns in a tall and wide dataset quickly
Jun
6
reviewed Approve suggested edit on ZLM 7.3, postgres database must be vacuumed within x transactions
Jun
4
reviewed Leave Closed Split a very large SQL table to multiple smaller tables
Jun
4
comment Only “grant usage”, but can still select, drop, create?
Any entries in mysql.db for the user?