…:59:05 [Note] WSREP: Read nil XID from storage engines, skipping position init 130221 17:59:05 [Note] WSREP: wsrep_load…: Reusing existing ‘/var/lib/mysql//galera.cache‘. 130221 17:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150….dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size…
Comment: MySQL VIEW as performance troublemaker
May 6, 2010 By 57 Comments
mysql view are good, but certain care is required – 1. tables … you do it before dumping data in the tables) 2. skip any where clause, or group by clause 3. drop off… multiple views, based on the column required 4. increase sql cache / memory (hosting providers … ahem ahem!) 5. do not mix views with…
