1 / 4

MySQL vs Hypertable

MySQL vs Hypertable. Giovannini Loris. SPES Control System Group. 11 Marzo 2010. Archiver MySQL. Computer used for development and implementation of Archiver: Intel Core 2 CPU 2.80Ghz with 2GB RAM, Fedora Release 11 (Leonidas) Services running for the data storage of PV

julianna-larya
Download Presentation

MySQL vs Hypertable

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MySQL vs Hypertable Giovannini Loris SPES Control System Group 11 Marzo 2010

  2. Archiver MySQL • Computer used for development and implementation of Archiver: • Intel Core 2 CPU 2.80Ghz with 2GB RAM, Fedora Release 11 (Leonidas) • Services running for the data storage of PV • ArchiveEngine: Start at 23-02-2010 and restart 10-03-2010 • AlarmServer: Start at 23-02-2010 today enabled • LogServer: Start at 23-02-2010 today enabled • ActiveMq: Start at 23-02-2010 today enabled • Mysqld: Start at 23-02-2010 today enabled CPU Average Usage: 50% when you don't execute query. It's necessary a new PCNetwork History : very low with hit of 2.0KiB/s Giovannini Loris SPES Control System Group 11 Marzo 2010

  3. Archiver MySQL Actual Data Length into MySQL ALARM: 91 rows 3.19k Archive: 840064 rows 245.41 M Log: 49018755 rows 1.47 G The retrival of data is very important, Oracle is better then MySQL but is very expensive. We must find a solution and Hypertable may be a good free alternative to solve this IMPORTANT bottle neck. Today we have a benchtest with ONLY 260 PV and we have 840064 rows but the Target project was not competed, and the storage of data is a key point for the physics studies. Nowday the PVs running is 1K and is growing up. Tips: What’s about this Archiver on SPES project ????? We must focus on storage and retrival of the data into Hypertable without commodity hardware. Giovannini Loris SPES Control System Group 11 Marzo 2010

  4. Archiver MySQL A genuine request for a new computer is a work requirement of my activity. The extraction, manipulation, and storage of massive records is a very time consuming process on a commodity computer system. A new computer system will eliminate various bottlenecks and develop advanced technologies that will bring true benefit to the physics studies. I will highly appreciate for your immediate and positive cooperation on this matter. Giovannini Loris SPES Control System Group 11 Marzo 2010

More Related