Posts

Showing posts with the label MySQL

MySQL UPDATE DELAYED - Just My Solution

The Problem MySQL supports DELAYED option as INSERT statement but, for some obscure reason nobody got so far, it does not support UPDATE DELAYED or DELETE DELAYED. Why DELAYED Is Necessary As quick summary, INSERT DELAYED is something truly useful when we would like to let MySQL decide when it is time to perform that insert without blocking tables and users. This is a problem almost specific for engines like MyISAM, MEMORY, ARCHIVE, and BLACKHOLE. This post is not about " why not InnoDB ", this is about DELAYED with these engines, specially with MyISAM one. To better understand a common case where an UPDATE DELAYED could be extremely useful, just think about a counter, how many users visited that id. Is such information that useful to be not approximated and to possibly block every other select because of an update that nobody will verify with a microscope? In my opinion, such information is "just a plus" and if the page execution could be faster without blocking...

PAMPA-J calls for tests

More downloads, and as usual more problems caused by different configurations. I would like to leave a single official 1.0 release in Google Code PAMPA-J Project page but I need your tests to do this. Test I would like to perform with your configurations: PAMPA starts (default configuration: Apache, MySQL, PHP, Jaxer) PAMPA works from every folder (Desktop, Documents, others) PAMPA closes processes on stop and/or exit PAMPA works from network as well (old version could be launched from another PC without problems and respecting paths) All above tests passed without problems for me, but I would like to be sure it works properly in other environments. Would you help me? Cheers :-)

PAMPA 1.0 - Jaxer included!

Update - Windows Home Fixed! Version 1.0b contains hot fixes for Window$ Home Edition plus some little change to make PAMPA more robust than before during process managment. If you already downloaded version 1.0 you can download only the Tray executable and rename it as PAMPA.exe Please tell me if you have still problems, hoping this b version will be the final 'till 1.1 ;-) Update Final Version 1.0 now served via Google Code ;-) I am proud to announce the first Release Candidate final 1.0 release of my tiny precious PAMPA , jumped from version 0.7 to 1.0 and rewrote from the scratch considering every suggestion its users gave me during these years (project born in 2006 and completely revisited for version 1.0) What is PAMPA-J PAMPA means P ortable A pache, M ySQL, and P HP A pplication, in this release with Aptana Jaxer included ! (shell I consider PAMPA-J a portable Aptana Cloud ?) What does it mean: Portable PAMPA is the first customizable and portable WAMP environment that...