Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 60

Displaying posts with tag: Wordpress (reset)

How to make WordPress faster without the use of a plugin
+0 Vote Up -0Vote Down

When it comes to web page load time, she should always say “wow, that was fast”.

A Quick update based on Frederick’s comment below

** Please do not take these tips as THE answer, this is a complement, not a replacement. I have purposely not given specifics on how to configure anything, or what value to set, because I don’t want people copy pasting things, and then having their site crashing. Regarding mod_pagespeed, I said it’s the most bang for OUR buck.. it’s not recommended in production, nor do we have it on for everyone else. **.

Webpage load time is getting more and more important these days, if you go into

  [Read more...]
On HTML Sanitization, What, Why, How
+0 Vote Up -0Vote Down

This is a very good article discussing the different HTML Sanitizers available in the PHP community, what they mean, and the general state of things. Even the WordPress sanitizer (Kses) is included in this review. I really recommend you read this before you start building your own mini cms.

How to: rotate wordpress posts into headline/feature status
+0 Vote Up -0Vote Down

If you’re using the new Arthemia theme for WordPress you might notice that there are two areas of the theme that can have articles promoted to; namely Headline and Featured sections. This is controlled by category association. Basically you have a post and if you want it in the Headline area of the theme you attach the category “headline” to it, similarly for the featured section. Now, let’s say you don’t want to manually change this all the time since it can be time consuming to promote posts to those categories if you want rotating content.

Here’s a simple solution. In this bash script I connect to MySQL and remove the current associations from posts and then randomly choose posts to be promoted to the Headline and Featured categories. This can be

  [Read more...]
451 CAOS Links 2010.07.27
+0 Vote Up -0Vote Down

New projects. Old arguments. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

New projects
# Gemini Mobile Technologies released Hibari, a new open source non-relational database for big data.

# Lockheed Martin launched the Eureka Streams open source project for enterprise social networking.

# Sony Pictures Imageworks expanded its open source initiative with the release of OpenColorIO.

Old arguments
# Kirk Wylie discussed the importance of natural split in open core



  [Read more...]
451 CAOS Links 2010.07.16
+0 Vote Up -0Vote Down

SugarCRM. Funding for EnterpriseDB and Morphlabs. Even more core. And more

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Bittersweet
# OStatic asked whether SugarCRM has violated open source principles.

# Larry Augustin clarified SugarCRM’s approach to open source and openness.

# Savio Rodrigues advised anyone considering SugarCRM not to get hung-up on source code availability.

Funding round
# EnterpriseDB has reportedly raised $7.5m of a planned $12m round of funding.



  [Read more...]
Installing Wordpress on Oracle Enterprise Linux LAMP stack
+1 Vote Up -0Vote Down

A company blog can be easily configured in under 10 minutes using Wordpress, a popular open source LAMP product that runs a reported 12+ million blogs including those found at CNN, NY Times, Wall Street Journal (WSJ), ZDNet, MTV, People Magazine, Playstation and eBay.

A company blog is a great way for the dissemination of information to your user base as well as enabling a means of user feedback via comments.

The following steps show you how to download, configure and get your Wordpress blog operational.

Software Pre-Requisites

  [Read more...]
Speed Up Your Wedding Photography Website in less than 5 minutes.
+0 Vote Up -0Vote Down

If you have a wedding photography website, more than likely you want to showcase your work, or the work of your colleagues. You want to do this, without putting up low quality pictures, nor do you want to make your visitors wait 20 seconds before the page loads. Here are two plugins I use for my clients to help with this.

  • The Smush.it plugin. This plugin compresses your image using the Smush.it API from Yahoo!, I’ve used it to reduce a page size from 3MB to 1.3MB, which meant that visitors were able to see the site faster, and appreciate the photographs rather than their internet connection.
  • W3 Total Cache : This is a fairly advanced plugin that makes your site use MySQL less, and also helps you off load things onto a content delivery
  [Read more...]
How To Diagnose And Fix Incorrect Post Comment Counts In WordPress
+1 Vote Up -1Vote Down

Introduction

If your WordPress comment counts got messed up, whether because of a plugin (I'm talking about you, DISQUS) or you messed with your database manually and did something wrong (yup, that's what I just did), fear not – I have a solution for you.

But first, a little background.

Comment Counts In WordPress

