Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with database
Search options not deleted
user 49978
Questions related to Magento's MySQL database, for example, the table schema, plain SQL queries or database configuration. For questions about the Magento database access layer, use other tags, like: eav, model, resource-model, collections, install-script. For questions about SQL queries in particular, the SQL tag is appropriate too.
2
votes
Accepted
AWS Read Replica fails to sync magento MEMORY-engine table
After some research it seems that converting those tables using engine "MEMORY" to engine "InnoDB" might work. Although this is not supported, and there seems to be no "official answer", all known fac …
- 1,137
1
vote
1
answer
1k
views
How to add a foreign key with onUpdate Cascade in an M2 installer script?
I want to add a table with a foreign key in an installer script.
The foreign key should have
ONDELETE CASCADE and ONUPDATE CASCADE set, - but the ->addForeignKey method supports only the ONDELETE o …
- 1,137
2
votes
Accepted
How to find out If Magento MySQL is hosted on AWS RDS
First, you could check the database connection string in your app/etc/local.xml file. You might find it in the xml structure inside config > global > resources > default_setup > connection > host. …
- 1,137
1
vote
Accepted
How to add a foreign key with onUpdate Cascade in an M2 installer script?
The ONUPDATE CASCADE is executed, when the row id of a record is changed. This should not happen in Magento at all, as the ids are unique and persistent over their lifetime. Actions like the change of …
- 1,137
2
votes
2
answers
843
views
AWS Read Replica fails to sync magento MEMORY-engine table
Our Magento 1.9 database is hosted on AWS RDS. For improving database performance, we created an Amazon Read Replica.
Unfortunately, the read replica runs out of sync. …
- 1,137