The PHP development team would like to announce the immediate availability of PHP 4.4.6. The main issue that this release addresses is a crash problem that was introduced in PHP 4.4.5. The problem occurs when session variables are used while register_globals is enabled. Details about the PHP 4.4.6 release can be found in the release announcement for 4.4.6, the full list of changes is available in the ChangeLog for PHP 4.
MySQL AB, developer of the world’s most popular open source database, has added TRUMPF Laser GmbH + Co. KG as a customer for the embedded version of its database. TRUMPF has selected MySQL to control the pulsating solid-state laser in its TruPulse series of welding tools.
Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, not tuned by expert you often can get significant performance increase in the matter of hours further performance improvements become more and more time consuming and expensive and gains smaller.
This observation does not only apply to MySQL but to systems running other databases or no database at all as well.
So how does System size come in play here ? Well it is system size and scale what may define how much performance you need to squeeze out, and also how your scaling is set up.
For smaller systems lets say running couple of MySQL servers running another couple can be cheaper than serious application changes and this can be good way to go if you’re not expecting major growth.
This however implies two things - first you can scale system by adding more servers, because scaling up and purchasing more and more powerful servers will not tall you far, especially as MySQL Server may have trouble scaling itself. The second thing - it should be throughput rather than latency problems - for example if your search is taking 10 seconds for the single user on idle seconds you need to fix it and simply adding more boxes may not be enough.
The growth expectation is always interesting trade off. Working with startups We often ask them if they would like me to help them to design architecture which is very easy to implement or which would be efficient and scalable ? Typically we settle on some balance but it does not change the fact - scalable architectures may be more complex to implement. This of course does not mean all simple architectures scale badly - for many tasks simple architectures can be good enough, but it should be right simple architectures. In some cases you might wish to implement simple architecture which you’ll have to redo in the 6 months - just to show proof of concept, see first happy customers and raise investment or fell assured this project is worth to spend savings on. In others you prefer to do things as good as you can from the start. I’m not saying “right” as experience gained during the project development and new features typically require some changes.
If system will be huge from the start, like if Yahoo develops new service and will link it from the front page, or if it is expected to grow quickly it is worth to spend time and money implementing things as optimal as possible. If you’re using 50 5000$ database servers to run the system even 10% performance increase mean 25K$ savings in hardware cost alone not to mention rack space cost, power cost, staff costs and other components of TCO. If you’re MySQL Customer you can also save on support and possibly Enterprise Subscription by keeping number of servers low.
How do we approach it in our practice ? We figure out application size and ask about expected growth, to help to access if minor face lifting such as MySQL Server settings tuning, changing indexes and queries is enough to deliver performance required in cost efficient way, or if we should do some more complex things such as major schema changes and architecture overhaul, adding/changing caching infrastructure and other things.
Of course it is not black and white, typically there are many alternatives and we typically can offer list of items which can be done to the system together with implementation complexity and expected performance impact.
If you use the wrong search engine optimization techniques then Google won’t list your web site. Read this article to learn how to avoid getting caught be Google’s spam filters.
No product can satisfy all developers out of the box. SQL Server Reporting Services is no exception. But you can extend the SSRS expression system with .NET code.
No product can satisfy all developers out of the box. SQL Server Reporting Services is no exception. But you can extend the SSRS expression system with .NET code.
JasperSoft Corporation and MySQL AB today announced the availability of Jasper for MySQL: OEM Edition, a suite of operational reporting products that includes a high-performance interactive report server, a graphical report creation tool, and a pixel-perfect reporting system with dashboards, tables, crosstabs and charts.
We often recommend to our clients to convert their current database from MyISAM tables to InnoDB.
The transfer by itself in most cases is almost plain, however the application can be broken by new unexpected errors
1205 (ER_LOCK_WAIT_TIMEOUT)
Lock wait timeout expired. Transaction was rolled back.
1213 (ER_LOCK_DEADLOCK)
Transaction deadlock. You should rerun the transaction.
It is not hard to handle these errors, but you should be aware of.
This is some thing we do in our PHP applications:
You may want to handle ER_LOCK_WAIT_TIMEOUT in different way, especially for web applications where long waiting is not good, you get the idea.
Also there is script we are using for converting databases with many tables, maybe it will be useful for you
There is the standard script mysql_convert_table_format in the MySQL distribution, but it requires Perl and DBI package and sometimes they are absent on used server.
A couple of days ago, tempting fate, I mentioned that our chargeback rate was 0%.
Some people speculated that I was rounding, and really meant, say, 0.45%.
Nope, I really meant zero. None.
As soon as I wrote this, some wise guy decided to dispute a charge.
Now, a long time ago, I wrote some custom software to screen-scrape our credit card processor”s online information system, and reconciles the transactions it finds there with QuickBooks, where we do the rest of our bookkeeping.
So today, for the first time in the history of that app running, it finds a chargeback on the statement, and doesn”t know what to do with it. So it stops and says, “Unrecognized entry: I don”t know what account VISA CHARGEBACK should be posted to.”
We had to modify the software.
And that”s how I know we”ve never had a chargeback… until today!
Not loving your job? Visit the Joel on Software Job Board: Great software jobs, great people.
I thought I’d done this when Bill was kind enough to tag me, but I just found this post tucked away in my “drafts” folder… I know this is well beyond the life of the original meme, but I went through the trouble of writing it, so here are five things you probably don’t know about me:
I think this meme is so dead, there’s no point in tagging anyone. Besides, who’s left that hasn’t done it?
