|
Archived MySQL Articles
|
22 Apr 2013
|
Need More Physical Disk Space [30529]
Jeremy Smyth Has Some Suggestions
Ever find yourself with a large table (or two) in a database on a partition that's running out of space? And did you ever wonder how it might safely be moved to another drive? Jeremy Smyth's post on addresses that issue with some helpful suggestions. He first explains how MySQL stores data and then explores the options available, such as moving the whole data directory; moving just one database; or moving a single table. Smyth concludes his post with the caution that modern UNIX-like operating systems often have mandatory access control systems such as AppArmor, SELinux, or Extended Policy, so be sure to do your homework before moving files around.
(Get More Information . .)
|
|
29 Mar 2013
|
MySQL Enterprise Edition Enables ip.access to Support Mobile Traffic Growth [30347]
UK Telecom Provider Sees Advantages in High Availability, Performance and Scalability
ip.access specializes in delivering full end-to-end small cell solutions for Tier 1 and Tier 2 telecom operators around the world. The company deployed MySQL, which delivered the performance & scalability required for mobile traffic growth, and the high availability and zero administrative burden, while being a cost-effective solution fulfilling their other requirements. For installations counting up to 250K small cells, MySQL Enterprise Edition is deployed on active-standby servers. The MySQL Enterprise Monitor and Query Analyzer management tools included in the MySQL Enterprise and MySQL Cluster Carrier Grade Editions enable simple and rapid performance monitoring and tuning when needed.
(Get More Information . .)
|
|
21 Mar 2013
|
MySQL Connect 2013 Call for Papers [30252]
Call Ends April 12; Event Takes Place September 21-23 in San Francisco
Organizers of MySQL Connect 2013 have issued a call for papers, which extends until April 12, 2013. The event, September 21-23 in San Francisco, will include five tracks: Performance and Scalability, High Availability & Replication, Cloud & Big Data, Database Administration & DevOps, Architecture and Application Development. In his announcement of the call for papers, Bertrand Matthelié invites members of the MySQL Community to avail themselves of this opportunity to address not only long time MySQL users and highly experienced professionals but also newer and eager MySQL customers traditionally attending Oracle OpenWorld. Dont miss this opportunity and submit your sessions today.
(Get More Information . .)
|
|
04 Mar 2013
|
Register Now for Virtual Developer Day: MySQL (March 12 and March 19) [29982]
Enhance Your MySQL Skills in Free Two-track Program
The first two sessions of the free Virtual Developer Day: MySQL are scheduled for May 12 and May 19, 2013. The first session is for the Americas and Canada. The March 19th session is for Europe, Middle East, Africa and Some Asian Countries (English). Cassandra Clark describes the event as a " ... one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. You'll also be able to ask questions of Oracles MySQL engineering, support, product management, and sales consulting teams." The event has tracks for both fresh and experienced MySQL users. Reserve your place today.
(Get More Information . .)
|
|
02 Mar 2013
|
Locks and Killing Sessions in Oracle SQL Developer [29966]
The Answer to 'Who's Got My App Tied Up?'
Under the formidable title "Locks and Killing Sessions in Oracle SQL Developer" Jeff Smith instructs readers of his blog in how to 1) identify the activity that causes the Windows "busy" hourglass cursor to linger on their monitor screens and 2) how to "kill" the offending session. He starts on the Tools tab and selects Monitor Sessions, whose context menu allows users to initiate a trace and execute a kill. Under the Database Administration and Locks category, Smith leads readers to the Blocking Locks by User report and, from there, to the trigger pull "Kill Session." BANG! The app is all yours.
(Get More Information . .)
|
|
01 Mar 2013
|
Replication Performance Improvements in MySQL 5.6 [29978]
Reduces Risk of Losing Data When Master Fails and Improves Read Consistency from Slaves
The replication performance of MySQL 5.6 has been improved in a number of ways, Mat Keep blogs. Using MySQL replication to scale out a database across commodity nodes and as a foundation for High Availability (HA) will demonstrate performance improvements resulting from a combination of Binary Log Group Commit, multi-threaded slaves, and Optimized Row-Based Replication. Furthermore, Keep continues, higher replication performance directly translates to reduced risk of losing data in the event of a failure on the master; improved read consistency from slaves; and resource-efficient binlogs traversing the replication cluster. These improvements allow developers and DBAs to get ahead of performance demands, Keep concludes.
(Get More Information . .)
|
|
|
|
|
