Speed up a wordpress site is not a MySQL settings issue. One site in order to perform well is to USE MySQL with the best efficient way (limit your queries results, get only what you need) Default wordpress database schema have been already set up (primary keys, indexes e.t.c) to be used by the default … Read more
You can query INFORMATION_SCHEMA and achieve the same: function getEnumValues($table, $field) { global $wpdb; $result = $wpdb->get_row(“SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘” . DB_NAME . “‘ AND TABLE_NAME = ‘” . $table . “‘ AND COLUMN_NAME LIKE ‘” . $field . “‘”); if($result === FALSE) { die($wpdb->last_error); } // this is the column … Read more
Find duplicate posts with same slug and author
Keeping database within limits, please help!
Something tells me that it could be the maximum script execution timing out perhaps. The amount of memory your inserts are consuming could also be the culprit. Are you getting any error messages, blank screens or anything like that? You could try adding the following above where you’re calling the wp_insert_post() function: set_time_limit(0);
I am setting up Subdomain based MU on my domain. Just remember, what used to be called “WordPress MU” is now “WordPress Multisite.” It’s not a separate application, just a configuration setting you use within WordPress. Will I be better off setting the MySQL user’s domain as localhost, 127.0.0.1 or with a wildcard %.mydomain.com? Which … Read more
DISCLAIMER : Only a MySQL DBA, not WordPress expert You could migrate the database as follows: Very first thing is to locate the my.ini for MySQL. Search all data volumes until you locate my.ini Next, login to MySQL and run SHOW VARIABLES LIKE ‘datadir’; This will tell you what folder MySQL data is stored. For … Read more
So I figured out the issue. I wasn’t familiar enough with how urls are handled in XMLHttpRequest. I needed to change downloadUrl(“http://wp-content/themes/oxygen-child/phpsqlajax_genxml3.php”, function(data) { to downloadUrl(“http://www.theworldsflgiht.com/wp-content/themes/oxygen-child/phpsqlajax_genxml3.php”, function(data) { Thanks for the help everyone!
Upon testing this on my demo site it seems to work perfectly well simply storing DateTime columns as a %s (String). After inserting like this the database reports the DateTime column exactly as expected.
WP options (which is one of the most basic and used storage APIs) can be stored with or without “autoload” setting. Usually this is reasonable, since many options will be checked on each and every page load, so loading them in bulk during core load is much more efficient than individually. Problems usually start when … Read more