From the recent MySQL Conference a number of things resonate
strongly almost daily with me. These included:
Check the forum announcement for more information installation instructions and compatibility notes.
Please report any issues and/or feedback at the Virtual Appliances Discussion Forums (forums.virtualappliances.net).
LAMP
http://virtualappliances.net/download/archive/VirtualAppliancesLAMP-xen-1.0.113.tar.bz2
http://virtualappliances.net/download/archive/VirtualAppliancesLAMP-xen-1.0.113.zip
Cacti
…
[Read more]For the mysql-proxy I'm exploring several ways to write a small SQL parser for the internal commands. As I want to use basic SQL to modify the config and the internal operations I need a parser. Some time ago I used lemon which is used in sqlite3, which is easier to use than yacc, but you still have to write the lexer/tokenizer.
This time I looked into ragel which is a state-machine compiler.
Time get rid of code like this:
....
} else if (0 == g_ascii_strncasecmp(s->str + NET_HEADER_SIZE + 1,
C("update proxy_config set value=0 where option=\"proxy.profiling\""))) {
....
Ragel is a bit different than lex/yacc. Ragel combines the two into one and builds a full state-machine for the input stream. Just one file, one state-machine for the parser and lexer.
%%{
machine sql;
SELECT = /SELECT/i;
FROM = …So I came across Google Patents the other day and thought that it was a pretty cool idea! Searching for whether a patent already exists had been a pretty hard job in the past, so having a readily available resource such as Google is a fantastic step forwards.
Especially in light of the recent Microsoft ‘FUD’.
Here’s a patent I came across whilst browsing around the various database related patents that exist out there:
http://www.google.com/patents?id=zLsYAAAAEBAJ&dq
Electronic shopping and merchandising system
Abstract
The present invention provides a merchant system for online
shopping and merchandising. The merchant system architecture
provides great flexibility for a merchant to adapt the merchant
system to their …
Today, I noticed that one of my machines was giving a negative
number for threads connected.
Anyone care to share why the threads would be displayed as a
negative number in mysqladmin ex output:
| Aborted_connects | 0 |
| Connections | 186 |
| Max_used_connections | 0 |
| Threads_connected | -31 |
| Aborted_connects | 0 |
I grew up on a farm. Lest anyone automatically load up their
preconceived notions of farmers, my Dad was (and is) very
interested in computers and purchased the original IBM PC back in
the early/mid 80's. He found a lot of practical use in the Lotus
1-2-3 spreadsheet program, and could fly through the keyboard
shortcuts (I guess they weren't really shortcuts in those days,
as there wasn't a mouse) fast enough to put him on the same level
with any Unix geek today with Emacs or Vi.
In the 90's, I remember him buying our 486/66
with 16MB of RAM from Micron and describing it as a computer that
would "peel out on the lawn." My dad is a tractor-guy and has
always been obsessed with horsepower. He still likes to rev up
his …
For the mysql-proxy I'm exploring several ways to write a small SQL parser for the internal commands. As I want to use basic SQL to modify the config and the internal operations I need a parser. Some time ago I used lemon which is used in sqlite3, which is easier to use than yacc, but you still have to write the lexer/tokenizer.
This time I looked into ragel which is a state-machine compiler.
Time get rid of code like this:
....
} else if (0 == g_ascii_strncasecmp(s->str + NET_HEADER_SIZE + 1,
C("update proxy_config set value=0 where option=\"proxy.profiling\""))) {
....
Ragel is a bit different than lex/yacc. Ragel combines the two into one and builds a full state-machine for the input stream. Just one file, one state-machine for the parser and lexer.
%%{
machine sql;
SELECT = /SELECT/i;
FROM = /FROM/i;
WHERE = …[Read more]
It's not new (Yahoo! Pipes is already there) but the Visual Studio integration is the kicker. Check it out: http://www.popfly.ms/Overview/
Hi,
MySQL Connector/Net 5.0.7 a new version of the all-managed .NET driver for MySQL has been released.
This is a bug fix release for the current production branch of Connector/Net.
Version 5.0.7 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon "Preview".
It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)
Bugs fixed
So if you like to try out new things, and you're not using VMWare yet, get with the program!Really, though - it's so easy now (and the VMServer is free) . Just download and install.VMWare lets you run mini virtualized server environments within your current operating system. Yea, there is a little overhead, but for testing and trying out new databases, configurations, applications, it's