new multisite, old db
new multisite, old db
mysql
Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type=”attachment””
Obtaining user table for one site on multisite set up
Yes, all the WordPress Multisite users go into the {$wpdb->prefix}users table; that way they form a pool of users that can each be given access to one or more sites in your network. You can get the users for a given site by using get_users(), which can take as an argument the ID of a … Read more
wpdb custom tables without plugin
wpdb custom tables without plugin
How to prevent/delay MySQL connections when an object cache is used?
I’m currently dealing with a site using W3TC plugin and that plugin seems to provide a custom database handler which actually caches queries to memcache. Give that a try. Sidenote: Just make sure, in case you are using multiple production servers, to use a shared memcache server and that you don’t cache those queries on … Read more
Multiple instance of data in plugin custom database table on plugin activation
Add a check when the plugin is activated to see if the data(column/table) already exists in db or not ? If the data aldready exists then skip the db part and just mark the plugin as active.
MySQL query to mass change role of users
MySQL query to mass change role of users
MySQL 5.5 upgrade ‘broke’ WordPress [closed]
Your best bet would be to take DB and site backup and see if you can get it working on local server or any other server, if you do get it running the problem is with the way server probably changed some settings while upgrading. Also in the screenshot image isn’t loaded, but can you … Read more
Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
Alter wp_post table vs. post_meta performance/speed
Alter wp_post table vs. post_meta performance/speed