Virtual Currency is currency, which is used inside games,
websites, applications, etc. It can be bought and traded and in
many cases has a conversion to real currency. For instance
Facebook Credits, this is virtual currency and each credit is
worth 10 cents.
A common problem I run into when building Currency Sinks or earns
is; what part of the application gave out the currency and why?
Some techniques I used to manage this problem are to create a
constants file of a bunch of action ids and used the constants
wherever the application writes updates to the balance.
This causes a problem. Developers will just reuse the same id for
very distinct reasons. When debugging situations I have to trace
through a bunch of code.
Additionally problems can arise on deploy, because the use of
currency change maybe pushed out yet the constants file is not.
This causes data issues and or even preventable exceptions
disrupting the customer …
Reading yesterday that the NSA has submitted a proposal to Apache to incubate their Accumulo platform. This, according to the description, is a key/value store built over Hadoop which appears to provide similar function to HBase except it provides “cell level access labels” to allow fine grained access control. This is something you would expect as a requirement for many applications built at government agencies like the NSA. But this also is very important for organizations in health care and law enforcement etc where strict control is required to large volumes of privacy sensitive data.
An interesting part of this is how it highlights the acceptance of Hadoop. Hadoop is no longer just a new technology scratching at the …
[Read more]It has been quite a while since the last release, but we’ve been quite busy. One of the reasons was that we were required to make a relatively major core change in the Workbench codebase, which unfortunately did not add anything new from a user’s point of view. There’s potential for new bugs having been introduced by that, and while the program has been undergoing testing for a while, it’s possible there are more bugs in the hiding.
Because of that, we are releasing test binaries for trial by the community. If no regressions are found, this will be the the next version to be released and the foundation for what will be the next major release, which will contain exciting changes that we know many people have been expecting since some time.
Additionally, 44 bugs have been fixed so far in this release.
If you find a bug, please …
[Read more]
If you missed the MySQL Community Reception in Santa Clara in
April, here is another opportunity to mingle and have
fun!
Come celebrate the growth of the MySQL community with Oracle's
MySQL team in San Francisco, CA on October 4, Tuesday. Although
the event is held in conjunction with Oracle OpenWorld, no conference registration is
required; everyone is invited to the MySQL Community
Reception. If you're attending the sessions in the MySQL Track at Oracle OpenWorld, the reception
is conveniently located in Marriott Marquis where all the MySQL
sessions will be held, so you definitely shouldn't miss …
If you missed the MySQL Community Reception in Santa Clara in
April, here is another opportunity to mingle and have
fun!
Come celebrate the growth of the MySQL community with Oracle's
MySQL team in San Francisco, CA on October 4, Tuesday. Although
the event is held in conjunction with Oracle OpenWorld, no conference registration is
required; everyone is invited to the MySQL Community
Reception. If you're attending the sessions in the MySQL Track at Oracle OpenWorld, the reception
is conveniently located in Marriott Marquis where all the MySQL
sessions will be held, so you definitely shouldn't miss …
HP builds Cloud Services on OpenStack. Linux on Github. And more.
# HP announced the private beta program of its OpenStack-based HP Cloud Services.
# Linus Torvalds made Linux 3.1 available on Github, albeit temporarily.
# The National Security Agency proposed a new database, Accumulo, to the Apache Foundation for incubation.
# Nominations for the Document Foundation board elections are now …
[Read more]Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits. Percona Toolkit is available for immediate download at percona.com/downloads/percona-toolkit/.
Helpful links:
[Read more]
MySQL database offers seven syntaxes for proper maintaining of
mysql table's records. Those syntaxes are as follows:
- Repair table syntax
- Analyze table syntax
- Backup table syntax
- Check table syntax
- Checksum table syntax
- Optimize table syntax
- Restore table syntax
In this article, we will discuss briefly about first syntax that
is Repair Table syntax.
REPAIR Table Syntax: It repairs corrupted mysql database
tables. A table gets corrupt due to several reasons like virus
attack, system failure, power failure, hardware problem, power
failure and so on. Corrupt mysql database tables can be repair by
this syntax.
Systax for Repair Table:
“REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE
…
Thanks for correcting it. It’s host_cache_size.
The latest Percona Server release has one new feature: now MEMORY tables can have BLOB and TEXT columns, and VARCHAR columns will not waste space due to implicit extension to CHAR.
The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of the long-standing limitations caused by the fact that variable-length records were not supported by the engine. This is true for all MySQL versions, including the latest 5.6 development tree as of last week.
There have been efforts in the community to remove this limitation. In 2008 Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the BLOB and TEXT support, it refactored the code to make it easier to add it. The code was proposed for …
[Read more]