68,888 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 19 mins ago

One of JEHOVAH's Witnesses (TV)

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

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


23h
reviewed Close mysql server bigint
23h
reviewed Close Stock table Database Design
23h
reviewed No Action Needed Help with indexing narrow table with many millions of rows
23h
reviewed Approve suggested edit on How το find last time database was accessed and the inventory of all application and users accessing it?
1d
comment optimize my query mysql
You should change the storage engine back to InnoDB. Then, upgrade to MySQL 5.6.21.
1d
comment optimize my query mysql
Based on that error message, you are not using MySQL 5.6 because FULLTEXT indexes are supported in InnoDB now (dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html). If you upgrade to MySQL 5.6, you can make FULLTEXT indexes in InnoDB.
1d
answered optimize my query mysql
1d
revised optimize my query mysql
added 10 characters in body
1d
answered Mysql update adding subquery field value to field
1d
answered Find the last visit by teacher and show the rest of columns in MySql
1d
comment Duplicate values
Please mark it accepted by clicking on the check mark
1d
reviewed No Action Needed Too many columns in MySQL
1d
revised Should I separate frequently updated columns?
edited title
1d
revised avoiding unique key collisions across tables
added 8 characters in body
1d
revised avoiding unique key collisions across tables
added 6 characters in body
1d
revised Is it better to separate a big query into multiple smaller queries?
edited body
1d
revised Is it better to separate a big query into multiple smaller queries?
added 1 character in body; edited title
1d
revised Should I separate frequently updated columns?
added 16 characters in body
1d
revised Should I add it as an additional column or a seperate table?
edited body
1d
revised Combined or separated tables: File and Message?
added 3 characters in body; edited title