Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 30.068.078 Times

MySQL Global User Variables UDF 1.0

Company: Frank DENIS
Date Added: July 05, 2013  |  Visits: 245

MySQL Global User Variables UDF

Report Broken Link
Printer Friendly Version

Product Homepage
Download (18 downloads)

MySQL Global User Variables UDF is a MySQL extension to store persistent variables.<br /><br />This shared library adds simple user functions to MySQL in order to keep persistent shared variables in memory. These variables and their values are available to all clients. Any data can be stored into these persistent variables, including BLOBs. Since updates are atomic and way faster than MEMORY tables, this is an easy and efficient way to handle counters and sequences.<br /><br />Usage:<br /><br />Storing a value<br /><br />An unlimited number of user variables can be created, as long as memory is available.<br />The GLOBAL_STORE(, ) stores a new shared global variable.<br /><br />Examples:<br /><br />mysql> DO GLOBAL_STORE("online_users", 42);<br />mysql> DO GLOBAL_STORE("secret_key", "pajfUyfnd");<br /><br />The GLOBAL_STORE() function always returns 1 unless an error occurred.<br /><br />Fetching a value<br /><br />Reading the value of a variable is the job of the GLOBAL_GET() function.<br />The value is returned, or NULL is the variable is undefined.<br /><br />Example:<br /><br />mysql> SELECT GLOBAL_GET("online_users;);<br />42<br /><br />mysql> SELECT id FROM pxs WHERE secret_key = GLOBAL_GET("secret_key");<br />1<br /><br />Atomic increments<br /><br />A single function call can read the previous value, add an integer (that can be negative), and store the new value into the variable.<br /><br />The function is GLOBAL_ADD(, ) and the return value is the new value of the variable.<br />Updates are always atomic, if the old value is 18 and you add 1, you will always get back 19.<br /><br />Example:<br /><br />mysql> DO GLOBAL_ADD("online_users", 1);<br />mysql> SELECT GLOBAL_ADD("online_users", -4);<br />39<br /><br />If the value of a variable was a string, the new value is the increment:<br /><br />mysql> SELECT GLOBAL_ADD("secret_key", 12);<br />12<br /><br />Adding a value to an undefined variable returns NULL.<br />A handy variant is GLOBAL_ADDP(, ). GLOBAL_ADDP() is similar to GLOBAL_ADD() but returns the PREVIOUS value of the variable instead of the new one.<br /><br />Example:<br /><br />mysql> DO GLOBAL_SET("xxx", 10);<br />mysql> SELECT GLOBAL_ADDP("xxx", 1);<br />10<br />mysql> SELECT GLOBAL_ADDP("xxx", 1);<br />11<br /><br />Installation:<br /><br />On m

Requirements: No special requirements
Platforms: *nix, Linux
Keyword: Atomic Global Global Getonline Users Global Getsecret Key Returned Secret Key Select Undefined
Users rating: 0/10

License: Freeware Size: 40.96 KB
Modules  -  Mail global header and footer 6.x-1.0
This module adds the possibility to set a global header and a global footer for all e-mails sent by Drupal.It is compatible with htmlmail module.
10 KB  
Finance  -  Pyramis Global Advisors Leadership Series Compendium 1.0.3
FOR INSTITUTIONAL USE ONLY Welcome to the Pyramis Global Advisors Quarterly Leadership Series eCompendium, presenting a collection of select, relevant thought leadership content. This app supports our commitment to sharing timely...
5 MB  
Network Monitors  -  LanSpy 2.0
LanSpy is a network security scanner, which allows getting different information about computer: Domain and NetBios names, MAC address, Server information, Domain and Domain controller information, Remote control, Time, Discs, Transports, Users,...
1.06 MB  
Photo & Video  -  Geo-Wiki pictures
With the Geo-wiki pictures app, you can photograph landscapes and share your photos with friends and colleagues through, a visualization and crowdsourcing tool developed by IIASA for improving global land cover maps. Global land cover...
1024 KB  
Password Recovery  -  SterJo Key Finder 1.7
During reinstalling Windows on your PC, you inevitably end up losing your installed third party software and perhaps their license keys too. Before you reinstall Windows, it is essential that you note down the license keys for all the installed...
826.38 KB  
Registry Tools  -  Win 7 Key Finder 1.0.0
Win 7 Key Finder is a free software that can find your Windows 7 Product key, compatible with all Win7 versions and supports both 32 and 64 bits. No addons, totally free. Win7 Key Finder is a completely free software that finds your windows 7...
1 MB  
Business  -  Autoneum Corporate publications 4.0.0
The Autoneum app allows users to browse and experience the Autoneum corporate documents on their iPad. The documents are reproduced in their original full-colour format and allow users to quickly and efficiently consume key corporate content...
1.1 MB  
Business  -  BAE Systems Report Library 4.0.0
The BAE Systems Report Library allows users to browse and experience the BAE Systems corporate documents on their iPad. The documents are reproduced in their original full-colour format and allow users to quickly and efficiently consume key...
1.4 MB  
Finance  -  Celesio AG Corporate publications 3.3
The Celesio AG app allows users to browse and experience the Celesio? corporate documents on their iPad. The documents are reproduced in their original full-colour format and allow users to quickly and efficiently consume key corporate content...
2.1 MB  
Business  -  Chemring Report Library 3.0.1
The Chemring app allows users to browse and experience the Chemring corporate documents on their iPad. The documents are reproduced in their original full-colour format and allow users to quickly and efficiently consume key corporate content...
921.6 KB  
Linux Software  -  Polling Autodialer Software 3.4
ICTBroadcast Auto Dialer software has a survey campaign for telephone surveys and polls. This auto dialer software automatically dials a list of numbers and asks them a set of questions that they can respond to, by using their telephone keypad....
488 B  
Linux Software  -  Total Video Converter Mac Free 3.5.5
Total Video Converter Mac Free developed by EffectMatrix Ltd is the official legal version of Total Video Converter which was a globally recognized brand since 2006. Total Video Converter Mac Free is a free but powerful all-in-one video...
17.7 MB  
Linux Software  -  Skeith mod_log_sql Analyzer 2.10beta2
Skeith is a php based front end for analyzing logs for Apache using mod_log_sql.
47.5 KB  
Linux Software  -  SLAX 6.0+
Slax is a modern, portable, small and fast Linux operating system with a modular approach and outstanding design. Despite its small size, Slax provides a wide collection of pre-installed software for daily use, including a well organized graphical...
190 KB  
Linux Software  -  GTK+ 2.5
GTK+, which stands for the GIMP Toolkit, is a library for creating graphical user interfaces for the X Window System. It is designed to be small, efficient, and flexible. GTK+ is written in C with a very object-oriented approach. Language bindings...
60 MB  
Business  -  Java SQL Admin Tool for Linux 2.4.3
This is a Java-based Admin-Tool for SQL-Databases via JDBC. It needs to have JDK 1.6 underneath In the beginnings of Java I had my first look at this exciting product. So I decided to learn more about Java. As beeing a developer for...
686.08 KB  
Business  -  DBBalancer 0.4.4
DBBalancer is some sort of middleware that would sit in between of database clients, like C, C++, TCL, Java JDBC, Perl DBI, and a database server. Currently the only server supported is Postgres, but the architecture is open to embrace more...
174.08 KB  
Business  -  Postgres Plus 9.0.4
Postgres Plus is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, GridSQL Parallel Query, MySQL...
43.06 MB  
Business  -  Insulin Buddy 1.0b
Insulin Buddy is diabetes management software. It allows for quick and painless entry of all diabetes-related data (blood blucose, carbohydrate consumption, insulin doses, etc) and provides a number of reports, charts and data exports to easily...
2.52 MB  
Business  -  Apatar Data Integration 1.12.23
Apatar is an open source Extract, Transform, and Load (ETL) project. Modular architecture delivers: 1. Visual job designer/mapping 2. Connectivity to all major data sources 3. Flexible Deployment Options (GUI, or server engine with JVM, or...
25.94 MB