72,802 reputation
1172166
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 11 months
seen 33 mins ago

10h
comment what would be the primary disadvantages of splitting my tables into table spaces and/or separate schemata
This question asked for disadvantages only and that's what I named, just disadvantages. That other answer from Dave Rix (dba.stackexchange.com/a/7929/877) named advantages that can outweigh disadvantages. Even with my own answer to that same question (dba.stackexchange.com/a/7930/877) I described a mutlitentant situation I had to manage at the customer's request (I had no say with scale-out or scale-up). I have discussed it before (dba.stackexchange.com/a/1690/877) Having face nothing but disadvantges over the years, Dave Rix's answer was refreshing, cool and deserved +1.
16h
reviewed Close How to normalize a table that contains a CK not included in the PK?
16h
reviewed Close Login failed for user - Error: 18456, Severity: 14, State: 38
17h
comment Cannot add a column to an InnoDB table in Mariadb
Good work, +1 !!!
19h
answered Joining WordPress Comments with Post Titles from MySQL DB
19h
reviewed Looks OK how to check whether Oracle database is accessed or not?
19h
reviewed Leave Closed Find Longest Running Query
20h
revised MySQL Data Files Missing?
edited tags
20h
reviewed Close Can I create a constraint to a subset of data?
20h
reviewed Close Advisable number of foreign keys in a single table
20h
reviewed Close MySQL TRIGGER with test on minute datetime
20h
comment MySQL Data Files Missing?
InnoDB allows multiple ibdata1 files (See my post dba.stackexchange.com/questions/43503/…)
20h
revised MySQL Data Files Missing?
edited body
20h
revised MySQL Data Files Missing?
added 565 characters in body
21h
answered MySQL Data Files Missing?
22h
comment MySQL Data Files Missing?
As shown, you have 1.608 GB of MyISAM, 210MB of InnoDB. Therefore, your data is not missing.
22h
comment MySQL Data Files Missing?
I am sorry wrong query. Please run this: SELECT * FROM information_schema.global_variables WHERE variable_name IN ('datadir','innodb_file_per_table','innodb_data_file_path','innodb_data_home_dir‌​‌​');
23h
reviewed Close SQL Server Temp Database Monitor Tools
23h
reviewed Close Testing databasis for learning
23h
reviewed Leave Open SQL Query Formatter