Domainesia Referal
Domainesia
HOW TO MEASURE NETWORK PERFORMANCE THROUGH PASSIVE TRAFFIC ANALYSIS
Whichever tool you use it is important to understand the fundamentals of how network performance metrics(like latency, packet loss or throughput) can be calculated.This calculation can be manual with Wireshark or any other packet analyzer or automated with the NPM solution… Read more ›
Use mysqldump to get the schema only
The MySQL command line tool mysqldump is used to create backup copies (or dumps) of databases including the structure or schema and the data itself. There are a number of command line flags which can get MySQL to dump just… Read more ›
101 Tips to MySQL Tuning and Optimization
MySQL is a powerful open-source database. With more and more database driven applications, people have been pushing MySQL to its limits. Here are 101 tips for tuning and optimizing your MySQL install. Some tips are specific to the environment they… Read more ›
Smokeping
SmokePing keeps track of your network latency: Best of breed latency visualisation. Interactive graph explorer. Wide range of latency measurement plugins. Master/Slave System for distributed measurement. Highly configurable alerting system. Live Latency Charts with the most ‘interesting’ graphs. Free and… Read more ›
6 Proven Ways To Make Your Push Notifications Irresistible To Open
Push notifications are a powerful engagement strategy for app developers, hyped particularly because of their personalisation and targeting features. When used appropriately, they can bring your brand closer to users, make them more loyal and increase their frequency of app… Read more ›
What is Data Integrity? Learn How to Ensure Database Data Integrity via Checks, Tests, & Best Practices
Data integrity is a fundamental component of information security. In its broadest use, “data integrity” refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct. The term – Data Integrity –… Read more ›
Why you should use Postgres over MySQL for analytics purpose
Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL. And from our experience with both, I’d prefer our new customers to use… Read more ›
Cache Python MySQL Result using Redis
We’re often using MySQL so much, like read data from DB, calculate something, write data with index. And I bet You know, that process is also using your i/o machine. I prefer my CPU usage 100% than my i/o 50%.… Read more ›
PHP MySQL Redis
MySQL cache in PHP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
$r = new Redis(); $r->connect("127.0.0.1", "6379"); $id = (int) $_REQUEST["id"]; $sql = "select * from users where id = $id"; // Create a hash key $key = "sql_cache:" . md5($sql); // Check if data is in cache. if ($data = @unseralize( $r->get($key) ) === false){ $data = exec_db_query($sql); // Put data into cache for 1 hour $r->set($key, serialize($data) ); $r->expires($key, 3600); } display_data($data); |
Redis connection note The example uses generic connection to the Redis server. To make the example work with our service you will need to use code similar to this one:
|
1 2 3 4 5 6 7 8 9 10 |
// change these parameter according to the information in your instance list $host = '50.30.35.9'; $port = 1234; $password = 'somehashcode'; $db = 0; $r = new Redis(); $r->connect($host, $port); $r->auth($password); $r->select($db); |
Link : http://redis4you.com/code.php?id=001