Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- EnterpriseDB, InnoDB and Oracle
- This is just an update on EnterpriseDB. It's been a while since I posted anything EDB General Availability. This is just a quick update and some info from Andy Astor, the CEO of EnterpriseDB, on the acquisition of InnoDB by...This post originally appeared on an external website
- Tags: EnterpriseDB, Oracle Corp., Innobase InnoDB
- Blog posts 2005-10-18
- Specialized status commands in MySQL
- While the SHOW STATUScommand in MySQL generates a lot of useful statistics for understandingdatabase performance, there are a number of more specialized commands youshould also be familiar with. These give you specific status information thatcould help you debug any performance issues.SHOW INNODB STATUSThis command reveals performance statistics for the InnoDBtable...
- Tags: Databases, Guest Contributor, MySQL, performance statistic, Innobase InnoDB, performance
- Technical articles 2004-05-21
- Customer resource management is within reach with MySQL
- MySQL is great for building customer resource management CRM back ends to Web sites. It's already an integral part of many Web sites, and its pricing model is almost unbeatable. Furthermore, in active sites, there is probably already an impressive volume of CRM data just waiting to be mined.Working as...
- Tags: Sales force management, Databases, Sanders Kaufman, Jr., customer resource management, ISAM, Innobase InnoDB, MySQL
- Technical articles 2003-07-07
Additional Resources
- Getting Priorities Straight: Improving Linux Support for Database I/O
- The Linux 2.6 kernel supports asynchronous I/O as a result of propositions from the database industry. In this paper, the authors first show that the conservative I/O submission policy used by InnoDB (as well as Oracle 9.2) leads to an under-utilization of the available I/O bandwidth. The authors then show...
- Tags: Database, I/O, Linux, Operating Systems, Software
- White papers 2005-07-19
- Better database design with foreign keys and referential integrity in MySQL
- Recent versions of MySQL have implemented support for foreign keys through the new InnoDB table engine. This document explains how it works. Referential integrity refers to a state when all the references in a database are valid and no invalid links exist between the various tables that...
- Tags: Integrity, MySQL, Open Source, Databases, Enterprise Software, Software, Data Management
- Download resources 2006-02-06
- MySQL Foreign Key
- hello friends !i have a problem in my database. i use Foreign Key in my table and i want to enter value in 1st table primary key and it is automatically updated in 2nd table Foreign Key. how it is possible ? any one know that.....?Here you gohttp://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
- Tags: Databases, moazzamsafdar@..., FOREIGN KEY, MySQL
- Discussion threads 2007-09-19
- DOWNLOAD: MySQL table types
- http://techrepublic.com.com/5138-10585-5700552.htmlThe download lists eight table types available in MySQL and describes how each functions. [b]Is there additional information you think should be included?[/b]How to select a table type?This chart is a good start, but it's not clear to me when to choose what: INNODB looks wonderful, but surely there are...
- Tags: Mark W. Kaelin
- Discussion threads 2005-05-09
- SQLyog (exe)
- Import data from ODBC datasource, synchronize your database. Execute queries for updation of result. Copy databases between hosts. Generate Schema for your database. Manage Foreign Relationships and all options fully InnoDB compliant. Reorder columns. SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL...
- Tags: MySQL, SQLyog, Databases, Storage, Open Source, Enterprise Software, Software, Data Management, Hardware
- Software downloads 2008-01-08
- PortaOne Delivers VoIP Billing With MySQL
- PortaOne is a leading solution provider for VoIP infrastructure: billing, management and customer care solutions. PortaBilling is a VoIP billing package that enables ITSPs to launch, price and provision an impressive array of IP Telephony services. To succeed, PortaBilling required an affordable database with proven performance, scalability, reliability, and zero...
- Tags: VoIP, MySQL, PortaOne, PortaBilling, Open Source, Databases, Telecommunications, Enterprise Software, Software, Data Management
- Case studies
- EMS SQL Manager 2007 for MySQL (zip)
- EMS SQL Manager for MySQL is a high performance tool for MySQL Database Server administration and development. SQL Manager for MySQL works with any MySQL versions from 3.23 to 5.06 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on....
- Tags: MySQL, SQL, Databases, Open Source, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- An introduction to foreign keys and referential integrity in MySQL
- Referential integrity is an important concept in databasedesign. The term refers to a state when all the references in a database arevalid and no invalid links exist between the various tables that make up thesystem. When referential integrity exists, any attempt to link to a recordwhich does not already exist...
- Tags: OPEN SOURCE, Databases, Contributor Melonfire, species, MySQL
- Technical articles 2006-02-06
- Embedding Open Source
- Oracle's role in open source development has been a well-kept secret. It's also the reason for this column: To inform the user about Oracle's commitment to open source software - a commitment measured by significant investments in ongoing development and support across a wide variety of initiatives. As ever, Oracle...
- Tags: Oracle Corp., Open Source
- White papers 2007-01-01
- Download: Backing up and restoring MySQL databases
- http://techrepublic.com.com/5138-10585-5669476.htmlWe all acknowledge the importance of backing up important data, but [b]when was the last time you performed a backup? When you create your MySQL database backups, what steps do you take; can you add to the steps listed in the download?[/b]A completely different wayAbout 45 minutes ago. I don't...
- Tags: backup, database, databases, download, Mark W. Kaelin, mysql, software
- Discussion threads 2005-04-13
- EMS SQL Manager 2007 Lite for MySQL (zip)
- EMS MySQL Manager Lite is an excellent freeware graphical tool for MySQL Server administration. MySQL Manager works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys. It has minimal required set of instruments for...
- Tags: MySQL, SQL, MySQL Manager, Open Source, Databases, Enterprise Software, Software, Data Management
- Software downloads 2007-12-20
- DreamCoder for MySQL Enterprise (exe)
- DreamCoder for MySQL is a powerful software solution for MySQL Database administration and development. Our very intuitive interface will save you time and money. DreamCoder for MySQL works with all MySQL versions from 3.23 to 6.0 and supports all MySQL features including tables, views, procedures, functions, triggers, InnoDB Tables, foreign...
- Tags: MySQL, Open Source, Databases, Enterprise Software, Software, Data Management
- Software downloads 2007-11-29
- MySQL InnoDB Performance Tuning for the Solaris 10 OS
- A key strength of the MySQL database is its excellent performance and scalability, making it well suited to serve as a back end for web sites, data warehousing, and other data-intensive applications in the enterprise environment. To maximize the performance of MySQL on the Solaris Operating System, database server configuration...
- Tags: Sun Solaris 10, Performance, MySQL, Operating System, Sun Solaris, Open Source, Databases, Operating Systems, Servers, Software, Enterprise Software, Data Management, Hardware
- White papers 2005-12-01
- A fast and furious guide to MySQL database engines
- What if you were a racecar driver and could swap engines with the flip of a switch instead of having to make a trip to the garage? The MySQL database does something like this for developers; it gives you a choice of database engines and an easy way to switch...
- Tags: Databases, OPEN SOURCE, Storage, Sanders Kaufman, Jr., MySQL stock engine, ISAM, MyISAM, MySQL, database, database engine
- Technical articles 2003-04-07
- PostgreSQL database opens up to Windows
- PostgreSQL database opens up to Windowsarticle rootOpen databases: Which is best?MySQL and PostgreSQL are noteably the most mature of the open source databases.They are not, however, equivalent in terms of their performance under specific database designs.Just as the major commercial closed source databases have their preferred applications where their performance...
- Tags: database, Microsoft Windows, MySQL, netgk5815, PostgreSQL
- Discussion threads 2005-04-07
- MySQL or SQL Server: Look beyond politics and hype when deciding which to use
- Two of the most popular back-end data stores Web developers work with today are MySQL and SQL Server. They are fundamentally similar in that both are data storage and retrieval systems. You can use SQL to retrieve data with either because both claim support for ANSI-SQL. Both database systems support...
- Tags: OPEN SOURCE, Databases, Sanders Kaufman, Jr., MySQL, Microsoft SQL Server, MyISAM, server
- Technical articles 2003-03-18
- Release candidate of MySQL 5.1 slated for September
- MySQL recently announced that the release candidate of MySQL 5.1 will be out by September. Various alpha and beta versions of several related software products will also be out before the end of the month. This new version will feature row-based replication, events, partitioning, disk-based cluster...
- Tags: MySQL, MySQL Enterprise, Open Source, Databases, Enterprise Software, Software, Data Management, Paul Mah
- Blog posts 2007-09-15
- << Previous
- page 1 of 1
- Next >>
