Posted on 26 February 2004 by Demian Turner
I needed to do optimise some queries on a big dataset at work, so figured I’d export recent data to my windows development machine rather than tax the live servers.
Datadump: 1M rows, returned after lunch an hour later and only 70k rows had inserted 🙁
How To Optimise
By default a recent MySQL install on windows creates a my.ini file (not my.cnf) in c:/. This file is practically empty and won’t do you much good. So I overwrote it with the my-medium file supplied in the distro and altered two key values respective to the INNO DB table type I was using:
- set-variable = innodb_buffer_pool_size=256M (this represent 50% of physical RAM on my machine)
- innodb_flush_log_at_trx_commit=0 (this disables transaction logging that roughly doubles the resources required by MySQL)
Truncated the now 75k rows and reimported the data – whole million rows went in in under a minute!
nb: you may want to return to your default values after big imports, the above setting hoard a lot of RAM.
Posted on 23 February 2004 by Demian Turner
Hop over to Laurent Laberge’s site for details on his recent updates to PEAR::HTML_Progress and HTML_Progress_Monitor. There’s a detailed tutorial, code examples and downloads to get you up and running.
His site is also a great example of good design and CSS working together, iow, how not to look like yet another PHP site 😉
Posted on 20 February 2004 by Demian Turner
Wanna release your software package as an RPM? Check out this tutorial from IBM on how to do it.
Posted on 19 February 2004 by Demian Turner
Check out this highly entertaining article over at kuro5hin.org regarding the recently leaked Microsoft source code and some of the comments sifted from it.
And I thought the company was guarding trade secrets, did they purge this stuff before they licensed parts of it to the Chinese government?
Posted on 18 February 2004 by Demian Turner
From a useful comment by Harry over at Peter Bowyer’s weblog.
cvs2cl is Perl script that does what you think it does: it produces a GNU-style ChangeLog for CVS-controlled sources, by running “cvs log” and parsing the output. Duplicate log messages get unified in the Right Way.
Get the script here.
Posted on 17 February 2004 by Demian Turner
I’ve only ever heard positive things about ezPublish, which didn’t surprise me as their website looks very professional and I understand they have about 20 developers working for them – I think phpPatterns also runs that software.
From a framework point of view I downloaded the code about 6 months ago and spent a few hours browsing through it, though must admit I never installed and tested the project. From the start I noticed their class library has around 500 classes and this is not a framework niche I’m interested in.
Thanks to John’s recent post (which incidentally is quite an interesting defense of PHP) I bumped into Reverend Jim who has written an article regarding his experience with ezPublish.
Posted on 16 February 2004 by Demian Turner
Now this is interesting, you can now head over to the Gnome website and claim your bounty for developing outstanding components of their desktop suite.
Bounties up for grabs include anything from $15 for National, religious, event calendars to $2500 for Gaim/addressbook identity integration.
Posted on 15 February 2004 by Demian Turner
If you’re not signed up for the Sourceforge newsletter, you won’t have received news on the latest slew of Open Source top scorers. As well as the usual contenders a few new faces looked really interesting:
- AMSN – a MSN messenger clone that does everything you’d expect with the exception of file transfer, imagine the reverse-engineering involved
- POPFile – fantastic software, when’s the IMAP version coming out?
- TightVNC – I recently paid money for this kind of functionality, and it crashes every machine I install it one, am looking forward to trying out TightVNC
- WinMerge – couldn’t live without it, very well integrated into Tortoise CVS, check out their WinTail as well
- FCKeditor – interesting competitor to htmlArea, on my machine however it pops up an alert asking for the windows installer cd
- phpGedView – a must check out item, sent me hunting for the best software to use to build the GED files
- Webmin – a bad boy since way back, interesting there’s no equivalent in PHP
Enough waffle – here’s the list:
1. Gaim https://sourceforge.net/projects/gaim Gaim is a GTK2-based instant messenger application. It supports multiple protocols via modules, including AIM, ICQ, Yahoo!, MSN, Jabber, IRC, Napster, Gadu-Gadu and Zephyr. It has many common features found in other clients, as well as many unique features.
2. guliverkli https://sourceforge.net/projects/guliverkli Home of VobSub, Media Player Classic (MPC) and other miscellaneous utilities.
3. BZFlag – Multiplayer 3D Tank Game https://sourceforge.net/projects/bzflag Open Source OpenGL Multiplayer Multiplatform Battle Zone capture the Flag. 3D first person Tank Simulation.
4. Azureus – BitTorrent Client https://sourceforge.net/projects/azureus A Java Based BitTorrent Client.
5. AWStats https://sourceforge.net/projects/awstats AWStats is a free powerful and featureful server logfile analyzer that shows you all your Web/Mail/FTP statistics including visits, unique visitors, pages, hits, rush hours, OS, browsers, search engines, keywords, robots visits, broken links and more…
Posted on 11 February 2004 by Demian Turner
Wow – wget for windows, now that’ll come in handy 😉 There’s some useful command line switches in this article for mirroring websites and ftp directories.
Posted on 08 February 2004 by Demian Turner
I was amazed the other day to find our Seagull project has already been forked, or at least so it appears except that I can’t speak German and so can only guess.
Searching for seagull at SF now brings up two results, so let’s take a look at the new derivative, somewhat nondescriptly named webcms or just ibzswgsn if you go to the project page. I’d like to mention briefly here how the SF guys hassled me because I was submitting ‘yet another cms’, which I can understand as this is a very crowded space at the moment – I wonder what their reaction was to webcms?
I guess this is kind of a compliment although the timing seems curious as most Seagull users will tell you the code is still very much in development and undergoing frequent changes.
The thing that impressed me is that the webcms project has 13 listed members and none of them look familiar to me from the seagull lists. They also have probably better documentation than us, or at least they have powerpoint slides which I could only wish for!
So here’s the question, especially posed to those of you fluent in German – is this an exciting project, do these guys have better social/organisational skills than us? Why did they never contact us or show any interest in cooperating rather than forking the project?