Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 129206

MySQL is an open-source, relational database management system.

2
votes
MySQL shouldn't crash because of queries like those, but it could feel like it does because your site won't work. I'd first run SELECT option_name, length(option_value) FROM wp_options WHERE … don't show anything weird, you may want to look into MySQL itself. Is the RAM on your machine exhausted and (slow) SWAP is being used? Is there a faulty hard disk and re-reads are timing out? …
answered Dec 23 '17 by janh
1
vote
$wpdb->query() doesn't return the data but the rows affected, use $wpdb->get_var().
answered Dec 3 '17 by janh
1
vote
Don't put single quotes around placeholders, they are added automatically. Turn '%s' into just %s.
answered Dec 4 '17 by janh
3
votes
Normalizing data is more efficient, and storing serialized data in a table field that you want to search / work with on DB level isn't something for Non-Nosql RDBMS like MySQL/MariaDB. Searching …
answered Oct 27 '17 by janh
1
vote
Apache only runs the index.php of WordPress, and serves static files (images, css, js etc). WP does all the rest, including parsing the request to find out what content to show the user. Apache does n …
answered Nov 6 '17 by janh
1
vote
You'll have to make the variable global when you define it, e.g. global $mydb; $mydb = new wpdb('username','password','database','localhost'); and then use global $mydb; in the other plugins. Aside …
answered Oct 23 '17 by janh
0
votes
Look at the documentation, $wpdb->delete() takes at least two parameters, the table name and the Where-conditions as an array(). LIKE isn't supported for delete imho, so you'll need to use ->query gl …
answered Oct 8 '17 by janh