63,678 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 42 mins ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


17h
comment How does subpartitioning actually work and what physical files are created?
I updated my answer
17h
revised How does subpartitioning actually work and what physical files are created?
added 470 characters in body
17h
comment How does subpartitioning actually work and what physical files are created?
Run the query show global variables like 'datadir';. cd that folder, and you will see the ibdata. Then cd test a dn run ls -l nums_comp*. That's where the files should be. since they are not there and the information_schema says they are there, the table is logically inside ibdata1.
17h
revised How does subpartitioning actually work and what physical files are created?
edited tags
17h
answered How does subpartitioning actually work and what physical files are created?
2d
reviewed Close Neo4j vs MongoDB (pros and cons)
2d
reviewed Close aggregate type problem
2d
reviewed Close What Is dummy bind in mainframe?
2d
reviewed Close How can I automatically add a foreign key to a table on select which is stored in an associated other?
2d
reviewed Close Best open source DB technology to store and query large, sparse matrices
2d
reviewed Close SQL Server table scan when query parameter doesn't exactly match column
2d
reviewed Close Scaling mongoDB & Node.js
2d
reviewed Close Best Mysql Settings for my server
2d
reviewed Leave Open How to convert time to minutes in Mysql
2d
reviewed Close Can I use PHP function strtotime() in SQL queries?
2d
reviewed Close Is data warehouse monitoring same as database monitoring?
2d
reviewed Close RAID configuration for mysql
2d
reviewed Leave Open Optimal Database Configuration
2d
reviewed Leave Closed Log File Size near 100% - How to find Active Transaction
2d
comment Mysql syntax error when i add on completion preserve
I fixed it back in the other post : dba.stackexchange.com/a/75237/877