Mer 31 Lug 2013     

Rilasciata nuova versione del database MySQL 5.6.13

 
Mer 29 Mag 2013     

WordPress festeggia 10 anni dal suo primo rilascio

All around the globe today, people are celebrating the 10th anniversary of the first WordPress release, affectionately known as #wp10. Watching the feed of photos, tweets, and posts from Auckland to Zambia is incredible; from first-time bloggers to successful WordPress-based business owners, people are coming out in droves to raise a glass and share the "holiday" with their local communities. With hundreds of parties going on today, it's more visible than ever just how popular WordPress has become.

La prima versione di WordPress, popolare CMS scritto in PHP che usa MySQL come database e rilasciato sotto licenza GPL, fu rilasciata il 27 maggio 2003 dai fondatori Matt Mullenweg e Mike Little.

 
Mer 29 Mag 2013     

Rilasciata la versione beta di Fedora 19.

The Beta release is the last important milestone before the release of Fedora 19. Only critical bug fixes will be pushed as updates, leading up to the general release of Fedora 19.

Here's a peek at some of our new tools:

  • 3D modelling and printing are enabled through a variety of tools, including OpenSCAD, Skeinforge, SFACT, Printrun, and RepetierHost.
  • OpenShift Origin makes it easy for you to build your own Platform-as-a-Service (PaaS) infrastructure, allowing you to enable others to easily develop and deploy software.
  • node.js is a popular Javascript-based platform for those building scalable network applications or real-time apps across distributed devices.
  • Ruby 2.0.0. Also included: a custom Ruby loader for easy switching of interpreters.
  • MariaDB, a community-developed fork of MySQL, is the default implementation of MySQL in Fedora 19, offering users a truly open MySQL implementation.
GNOME 3.8, KDE Plasma Workspaces 4.10, MATE Desktop 1.6.

Download a partire da questa pagina.

 
Mer 10 Ott 2012     

Rilasciata la versione 3.5.3 di phpMyAdmin software freeware scritto in PHP che consente di amministrare Database MySQL sul web

- [interface] Browse mode "Show" button gives blank page if no results anymore
- [interface] Copy Database Ajax feedback vanishes long before copying is done
- [interface] GC-maxlifetime warning incorrectly displayed
- [interface] Search fails with JS error when tooltips disabled
- [interface] Event comments not saved
- [edit] Can't enter date directly when editing inline
- [interface] Inline query editor doesn't work from search results
- [edit] BLOB download no longer works
- [config] Error in generated configuration arrray
- [GUI] Invalid HTML code in multi submits confirmation form
- [interface] Designer sometimes places tables on the top menu
- [core] Call to undefined function __() when config file has wrong permissions
- [edit] Error searching table with many fields
- [edit] Cannot copy a DB with table and views
- [privileges] Incorrect updating of the list of users
- [edit] cell edit date field with empty date fills in current date
- [edit] current_date from function drop down fails on update
- add support for Solaris and FreeBSD system load and memory display in server status

Changelog a questa pagina.

 
Lun 06 Ago 2012     

Oracle ha rilasciato una nuova versione del suo RDBMS MySQL

MySQL 5.5.27 is a new version of the 5.5 production release ofthe world's most popular open source database. MySQL 5.5.27 is recommended for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL Database, taking advantage of the latest multi-CPU and multi-core hardware and operating systems. In addition, with release 5.5, InnoDB is now the default storage engine for the MySQL Database, delivering ACID transactions, referential integrity and crash recovery by default.

MySQL 5.5 also provides a number of additional enhancements including:
  • Significantly improved performance on Windows, with various Windows specific features and improvements
  • Higher availability, with new semi-synchronous replication and Replication Heart Beat
  • Improved usability, with Improved index and table partitioning, SIGNAL/RESIGNAL support and enhanced diagnostics, including a new Performance Schema monitoring capability.
Functionality Added or Changed:

