DTest

Knoxville, TN

orange-pants.com

Age: 33

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.

Aug
27
comment MySQL - include a default value in LOAD XML INFILE statement
Can this not be built into the logic of whatever creates the xml file?
Aug
23
awarded Yearling
Aug
23
awarded Yearling
Aug
19
comment MySQL Circular Replication
Can you explain what you mean that server can make changes to tables whether state is online or offline? Specifically in your scenario how does a server make changes to tables when it is offline?
Aug
4
awarded Constituent
Jul
28
awarded Caucus
Jul
15
awarded Nice Answer
Jul
7
comment Can MySQL walk through the files of a directory?
Can you explain why you would want this? MySQL is a datastore, not a programming language.
Jun
29
awarded Enlightened
Jun
29
awarded Nice Answer
Jun
24
reviewed Approve suggested edit on Unable to show binary logs how to remove logs from mysql?
Jun
16
awarded Popular Question
Jun
12
awarded Notable Question
Jun
8
awarded Notable Question
May
14
awarded Good Question
May
8
awarded Popular Question
May
7
awarded Nice Question
Apr
24
answered MariaDB/InnoDB: What to do on "Locks in Status-Log but no locked table found"
Apr
16
awarded Good Answer
Apr
10
comment Dynamic change to innodb_flush_log_at_trx_commit
@Pacerier In general, changing any GLOBAL dynamic variable that has a corresponding SESSION variable won't affect currently connected sessions.
1 2 3 4 5