New answers tagged

0

Joining the mailbox table to a "FolderNames" table using a foreign key will be problematic if any particular user wants to change the name of any given folder, without changing that name for everyone else. You could get around this by having a nullable CustomFolderName column in the mailbox table. Depending on the expected number of accounts, storing the ...


1

Solution 1: After hormonizing all tables to MyISAM the Query-Cache of MySQL worked as expected again. Added some indexes for cd and parent to speedup the queries about 30%. Solution 2: Set up MySQL-Proxy and created LUA-Script to cache Result of query in MySQL-Proxy. Shop-Software was set to use the MySQL-Proxy on Port 3307 as MySQL-Server. apt-get install ...


1

In general, if 2 queries are identical, they will have the same sql_id, and as a result, the same execution plan (which may change over the time, but it shouldn't depend on which user executes the query). (** It's oversimplified, because starting with 11g Oracle can generate multiple plans based on values of bind variables, presence of histograms ). So ...


1

query_cache_size = 512M is really bad. Don't use more than 50M. Otherwise, whenever a write occurs, all entries in the QC for that table need to be purged; this will take too long. Other tips: http://mysql.rjweb.org/doc.php/memory When you get further along, the most likely performance issue will be the lack of optimal indexes on tables. After that ...



Top 50 recent answers are included