Showing entries 36916 to 36925 of 44814
« 10 Newer Entries | 10 Older Entries »
Cool Stack 1.1.1 contents

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

  • Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  • PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
  • APC 3.0.14
  • Suhosin 0.9.20
  • MySQL 5.0.45: Add SMF support
  • Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
  • memcached 1.2.2
  • squid 2.6
  • tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

MySQL Master Class after HighLoad.RU

26th of September, just after HighLoad conference I will have full day MySQL master class.

This time we will talk about Innodb Architecture and Performance Optimization and when will discuss some MySQL Performance Optimization and Scaling case studies from audience (or some of from my MySQL Consulting Practice if there would not be enough of them). As usually I'll try to keep it very interactive and will try to answer any other MySQL Performance, Scaling and High Availability questions you might have.

Entry posted by peter | 3 comments

Add to: …

[Read more]
Possible optimization for sort_merge and UNION ORDER BY LIMIT

Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values which would allow MySQL to still use second portion of the index for the order by. Ranges as well as IN lists make this optimization impossible, not even speaking about index merge optimization. Lets look at this example:

PLAIN TEXT SQL:

  1. CREATE TABLE `utest` (
  2.   `c1` int(10) UNSIGNED NOT NULL,
  3.   `c2` int(10) UNSIGNED NOT NULL,
  4.   `ord` int(10) UNSIGNED NOT NULL,
  5.   KEY `c1` (`c1`,`ord`),
  6.   KEY `c2` (`c2`,`ord`)
  7. ) ENGINE=MyISAM DEFAULT CHARSET=latin1
  8.  
  9. mysql> EXPLAIN SELECT * FROM utest WHERE c1=5 OR c2=5 ORDER BY ord DESC LIMIT 10 \G
  10. *************************** 1. row ***************************
  11.           …
[Read more]
Safely change firewall rules remotely

(whoops - Movable Type 4 decided to mess up the permalink from the index page on this entry earlier; it should be fixed now. Darn bugs in run-periodic-tasks, grrh).

One of the NTP Pool server operators emailed recently and told that his server was unavailable for a few hours because he had changed some firewall rules remotely and managed to lock everyone out. Oops!

There's an easy way to do safe remote firewall changes.

He should have used the at daemon to automatically recover! If you don't have a console server then you absolutely must get in the habit of using it before doing anything that can lock you out of your server.

The basic concept is to setup something that in say 5 minutes will undo whatever you're about to do. So if you are messing with the …

[Read more]
Cool Stack 1.1.1 contents

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

  • Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  • PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
  • APC 3.0.14
  • Suhosin 0.9.20
  • MySQL 5.0.45: Add SMF support
  • Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
  • memcached 1.2.2
  • squid 2.6
  • tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

Cool Stack 1.1.1 contents

We are currently working on Cool Stack 1.1.1 which will have the following components updated, in addition to fixing known bugs :

  • Apache 2.2.6 : Add mod_proxy, mod_fcgid, SMF support
  • PHP 5.2.4      : Add dtrace extension, add new fastcgi version for use with non-Apache webservers
  • APC 3.0.14
  • Suhosin 0.9.20
  • MySQL 5.0.45: Add SMF support
  • Perl 5.8.8       : Add Sys:Syslog, DBI, DBD-mysql extensions
  • memcached 1.2.2
  • squid 2.6
  • tomcat 5.5.23

I would love to get feedback on this. Is your favorite module/extension missing ? Are there bugs/issues you have run into that haven't been reported on the forum ?

Zimbra acquired by Yahoo! - congratulations, and hope they don?t kill it

Its exciting to see Zimbra being purchased for USD$350 million, by Yahoo!. Exciting because its a great product, exciting because I use it daily, and I guess Satish & team (of over 100 employees) deserve a big pat on the back. The other exciting thing to note is that its got MySQL in its core, and if they’re pushing it out farther and wider now thanks to the Yahoo! purchase, all the better.

There are a few things that are unclear, though, even from their FAQ:

  • They mention commitment to Zimbra 5, but I’m still waiting for 4.5.7 :P (My Series 60 phone still …
[Read more]
Using MySQL with PDO

PDO is a PHP extension providing a data-access abstraction layer that can be used with a variety of databases. This gives you the flexibility of changing the database backend without having to alter your access methods. Even if you use MySQL exclusively, PDO can provide advantages; you can use the same data-access methods regardless of the MySQL version. This does away with the need for using the standard MySQL extension with older versions of MySQL and using the MySQLi extension for later versions. An additional advantage is the ability to use object-oriented code regardless of the version of MySQL.

How MySQL Treats Security Vulnerabilities

The phrase "security vulnerability" gives most of us the creeps. We are afraid of them. Looking at them rationally, they share a trait with other bugs: All are a pain, but some are a bigger pain than others. And instead of trying to avoid the evil by not talking about it, let's take a look at MySQL's security vulnerability track record over the years, and explain the rationale behind our actions using actual cases from past years.

A Primer on Falcon Tablespaces

The Falcon transactional storage engine uses the concept of user-defined tablespaces that are more in line with what one would find in Oracle (tablespaces) or SQL Server (filegroups). Let?s take a quick look at how tablespaces are used within Falcon and what you can and can?t do with them.

Showing entries 36916 to 36925 of 44814
« 10 Newer Entries | 10 Older Entries »