Skip to main content

Ivan Pavlov's Library tagged mysql →  View Popular

12 Aug 09

Spock Proxy

Spock Proxy supports range-based horizontal paritioning of a large MySQL database. The proxy intercepts SQL queries from the client, sends queries to the correct databases based on how the database is partitioned, then aggregates the results from each database and returns them to the client as a regular MySQL result set.

spockproxy.sourceforge.net - Preview

mysql sharding

30 Mar 09

SciBit: MyCon - MySQL GUI

MyCon (My Console for MySQL) is an extremely powerful windows based graphical user interface, MySQL GUI, for administering and working with MySQL server databases from version 3.21.x to 5.x.

www.scibit.com/mycon - Preview

mysql tools

13 Feb 09

Jet Profiler for MySQL

    • is real-time query performance and diagnostics tool for the MySQL database server. Core features:



      • Query, table and user performance
      • Graphical visualisation
      • Low overhead
      • Easy to use
26 Jan 09

pampa-j - Google Code

  • PAMPA-J is the first customizable and portable WAMP-J Environment (Window$, Apahace, MySQL, PHP, plus Aptana Jaxer).
04 Jan 09

Percona XtraDB Storage Engine for MySQL

A storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB.

launchpad.net/percona-xtradb - Preview

mysql

06 Oct 08

ExtSQL - Extended Usage Statistics for SQL

  • ExtSQL is NOT a NEW database server. It is a significant set of independently developed software additions
    and patches to the existing source code of both MySQL® & PostgreSQL. It provides a new set of SQL language features which
    make it easy for a DBA to monitor and audit activity on a busy server and account for activity by user, database, or even connecting client host.
    It even includes the ability to store historical usage data in amounts and time intervals specified by the DBA.     It is not a separate monitoring utility, but built into the core of both servers.
16 Sep 08

Infobright

  • Designed for analytics, ICE is easy to use, simple to manage and ideal for data volumes from


    500GB to 30 TB and more.  ICE combines a column-oriented database with a unique Knowledge


    Grid architecture to eliminate the complexity of data warehousing.
06 Sep 08

Tools :: Code Snippet :: A fast single pass method to calculate the median

http://rpbouman.blogspot.com/2008/07/fast-single-pass-method-to-calculate.html

forge.mysql.com/...tool.php - Preview

mysql

    • Creative, but very fragile. It depends a lot on how MySQL executes the query and may break even in the next minor version.

      First - assigning and using user variables in the same query - it's a big no-no.

      Second - using ORDER BY in the derived table. This makes no sense, because a derived table is a still table, and a table is an unordered set of rows. MySQL has full freedom to ignore your ORDER BY clause (although it doesn't do it at the moment). SQL standard doesn't allow ORDER BY to appear at that place at all.       - on 2008-09-06
    Add Sticky Note
03 Sep 08

nathan's noggin: MySQL: triggers + replication = frustration

  • But consider the case where the insert is on a table with a trigger that inserts a record into a second table (like an auditing table). The binlog only sets the auto-increment value for the actual insert statement. The trigger's insert will use whatever the replica's auto-increment value for the second table is set to. Since simultaneous transactions on the master are serialized in the binlogs, inserts on the second table may happen out of order, and auto-increment values will no longer match the master.
  • It seems that MySQL is not planning on fixing this bug in 5.0. My understanding is that in 5.1 the solution will be to use row-based replication. Statement based replication will still be broken, from what I can tell. I did see one bug report where someone said something about mixed mode replication, and switching to row-based temporarily for any statement or stored procedure call that will insert multiple records. Sounds like a can of worms to me.
23 Jul 08

Lightweight SQL Database for Cloud and Web in Launchpad

  • This project is about building a building a database designed for the typical Web usage patterns for a database. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL.
1 - 20 of 34 Next ›
Showing 20▼ items per page

Selected Tags

Related Tags

Sponsored Links

Ads by Google

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo