Tag: mysql

27 Which MySQL Server provides a better performance for Magento 2013-02-22T18:20:55.067

25 How to optimise database architecture for high volume sites? 2013-01-23T02:53:05.433

15 PDO exception while executing cron: newsletter queue send fails (Unknown column 'main_table.data' in 'field list') 2015-02-12T16:51:22.087

12 Integrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID' 2015-09-09T18:58:32.040

10 MySQL keeps hanging (queries stuck on sending data) 2013-02-13T12:41:03.360

9 Ok to truncate report_viewed_product_index 2014-11-11T10:56:18.630

9 Some Magento tables are not InnoDB, is it safe to convert all tables to InnoDB? 2015-08-20T15:56:37.127

8 Customized Customer Grid causing MySQL table scans and filesorts aka slow performance 2013-01-28T06:30:47.927

8 For a cms/block entity, why are the subordinate data deleted from cms_page_store explicitly? 2013-02-11T15:49:56.807

8 Mysql access denied error 2013-10-14T16:45:31.510

8 SQLSTATE[HY000] [2002] No such file or directory error 2015-01-13T06:05:04.483

8 How to list all disabled products with sql? 2015-09-14T11:50:15.510

7 Cron crashes MySQL 2013-02-11T14:40:45.367

7 Is Magento CE 1.7.0.2 compatible with MySQL 5.5 and PHP 5.3.28? 2013-12-26T16:02:24.867

7 Is there a method in Magento that allows to create MySQL triggers and stored procedures? 2015-05-22T12:30:58.960

7 Indexing and lock files 2015-06-30T09:46:52.763

6 Configurable Products - attribute label, "use default" issue 2013-02-11T19:30:25.803

6 Magento: what is the `customer_payment` entity type used for? 2013-03-04T20:49:57.813

6 Disconnect & Reconnect MySQL core_read / core_write Connections 2013-11-22T10:51:03.707

6 Add to cart / checkout performance issues 2014-01-25T18:55:29.717

6 Collections - Filtering multiple multi-select attribute values 2014-01-30T03:07:09.747

6 Which, if any, MySQL / InnoDB (strict) modes to use? 2014-03-26T01:02:45.423

6 How to handle huge sales_flat_quote tables - remove abandoned cart refuse 2014-09-22T15:23:38.357

6 Magento 1.8 Need database query change all products custom design template 2014-10-07T17:16:25.847

6 Configuring the local.xml file to connect securely to an external MySQL? 2015-03-26T21:44:09.470

6 Install Magento2 using different MySQL port 2015-06-29T14:22:38.687

5 LEMP Stack Suggestions for a 10k + Item Magento Community Install 2013-03-08T17:28:02.200

5 How to prevent lock wait timeout from blocking orders? 2014-03-10T21:30:57.913

5 How to move magento shop to another server 2014-06-04T05:34:36.140

5 Switching back to MySQL sessions after using Redis sessions 2014-06-23T17:34:47.977

5 Magento Too many tables error bulk updating products 2014-09-01T08:38:24.227

5 Getting SQLSTATE[HY000]: General error 2015-09-28T07:26:54.773

5 SQL Syntax error or access violation: 1142 TRIGGER command denied to user 2015-11-13T15:38:37.270

4 An error occurred while saving the URL rewrite 2013-02-07T16:32:02.037

4 1.7 bug - MySQL hanging due to top navigation menu caching bug 2013-03-03T17:31:58.523

4 Drop tables in Magento 2013-10-23T17:16:09.403

4 Add new column to an EAV table `catalog_product_entity` 2013-12-21T12:42:08.630

4 Any reason why I shouldn't automate localization setup with a script? 2014-03-03T03:01:27.703

4 Huge pdo_mysql.log - turning off logging doesn't stop it from growing 2014-06-13T15:37:22.430

4 How do I call a stored procedure from Magento code? 2014-06-16T13:46:11.847

4 Speeding up a "Multiple Version Jump" Database Update 2014-06-17T17:46:18.300

4 Magento Scheduled Backup is not working 2014-08-14T04:47:12.220

4 Magento aggregate collections? 2014-08-21T10:20:17.057

4 Page load issues from Magento Group Product Page request. Help Needed 2014-10-10T21:16:42.170

4 Zend > DB > Query > quote column 2014-12-03T14:42:18.400

4 Possible Magento Hack ? Server load very high, with MySQL server has gone away end 2015-05-19T17:25:27.560

4 Magento Product "created_at" Date Format Keeps Changing 2015-05-30T20:14:55.960

4 Magento catalogsearch_fulltext reindex 2015-09-02T04:33:57.003

