Posts Tagged ‘mysql’

One Tool Inadvertently Helps Cure Others’ Ills

2
responses
by
on
December 2nd, 2010
in
Cool Scripts, WordPress Plugins

So we have not made it a secret on this blog that we are big fans of VaultPress as a product (Disclosure: They are advertisers on this blog). I have been using it on this blog (amongst others) for our protection and have happily paid for our privilege and peace of mind. It has been a little rocky to get started and we have offered and received help and feedback for the issues we ran into during the initial sync with VaultPress. The peace of mind is satisfying, the support is very reasonable, the product is a “set it and forget it” and as such, it runs on its own. I check the security area once in a while and marvel at the number of comments and other statistics that are mildly interesting but not all that helpful. Then I noticed something last morning that made me think. I know that does not […]

[Continue Reading...]

WordPress Bids Farewell to PHP 4 and MySQL 4

10
responses
by
on
July 25th, 2010
in
WordPress, WordPress News

After five years of dedicated support, WordPress will be leaving PHP 4 and MySQL 4 behind for the far more current and secure PHP 5 and MySQL 5. WordPress 3.2, planned to launch during the first half of 2011, will be the first release to require PHP 5.2 or higher and MySQL 5.0.15 or higher. The change really comes as no surprise. Both PHP 5 and MySQL 5 are far more secure than their predecessors and they are actively developed. How long has it been since an update was made to PHP 4 and MySQL 4? The final version of PHP 4 was released during August of 2008, followed by the final version of MySQL 4 on December of 2008. Both PHP 4 and MySQL 4 have been discontinued for almost two years. The WordPress team is confident that the change in requirements will be relatively inconsequential. According to Mark […]

[Continue Reading...]

Scaling WordPress Part 1: Using MySQL Replication and HyperDB

21
responses
by
on
March 27th, 2010
in
WordPress Tips

Everyone loves to get loads of traffic to their websites, however, websites get timed out or respond very slowly when many users try to access it at the same time. WordPress does a pretty good job of handling lots of users at once, however it in itself cannot help you manage all the traffic, and you need proper server setups and cache setup to scale to accommodate more users.

[Continue Reading...]

How many Queries are too many?

41
responses
by
on
July 12th, 2008
in
Blogging, General, WordPress

I have been asked this question quite a few times and I never have a perfect answer. It is obviously an important question to ask but it can be answered in many different ways based on preferences, need for plugins, optimization techniques used and a variety of other factors. Weblog Tools Collection uses a lot of plugins and is very query heavy but the in spite of that, the front page uses 59 queries to generate itself. I think the default (on a vanilla WordPress install on the default theme) is 27 or something of that nature. The larger the number of queries, the slower the page is going to load and the more load you are going to put on your MySql server. All of the above is true if you do not use inline or regenerative caching mechanisms. The caveat on this blog is that its plugins and […]

[Continue Reading...]

DiggProof your WordPress

1
response
by
on
January 23rd, 2007
in
Blogging News, WordPress, WordPress Hack

DiggProof your WordPress A close look at optimizing and tweaking your MySql database for WordPress and other tips and plugins to make your WordPress blog faster than it already is. Even though WordPress is fast in its own right, this article is geared for high traffic blogs and especially those that run WordPress on smaller Virtual Private Servers. While we are on the subject of optimizations, the newly released WordPress 2.1 Ella has introduced many code and query optimizations that should make WordPress much faster than it already was. For example, one of the changes introduced to handle future posts gives the database the ability to cache more queries at the MySql level and should reduce load on the database server (however minuscule).

[Continue Reading...]

Closed, Open Source Share Compatibility Problems

2
responses
by
on
December 13th, 2005
in
Blogging News, LinkyLoo

Closed, Open Source Share Compatibility Problems: Interesting take on the compatibility problems brought onto WordPress by the latest versions of Mysql running in “strict” mode as default. Especially poignant here because I see well greased programmers moving to the postgresql model because of a shift of ideologies of the mysql group. I should look into the added benefits that the strict model provides to the system.

[Continue Reading...]

MYdbPAL Free Download

No
responses
by
on
October 19th, 2005
in
LinkyLoo

MYdbPAL Free Download: I am not sure of this program and you are on your own to figure out how this works but from my initial reaction, though the user interface is hideous, it can be a useful database education tool and provide good insight into existing database schemas. Thanks SlickDeals

[Continue Reading...]



Obviously Powered by WordPress. © 2003-2013

css.php