Many strategies exist for increasing the performance of a MySQL database. Some attempt to make each access to the data faster: for example, faster hardware may be used, or system settings may be tweaked. Other approaches attempt to decrease the total number of database operations: for example, by caching database …
10M events per second into HDFS, Under a sec query per 20GB of HDFS data… All of this and more will be demonstrated live during this presentation that explores the area of real-time data ingest into Hadoop.
Just about anyone can write a basic SQL query for a table. Not everyone can write a *good* query though – that takes practice and knowing how to understand what the optimizer is doing with the query. Oracle ACE Director for MySQL Sheeri Cabral will teach the basics of query …
Demonstration of generating Oracle trace files and then turning these into tuning reports with the tkprof utility.
Paul Berry, Chief Technical Officer of the HuffingtonPost presenting strategies for survival under high-traffic on a MySQL database along with Jim Bartus, HuffingtonPost Lead System Administrator.
There’s little that’s more important than protecting your database and the data/information within it. The most common form of “attack” comes from SQL injection and, even though monitoring systems vendors as well as your company’s IT staff are highly aware of how critical it is to protect your database from …