Important Change: The YEAR(2) data type is now deprecated because it is problematic. Support for YEAR(2) will be removed in a future release of MySQL. For more information, see YEAR(2) Limitations and Migrating to YEAR(4) (http://dev.mysql.com/doc/refman/5.5/en/migrating-to-year4.html).

Bugs Fixed:
  • InnoDB: An assertion could be raised if an InnoDB table was moved to a different database using ALTER TABLE ... RENAME while the database was being dropped by DROP DATABASE. (Bug #13982017)
  • Sessions could end up deadlocked when executing a combination of SELECT, DROP TABLE, KILL, and SHOW ENGINE INNODB STATUS. (Bug #60682, Bug #12636001)
 
Mer 22 Feb 2012     

Annunciato il rilascio di MySQL 5.5.21, nuova versione del RDMBS (Relational Database Management System) open source

MySQL 5.5.21 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.21 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL Database, taking advantage of the latest multi-CPU and multi-core hardware and operating systems. In addition, with release 5.5, InnoDB is now the default storage engine for the MySQL Database, delivering ACID transactions, referential integrity and crash recovery by default.

Functionality Added or Changed

A new CMake option, MYSQL_PROJECT_NAME, can be set on Windows or Mac OS X to be used in the project name. (Bug #13551687)

Bugs Fixed

Performance: InnoDB Storage Engine: Memory allocation for InnoDB tables was reorganized to reduce the memory overhead for large numbers of tables or partitions, avoiding situations where the "resident set size" could grow regardless of FLUSH TABLES statements. The problem was most evident for tables with large row size. Some of the memory that was formerly allocated for every open table is now allocated only when the table is modified for the first time. (Bug #11764622, Bug #57480)

Incompatible Change: An earlier change (in MySQL 5.1.62 and 5.5.21) was found to modify date-handling behavior in General Availability-status series (MySQL 5.1 and 5.5). This change has been reverted.

The change was that several functions became more strict when passed a DATE() function value as their argument, thus they rejected incomplete dates with a day part of zero. These functions were affected: CONVERT_TZ(), DATE_ADD(), DATE_SUB(), DAYOFYEAR(), LAST_DAY(), TIMESTAMPDIFF(), TO_DAYS(), TO_SECONDS(), WEEK(), WEEKDAY(), WEEKOFYEAR(), YEARWEEK(). The previous behavior has been restored. (Bug #13458237)

InnoDB Storage Engine: A Valgrind error was fixed in the function os_aio_init(). (Bug #13612811)

InnoDB Storage Engine: The server could crash when creating an InnoDB temporary table under Linux, if the $TMPDIR setting points to a tmpfs filesystem and innodb_use_native_aio is enabled, as it is by default in MySQL 5.5.4 and higher. The entry in the error log looked like:

101123 2:10:59 InnoDB: Operating system error number 22 in a file operation.
InnoDB: Error number 22 means 'Invalid argument'.
The crash occurred because asynchronous I/O is not supported on tmpfs in some Linux kernel versions. The workaround was to turn off the innodb_use_native_aio setting or use a different temporary directory. The fix causes InnoDB to turn off the innodb_use_native_aio setting automatically if it detects that the temporary file directory does not support asynchronous I/O. (Bug #13593888, Bug #11765450, Bug #58421)

InnoDB Storage Engine: References to C preprocessor symbols and macros HAVE_purify, UNIV_INIT_MEM_TO_ZERO, and UNIV_SET_MEM_TO_ZERO were removed from the InnoDB source code. They were only used in debug builds instrumented for Valgrind. They are replaced by calls to the UNIV_MEM_INVALID() macro. (Bug #13418934)

InnoDB Storage Engine: The MySQL server could halt with an assertion error:

InnoDB: Failing assertion: page_get_n_recs(page) > 1
Subsequent restarts could fail with the same error. The error occurred during a purge operation involving the InnoDB change buffer. The workaround was to set the configuration option innodb_change_buffering=inserts. (Bug #13413535, Bug #61104)

InnoDB Storage Engine: With 1024 concurrent InnoDB transactions running concurrently and the innodb_file_per_table setting enabled, a CREATE TABLE operation for an InnoDB table could fail. The .ibd file from the failed CREATE TABLE was left behind, preventing the table from being created later, after the load had dropped.

The fix adds error handling to delete the erroneous .ibd file. This error was less likely to occur in MySQL 5.5 and 5.6, because raising the number of InnoDB undo slots increased the number of simultaneous transactions needed to trigger the bug, from 1K to 128K. (Bug #12400341)

Replication: Executing mysqlbinlog with the --start-position=N option, where N was equal either to 0 or to a value greater than the length of the dump file, caused it to crash.

This issue was introduced in MySQL 5.5.18 by the fix for Bug #32228 and Bug #11747416. (Bug #13593869, Bug #64035)

Replication: On Windows replication slave hosts, STOP SLAVE took an excessive length of time to complete when the master was down. (Bug #11752315, Bug #43460)

A query that used an index on a CHAR column referenced in a BETWEEN clause could return invalid results. (Bug #13463488, Bug #63437)

Expressions that compared a BIGINT column with any non-integer constant were performed using integers rather than decimal or float values, with the result that the constant could be truncated. This could lead to any such comparison that used <, >, <=, >=, =, !=/<>, IN, or BETWEEN yielding false positive or negative results. (Bug #13463415, Bug #11758543, Bug #63502, Bug #50756)

When the optimizer performed conversion of DECIMAL values while evaluating range conditions, it could produce incorrect results. (Bug #13453382)

When running mysqldump with both the --single-transaction and --flush-logs options, the flushing of the log performed an implicit COMMIT (see Section 12.3.3, "Statements That Cause an Implicit Commit"), causing more than one transaction to be used and thus breaking consistency. (Bug #12809202, Bug #61854)

It was possible in the event of successive failures for mysqld_safe to restart quickly enough to consume excessive amounts of CPU. Now, on systems that support the sleep and date system utilities, mysqld_safe checks to see whether it has restarted more than 5 times in the current second, and if so, waits 1 second before attempting another restart. (Bug #11761530, Bug #54035)

When used with the --xml option, mysqldump --routines failed to dump any stored routines, triggers, or events. (Bug #11760384, Bug #52792)

It was possible on replication slaves where FEDERATED tables were in use to get timeouts on long-running operations, such as Error 1160 Got an error writing communication packets. The FEDERATED tables did not need to be replicated for the issue to occur. (Bug #11758931, Bug #51196)

References: See also Bug #12896628, Bug #61790.

If an attempt to initiate a statement failed, the issue could not be reported to the client because it was not prepared to receive any error messages prior to the execution of any statement. Since the user could not execute any queries, they were simply disconnected without providing a clear error.

After the fix for this issue, the client is prepared for an error as soon as it attempts to initiate a statement, so that the error can be reported prior to disconnecting the user. (Bug #11755281, Bug #47032)

Using myisamchk with the sort recover method to repair a table having fixed-width row format could cause the row pointer size to be reduced, effectively resulting in a smaller maximum data file size. (Bug #48848, Bug #11756869)

On Windows, the server incorrectly constructed the full path name of the plugin binary for INSTALL PLUGIN and CREATE FUNCTION ... SONAME. (Bug #45549, Bug #11754014)

The stored routine cache was subject to a small memory leak that over time or with many routines being used could result in out-of-memory errors. (Bug #44585, Bug #11753187)

Il changelog completo è disponibile a questa pagina. Download a partire da questa pagina.

 
Ven 17 Feb 2012     

Rilasciata la versione 3.4.10 di phpMyAdmin software freeware scritto in Php che consente di amministrare Database MySQL sul web

- [interface] TextareaAutoSelect feature broken
- [export] PHP Array export might generate invalid php code
- [import] Import from ODS ignores cell that is the same as cell before
- [display] SELECT DISTINCT displays wrong total records found
- [operations] copy table data missing SET SQL_MODE=´NO_AUTO_VALUE_ON_ZERO´
- [edit] Setting data to NULL and drop-downs
- [edit] Missing set fields and values in generated INSERT query
- [libraries] license issue with TCPDF (updated to 5.9.145)

Download da questa pagina.

 
Lun 07 Feb 2011     

Dopo 24 mesi il team di sviluppo di Debian ha annunciato il rilascio di Debian 6, nome in codice "Squeeze".

Debian 6.0 è un sistema operativo libero e per la prima volta viene fornito in due varianti. Accanto a GNU/Linux, con questa versione viene introdotta, come anteprima tecnologica, Debian GNU/kFreeBSD.

Debian funziona su dispositivi di ogni tipo, dai palmari ai supercomputer. Supporta inoltre un totale di nove architetture: 32-bit PC/Intel IA-32 (i386), 64-bit PC/Intel EM64T / x86-64 (amd64), Motorola/IBM PowerPC (powerpc), Sun/Oracle SPARC (sparc), MIPS (mips (big-endian) and mipsel (little-endian)), Intel Itanium (ia64), IBM S/390 (s390) e ARM EABI (armel).

Questo rilascio include le ultime versioni disponibili di molti software, tra i quali:

  • Aree di lavoro e applicazioni KDE Plasma 4.4.5
  • una versione aggiornata dell'ambiente desktop GNOME 2.30
  • l'ambiente desktop Xfce 4.6
  • LXDE 0.5.0
  • X.Org 7.5
  • OpenOffice.org 3.2.1
  • GIMP 2.6.11
  • Iceweasel 3.5.16 (una versione di Mozilla Firefox priva del marchio)
  • Icedove 3.0.11 (una versione di Mozilla Thunderbird priva del marchio)
  • PostgreSQL 8.4.6
  • MySQL 5.1.49
  • GNU Compiler Collection 4.4.5
  • Linux 2.6.32
  • Apache 2.2.16
  • Samba 3.5.6
  • Python 2.6.6, 2.5.5 and 3.1.3
  • Perl 5.10.1
  • PHP 5.3.3
  • Asterisk 1.6.2.9
  • Nagios 3.2.3
  • Xen Hypervisor 4.0.1 (con il supporto per dom0 e per domU)
  • OpenJDK 6b18
  • Tomcat 6.0.18
  • più di 29.000 altri pacchetti pronti per l'uso, generati a partire da circa 15.000 sorgenti.

Debian 6.0 comprende inoltre più di 10.000 nuovi pacchetti, come il browser Chromium, la suite di controllo Icinga, l'interfaccia Software Center per la gestione dei pacchetti, il gestore delle reti wicd, gli strumenti lxc per i container Linux e il framework per cluster Corosync.

Le note di rilascio sono disponibili a questa pagina. Il download è possibile da questa pagina, o direttamente da questi link
debian-6.0.0-i386-DVD-1.iso (4475 MB, torrent),
debian-6.0.0-amd64-DVD-1.iso (4446 MB, torrent).

 
Mar 04 Gen 2011     

Rilasciata la versione 3.3.9 di phpMyAdmin, software freeware scritto in Php che consente di amministrare Database MySQL sul web. Changelog a questa pagina, download da questa pagina.

 
Gio 16 Dic 2010     

Oracle ha annunciato il rilascio della versione 5.5 (5.5.8) di MySQL. Il MySQL Community Edition 5.5, che è rilasciato sotto licenza GPL (GNU General Public License), ed è disponibile per il download gratuito da questa pagina, comprende InnoDB come storage engine di default. In questa versione infatti MyISAM viene sostituito da InnoDB (sviluppato da Innobase, società controllata da Oracle) come storage engine predefinito.

MySQL 5.5 offre miglioramenti significativi permettendo agli utenti di migliorare le prestazioni e la scalabilità delle applicazioni web in più ambienti operativi, inclusi Windows, Linux, Oracle Solaris e Mac OS X.

Con il rilascio di MySQL 5.5 gli utenti trarranno beneficio da:

  • Miglioramento delle prestazioni e scalabilità: MySQL database e lo storage engine InnoDB sono stati migliorati per offrire prestazioni ottimali e scalabilità quando sono in esecuzione sul più recente hardware e software disponibile (CPU multi-core e ultimi sistemi operativi disponibili). Inoltre, con questa versione InnoDB è ora lo storage engine predefinito per il database MySQL, offrendo transazioni ACID, l'integrità referenziale e crash recovery.
  • Maggiore disponibilità: New semi-synchronous replication e Replication Heart Beat migliorano la velocità e l'affidabilità del failover.
  • Migliorata l'usabilità: migliorati gli indici ed il partizionamento delle tabelle, supporto a SIGNAL / RESIGNAL, e la diagnostica avanzata, incluso un nuovo PERFORMANCE_SCHEMA, migliorata la gestibilità di MySQL 5.5.
Prec