mysql – Page 40 – Türker Yıldırım

posts_per_page => -1 is a query with no ceiling

NoteJanuary 8, 20132 min read

Asking for every post is one argument away, which is why it survives review: it works on the development database, and the development database has forty products in…

WooCommerce variations are posts with the variable product as parent

NoteDecember 29, 20123 min read

A variable product looks like one thing in the admin and is not one thing in the database. The product is a single product post; each variation is…

An index is unused if the query wraps the column in a function

NoteNovember 20, 20122 min read

An index holds the column’s values, in order. YEAR(created_at) is not one of those values, so there is nothing for the optimiser to look up — it has…

Delete all WordPress post revisions

SnippetNovember 8, 20121 min read

Swapping Apache and mod_php for nginx and PHP-FPM

Deep diveOctober 23, 201216 min read

512 MB, 150 concurrent visitors, and a box that swaps before the CPU is busy. Replacing Apache and mod_php with nginx and PHP-FPM, in three stages that each…

long_query_time takes a fraction of a second in MySQL 5.5

NoteOctober 9, 20122 min read

long_query_time was an integer in MySQL 5.0, so one second became the conventional slow-query threshold and stayed there out of habit. It has taken a float since 5.1.…

Import a large SQL file into MySQL from the command line

SnippetOctober 2, 20121 min read

Change the character set of a MySQL table

SnippetSeptember 26, 20121 min read

Find tables without a primary key in MySQL

SnippetJuly 3, 20121 min read

BuddyPress keeps groups in its own tables, not in posts

NoteJune 28, 20123 min read

Everything else in a WordPress install is a post, so the first instinct with a BuddyPress group is a WP_Query against some post type. There is not one.…