DTest

Knoxville, TN

orange-pants.com

Age: 32

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.

1d
awarded Famous Question
2d
awarded Popular Question
Sep
5
awarded Popular Question
Sep
3
awarded Good Answer
Aug
25
awarded Popular Question
Aug
23
awarded Yearling
Aug
23
awarded Yearling
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
3
awarded Favorite Question
Jul
2
awarded Curious
Jul
2
awarded Curious
Jul
2
awarded Curious
Jul
2
awarded Curious
Jul
2
awarded Curious
Jun
27
comment Audit DML operations on MySQL Tables
what version of MySQL?
Jun
26
awarded Nice Question
1 2 3 4 5