Here's how comment counts work in WP:

  • Posts live in a table called wp_posts and each has an ID.
  • Comments reside in a table called wp_comments, each referring to an ID in wp_posts.
  • However, to make queries faster, the comment count is also cached in the wp_posts table, rather than getting calculated on every page load.
  [Read more...]
Liveblogging at Confoo: [not just] PHP Performance by Rasmus Lerdorf
+2 Vote Up -0Vote Down

Most of this stuff is not PHP specific, and Python or Ruby or Java or .NET developers can use the tools in this talk.

The session on joind.in, with user comments/feedback, is at http://joind.in/talk/view/1320.

Slides are at http://talks.php.net/show/confoo10

“My name is Rasmus, I’ve been around for a long time. I’ve been doing this web stuff since 1992/1993.”

“Generally performance is not a PHP problem.” Webservers not config’d, no expire headers on images, no favicon.

Tools: Firefox/Firebug extension called YSlow (developed by yahoo) gives you a grade on your site.



  [Read more...]
451 CAOS Links 2010.01.25
+0 Vote Up -0Vote Down

WordPress Foundation formed. Reaction to Oracle-Sun approval. And more.

WordPress Foundation formed
# Matt Mullenwag launched the WordPress Foundation.

Reaction to Oracle-Sun’s EC approval

# In a memo Sun CEO Jonathan Schwartz encouraged the company’s employees to emotionally resign from Sun.

# EnterpriseDB and PostgreSQL co-founder Bruce Momjian issued a statement on the EC’s decision to approve Oracle-Sun.

# Mike Hogan





  [Read more...]
Follow-up To Loading CSS And JS Conditionally
+0 Vote Up -0Vote Down

First of all, I'd like to thank everyone who read and gave their 2 cents about the [WordPress Plugin Development] How To Include CSS and JavaScript Conditionally And Only When Needed By The Posts post. The article was well received and will hopefully spark some optimizations around loading styles and scripts.

Here are some discussions and mentions around the web:

  [Read more...]
How To Fix Intermittent MySQL Errcode 13 Errors On Windows
+4 Vote Up -0Vote Down

The Problem

I've had MySQL on my Windows 7 laptop for a bit (as part of wampserver), mostly for local offline WordPress development.

However, even though MySQL is relatively stable, I've been observing a vast quantity of intermittent MySQL errors, as reported by WordPress in the PHP error log (C:\wamp\logs\php_error.log). Here are some examples:

[05-Jan-2010 09:47:51] WordPress database error Error on delete of
'C:\Windows\TEMP\#sql17e0_1a2_6.MYD' (Errcode: 13) for query SELECT t.*, tt.*
FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id
INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id =
tt.term_taxonomy_id WHERE tt.taxonomy IN
  [Read more...]
