Percona's MySQL & InnoDB performance and scalability blog
we use sphinx to our website where we have about 1200 tables each with … described here, but the search results have gone from milliseconds to more than 43 seconds
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
… optimizer and see how easy it is? ;-) Generative grammars like SQL can produce an infinite variety of queries. The query optimizer… ORDER BY RAND() solution is known to have poor performance, but it returns a better random choice. Another workaround may be to add a column to… efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first…
…to 1.18. You can also follow the official documentation here. The version of Pacemaker (always considered as Technology Preview by…cluster nodes in order to deliver membership and quorum information to clients (such …conf –createcluster lefred_prm Now add the nodes to the cluster: [root@percona1 ~]# …
…/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For… (potentially corrupted via user error or other issues) with SQL rather than needing to import from a remote server. This can allow… script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql…
… efficient to have multiple ( 7-10 ) different tables and minimize the record count in each table or would it be faster to add a column to differentiate between my types of data and put them… in the multiple column scenario and 16 if I had to add a data type column. We are probably looking at 2…
Miguel: Filters can be combined, but there’s no way (that I know) to achieve what you want with this plugin. You could add mysql.user to the audit_record_objs variable, for example, but not indicate a specific user for which you want to audit changes.
… the same columns (in the same order) and the server will not complain…. warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2); Query OK… will be stricter: in the default SQL mode, a duplicate index will throw… both columns, but also for filtering by just the first one. Why can…
…leave all filters disabled; on the relay master you add binary log filters; this ensures that the top-… in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that … similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be talking to …
… FREE one-day educational events, we are pleased to feature 10 technical talks by members of Team Percona as well as local… used to provide access to government data. The daylong event will be held at Portland State University’s Smith Memorial Student Union, located… reception at the famed Paddy’s Bar and Grill sponsored by Tag1 Consulting featuring great networking possibilities and free drinks for…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.