4 Mass delete disabled products with sql 2015-09-16T13:51:21.467

4 Is my site open to MySQL injection? 2015-10-29T09:54:59.157

4 Magento 2.0 with MySQL 5.5 2015-11-20T19:47:09.413

4 Cannot create new module in magento2 - php bin/magento setup:upgrade 2015-11-21T19:15:47.737

3 Disable modules via database 2013-06-24T14:38:17.517

3 InnoDB on MySQL 5.6 with OSX/CE1.7 2013-11-13T18:42:39.253

3 How can I resolve Foreign Key constraint 'SQLSTATE[23000]: Integrity constraint violation: 2013-11-19T08:28:15.030

3 Optimize Mysql Configuration for deadlock error 2013-12-16T09:24:53.960

3 How do I get the MySQL (updated) affected rows when using the Magento resource? 2013-12-24T07:17:56.253

3 Place Order hangs with 2006 MySQL server has gone away 2014-01-31T15:18:35.637

3 Find the attribute_id by attribute_code 2014-02-11T15:20:08.947

3 User Error: Some transactions have not been committed or rolled back 2014-02-14T07:51:28.163

3 How to edit SQL error generated by PDO.php? 2014-02-20T16:07:57.050

3 Magento: Fatal error: Cannot override final method Mage_Core_Model_Abstract::clearInstance() 2014-02-28T19:43:54.797

3 Magento to find shopping cart rule match by product programmatically? 2014-04-01T06:09:10.793

3 If there is one item left in inventory I get SQLSTATE ERROR 2014-06-05T15:09:12.410

3 Set Mysql variable in magento 2014-08-18T06:37:26.303

3 Magento get list of products which never ordered 2014-09-09T06:22:18.763

3 How to fetch complete customer data in magento with address and whole data related to entity_id 2014-11-04T11:27:08.323

3 How to write to the database from the head file? 2015-01-07T10:27:01.970

3 MySQL get data from Custom table via _prepareCollection 2015-02-07T22:28:36.040

3 Can I truncate tmp tables? 2015-02-09T23:01:47.227

3 VARCHAR truncated to 25 characters when saved through model 2015-03-12T06:25:44.910

3 New magento website + old database 2015-03-12T08:48:59.033

3 mysql 5.5 or 5.6 is better for magento 1.9.1 2015-04-03T03:03:47.660

3 MD5 passwords from MS SQL to MySQL 2015-04-24T04:21:47.870

3 Change bundle product price type via database 2015-05-06T08:38:11.763

3 Magento - Rating and Reviews - SQL Error 2015-05-11T08:30:56.607

3 enterprise_refresh_index Sleeping MySQL Connection 2015-06-12T04:10:52.573

3 Error in admin category tab? 2015-06-18T06:31:33.470

3 Magento admin taking too much time to save product in admin 2015-07-06T12:44:45.683

3 Magento product stock alert cron job 2015-07-08T12:52:10.783

3 Defeating SQL Deadlocks? 2015-08-26T21:26:15.897

3 Sanitizing with mysqli::real_escape_string in Magento 2015-09-11T07:57:08.670

3 Getting latest record when using Group by in magento 2015-09-18T04:52:15.483

3 Catalog URL Rewrites Error 2015-09-25T23:16:45.877

3 MySQL server has gone away when maual reindex catalog_product_flat 2015-11-25T01:40:00.643

3 Get Quote ID from an Order ID or Order Number SQL? 2015-12-01T02:21:53.557

2 How to retrieve full customer name with SQL? 2013-02-04T23:27:43.333

2 Can I use another database for media_storage? 2013-04-03T13:57:29.370

2 Magento site shows error SQLSTATE[HY000]: General error: 5 Out of memory 2013-07-06T11:26:29.263

2 MySQL fails to start 2013-08-26T14:40:11.053

2 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away on running cron job magento 2013-08-28T10:24:19.610

2 How do you deal with 61 tables join limit when building magento collection? 2013-09-06T10:25:23.720

2 Remove duplicate product photos 2013-09-11T22:37:40.443

2 #1062 - Duplicate entry '3-285-42-0' for key 'UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID' 2013-09-26T09:26:20.667

2 Magento setup with RAID10 2013-09-27T16:48:37.707

2 Mysql joins 'e' v 'main_table' - flat v eav 2013-10-11T17:38:19.920

2 Get number of products faster 2013-10-22T08:14:43.323

2 Slow cart, long query is updating sales_flat_quote 2014-01-23T22:39:13.573

2 Magento "INSERT IGNORE INTO" 2014-01-26T12:06:18.223