Four short links: 10 December 2009
+1 Vote Up -1Vote Down

  • Scriblio -- open source CMS and catalogue built on WordPress, with faceted search and browse. (via titine on Delicious)
  • Useful Temporal Functions and Queries -- SQL tricksies for those working with timeseries data. (via mbiddulph on Delicious)
  • Optimal Starting Prices for Negotiations and Auctions --Mind Hacks discussion of a research paper on whether high or low initial prices lead to higher price outcomes in negotiations and online auctions. Many negotiation books recommend waiting for the other side to offer first. However, existing
  •   [Read more...]
    451 CAOS Links 2009.07.31
    +0 Vote Up -0Vote Down

    When open source goes bad. Is open source a success or failure? And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    When open source goes bad

    The H reported on the apparent turmoil at the CentOS project, while Jay Lyman offered the CAOS perspective. Meanwhile Slashdot reported that Alan Cox has quit as Linux TTY subsystem maintainer.

    Success or failure?
    Danny Windham, Digium CEO, responded to Peter Yared’s





      [Read more...]
    RethinkDB all the rage today
    +3 Vote Up -0Vote Down

    RethinkDB is all the rage today, as its a Y Combinator funded startup, which also launched a developer pre-alpha today. So what is RethinkDB you ask? Yet-another-MySQL-storage-engine, that’s what. But this time, its tuned for solid-state drives (SSDs), which also happen to be all the rage these days.

    Anyway, check them out more, and the materials currently tell me that they’re using append-only algorithms, which allow for live schema changes and hot backups, with instantaneous recovery from power failure. Those are just some of the exciting bits.

    What didn’t excite me so much was the fact that you were only getting 32-bit or 64-bit Linux binaries, built against MySQL 5.1.31 and you’ll just

      [Read more...]
    Securing Wordpress
    +0 Vote Up -0Vote Down

    A couple of  weeks ago I got an unhappy email from my web hosting provider telling me I was in violation of their Terms of Service. Of course I called them immediately and was told that there was a “phishing page” hidden in one of my web directories. My blog had been hacked, so I immediately started doing some house cleaning.

    After the initial once over and deletion of any suspicious files I went looking for advice on how to “harden my installation”. Here’s what I found:

      [Read more...]
    Cleaning up Wordpress comment tables
    +1 Vote Up -0Vote Down



    In Montreal with Dups and Kaj, we were looking at a number of technical problems, and each one of you got something valuable from the meeting.
    One of Kaj's problems was a collection of Wordpress blogs infested by spam. Kaj has done something already but the situation was critical. Before applying Akismet to his comments, he needed to cleanup the majority of the spam in same easy way.

    It is not rocket science, really, but it needs some care in the implementation.
    The comment






      [Read more...]
    SELECTing SELECT statements for Wordpress MU blogging statistics
    Employee +1 Vote Up -0Vote Down

    Sometimes I miss the coding I did last century. Today I was reminded of some of the fun, when I had set my mind to doing some statistics on my blogging.

    In a blog entry on http://blogs.arno.fi/isit/2009/05/14/home-made-blog-statistics-from-wordpress-mu/ I describe what I did.

    The blog entry may be of interest for those who use WordPress and are set back by the huge amounts of tables it generates. I happen to host 18 blogs and with each blog requiring 8 tables,

      [Read more...]
    Post by Email
    +0 Vote Up -0Vote Down

    Have you ever wanted to fire off a post from your phone, Blackberry, Outlook at work…? Following on from Comment Reply Via Email we’re introducing our latest feature to make it even easier to publish to your blog: Post by Email.

    Maybe you’re on holiday and want to show your journey. Maybe you’ve captured something with your cell phone that you just have to share. Maybe you’re at work and should be doing something else. With Post by Email you can keep everyone up-to-date without even opening a browser.

    Post by Email is super simple to use. From the new My Blogs menu you can generate special email addresses:

    You can create as many email addresses as you


      [Read more...]
    Barry Abrahamson, talks about Wordpress.com technicals
    +0 Vote Up -0Vote Down

    While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.



    You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.

    Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables,



      [Read more...]
    Measuring the popularity of the Percona MySQL build
    +0 Vote Up -0Vote Down

    I have a Google Alert on “percona”. (And many other things — great way to keep tabs on competitors, what people are saying about you, etc.)

    I’ve been seeing increasing amounts of this type of thing:

    MySQL server version: 5.0.67-percona-3 CATEGORY QUERY: SELECT wp_term_taxonomy.count as ‘count’, wp_terms.term_id, wp_terms.name, wp_terms.slug, wp_term_taxonomy.parent, wp_term_taxonomy.description FROM wp_terms, wp_term_taxonomy WHERE …

    Go to the page in question (sorry, I won’t link it) and you don’t see “percona” anywhere on it. View the source and you do. It’s WordPress debugging output.

    I’m glad to see the anecdotal evidence of more and more active use of the

      [Read more...]
    Picasa Web: Sharing pictures, in particular for blogs
    Employee +0 Vote Up -0Vote Down

    Yesterday, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and this time, it’s Google’s picture sharing site Picasa Web.

    My starting point is the same: “Everyone else” among colleagues and friends was there long before me, and I feel like a latecomer. I want to go in, do what seems to be the right thing, and share the observations I had. And everything within the time constraint of not being able to do a full evaluation, as I obviously have other things to do as well.

      [Read more...]
    Three steps to stopping blog comment spam
    +0 Vote Up -0Vote Down
    This is part knowledge share, part appeal: fellow bloggers, I’d comment a lot more on your blogs (and I want to!) if I could. Please, make it easy for me to comment — don’t make me log in (I won’t do it) or moderate me. I’ve found a solution that works really well [...]
    RSS Feed has been fixed
    +0 Vote Up -0Vote Down

    Because of some weird bug my RSS feeds were broken ever since I’ve upgraded to WP 2.5. Today they were fixed and I hope they’ll have some new posts there soon Stay tuned.

    mod_auth_mysql patched to work with phpass
    +0 Vote Up -0Vote Down

    Do you use mod_auth_mysql, the Apache module that allows authentication of users to happen through a MySQL database?

    If so, the nice folk at Automattic (makers of fine blogging software like Wordpress) have released a patched version that works with phpass.

    With this, you can now have single sign on (SSO), with authentication against a WordPress blog (or bbPress forum). Note that WordPress (in 2.5 and later), doesn’t use MD5 hashes to store passwords any longer; instead they are salted and hashed with the phpass library. The Automattic folk use this to provide SSO for Trac and Subversion.

    Read

      [Read more...]
    I moved this blog to pairLite with zero downtime, and it was easy
    +0 Vote Up -0Vote Down

    Did you notice that I moved this blog from pair Networks to pairLite hosting?

    Probably not, unless you check the DNS of xaprb.com regularly!

    Don’t you hate it when people say “I’m moving my blog, I hope there won’t be more than a few days of downtime, blah blah…” Why is this ever necessary, I wonder? I wonder the same thing about a lot of hosting providers — recently I had a client in my consulting practice whose (very large, well-known) hosting provider tried to help them with some very simple MySQL work and ended up causing them an obscene amount of downtime, like many many days, and there was no end in sight. As I spoke on the phone with him and asked him about his

      [Read more...]
    Introducing wordpress-scripts 0.1 (0.2 out)
    +0 Vote Up -0Vote Down

    Update: I’ve been suffering some ungly and stupid bugs today, so I’ve fixed them and released version 0.2. It also includes a new script wp-update-home.


    I’ve just published some scripts that help me manage my personal wordpress installations, and publish some plugins I’m working on.

    Warning: these are early versions which I use for small tasks. If you find
    a bug or have suggestions, contact me at jbernal@warp.es

    Download version 0.1



      [Read more...]
    How to install and maintain multiple WordPress blogs easily
    +0 Vote Up -0Vote Down

    My wife has a site that needs two WordPress blog installations. The URLs differ by a subdirectory name. Both blogs need to be (URL-wise) subdirectories of /blog/. They need to be completely independent of each other, yet use the same custom theme. And there used to be just a single blog, which was not in a subdirectory; its permalinks must not break. (It has nice URLs with the date and title in them, not post ID-style URLs). And because I’m the husband, I get to maintain it, so tack “easy to maintain” onto the requirements (it must be easy to upgrade WP in both blogs, for example). In this article I’ll show you how I did it with a single .htaccess file, a single copy of WordPress, two MySQL databases, and a single configuration file.

    Fixing URLs

    As I mentioned, there used to be a blog at

      [Read more...]
    WordCamp Melbourne: making money with Wordpress, bbPress, caching, Wordpress Sandbox
    +0 Vote Up -0Vote Down

    On November 17 2007, I went to the inaugural WordCamp Melbourne. It was a truly interesting event - crowded, filled to the brim, and held at the pretty amazing Watermark Bar, in Docklands. It was a really warm day, and the only complaint would be that Watermark put is in a glass dome, with only 2 fans and no air-conditioning - nice, greenhouse we were in! Food and drink were good, as were the talks in general. I took some notes, and am placing them online now (late, but better than never). Note that the event was sold out - so kudos to James Farmer for organising it.

    Making money with Wordpress - Darren Rowse

    - exclusive content, for a paid area (like forums?)
    -

      [Read more...]
    $5,701,201 worth of eZ publish code?
    +0 Vote Up -0Vote Down

    I just ran David Wheeler’s SLOCCount tool on a copy of eZ publish 3.7.3.

    SLOCCount is:

    a set of tools for counting physical Source Lines of Code (SLOC) in a large number of languages of a potentially large set of programs.

    –from http://www.dwheeler.com/sloccount/

    The tool generated a bunch of interesting stats, including an estimated cost to develop the eZ publish codebase: $5,701,201 USD.

    Of course, it is always good to take stats with a grain of salt - as the saying goes, “There are lies, damn lies and statistics.” These stats would be most interesting if we could compare the output of SLOCCount with records of what we

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 60

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.