uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 11 bookmarks
howto information development guide reference administration design website software solution service product online business uk tool company linux code server system application web list video marine create data experience description tutorial explanation technology build blog article learn world project boat download windows security lookup free performance javascript technical network control beautiful support london tools course file research purchase library programming image youtube example php construction html opensource quality install community computer profile feature power browser music platform mobile user process work database share manage hardware professional buy industry internet dance advice installation developer 3d search access customer camera material travel test standard review documentation css money engineering develop webdesign engine device photography digital api speed source program management phone discussion question event client story simple water marketing yacht app content setup package fast idea interface account communication cheap compare script study live market easy google resource operation startup monitor training
Tag selected: dbms.
Looking up dbms tag. Showing 11 results. Clear
MySQL EXPLAIN Output Format
Saved by uncleflo on April 18th, 2018.
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. MySQL resolves all joins using a nested-loop join method. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third table, and so on. When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. The next row is read from this table and the process continues with the next table.
explain explanation analysis mysql development administration query sql statement howto analyse optimize table method loop process row column output reference execution dbms innodb
Painless HA failover with MariaDB
Saved by uncleflo on February 26th, 2018.
At work, we run a simple high-availability (HA) MariaDB setup that consists of an active master that handles all read and write queries from our applications, a passive master that can take over for the active master at any time, and a read-only replication slave (not shown) that we use for backups and analytics. Replication is configured so that the active master follows the passive master, the passive master follows the active master, and the analytics slave follows one of the masters. For the remainders of this post, I will refer to the active master as the master and the passive master as the standby. The benefits of this master-master configuration is that it allows us not only to failover from master to standby if the master becomes unhealthy, but also allows us to perform patching, reboots, lengthy migrations, and other kinds of database maintenance without impacting our users. Well, almost...
high availability mariadb master slave query db dbms backup replication failover painless administration configuration perform patch reboot application remain impact user configure maintain
MariaDB High Availability
Saved by uncleflo on February 26th, 2018.
In information technology, High Availability refers to a system or component that is continuously operational for a desirably long length of time: Wikipedia up time / total time. Here, the presentation discusses MariaDB MaxScale, setup to see how it works.
connector mariadb nosql crud api core application development administration parse plugin source optimise memory connect graph extend high availability available syncronise audit replicate production howto discussion technology cluster tool db dbms distributed databases
PHP Mini SQL Admin
Saved by uncleflo on February 15th, 2018.
PHP Mini SQL Admin - Lightweight alternative to heavy phpMyAdmin. Extremely small (~30Kb) standalone php script. Easy to Install, simple to use. No SQL knowledge required for basic operations. Features: full MySQL support, extremely small (~30Kb), just in one php file.
php tool mysql interface connect light lightweight alternative small simple operation feature database file easy useful db dbms frontent mini query sql
SQL Source Control
Saved by uncleflo on June 7th, 2017.
Connect your database to your version control system. Version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. Solve other database challenges like deploying without losing data. And because it works with the tools you already use, it's an easy setup. Plugs into SQL Server Management Studio. Version control your schemas and static data. See who made what changes, when, and why
source control product software solution administer develop development server dbms database db howto introduction website explanation use application
OFFSCALE Get your database under control
Saved by uncleflo on June 7th, 2017.
Ready for the cloud. Creating so many DB snapshots that you never find the one you need? We’ll help you manage them! Reseting a server is easy but rolling back the DB is hard? Not anymore! Your database runs in someone else’s cloud? No problem! OffScale runs on your laptop and on the virtual server with the same ease
cloud software solution control version manage management schema data dbms database server reset rollback snapshot technical administer admin
Comparison of different SQL implementations
Saved by uncleflo on June 7th, 2017.
The goal of this page — which is a work in progress — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. The following tables compare how different DBMS products handle various SQL (and related) features. If possible, the tables also state how the implementations should do things, according to the SQL standard. I will only write about subjects that I've worked with personally, or subjects which I anticipate to find use for in the near future. Subjects on which there are no significant implementation variances are not covered. Beta-versions of software are not examined. I'm sorry about the colors. They are a result of wanting to mark each DBMS differently and at the same time wanting to be relatively nice to printers.
compare reference list implement sql differ legend dbms read study technical develop administer examine question howto
Managing Hierarchical Data in MySQL
Saved by uncleflo on May 15th, 2017.
Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table. For our purposes, hierarchical data is a collection of data where each item has a single parent and zero or more children (with the exception of the root item, which has no parent). Hierarchical data can be found in a variety of database applications, including forum and mailing list threads, business organization charts, content management categories, and product categories.
mysql databases dbms hierarchical tree database blog article question solution category relation purpose parent child sql collection item table lookup technical howto theory explanation list
Crate for Docker
Saved by uncleflo on October 12th, 2016.
Crate is an open source, highly scalable, shared-nothing distributed SQL database. Crate offers the scalability and performance of a modern No-SQL database with the power of Standard SQL. Crate’s distributed SQL query engine lets you use the same syntax that already exists in your applications or integrations, and have queries seamlessly executed across the crate cluster, including any aggregations, if needed. Crate is masterless and simple to install, operate and use. It handles transactional and analytical needs in one single database. Crate has been designed from the ground up to support the huge scale of Web, mobile and IoT applications. Love containers? Crate runs perfectly as stateful container.
crate distributed rdbms high-availability partition data dbms rdbms availability performance upscale scalability sql transaction storage engine website administration server software solution product opensource
MySQL Reference Manual for version 3.22.16a-gamma. - 10 Getting maximum performance from MySQL
Saved by uncleflo on February 8th, 2014.
Getting maximum performance from MySQL Each option is described below. Values for buffer sizes, lengths and stack sizes are given in bytes. You can specify values with a suffix of `K' or `M' to indicate kilobytes or megabytes. For example, 16M indicates 16 megabytes. Case of suffix letters does not matter; 16M and 16m are equivalent.
mysql administration performance maximize optimize reference manual description explanation database dbms buffer data cache guide
SQLite commands and general usage
Saved by uncleflo on September 6th, 2011.
SQLite is an embedded open source relational database (db). It is very portable, easy to use, compact, efficient, and reliable. Being an embedded database it becomes part of the program that hosts it. It is embedded in many popular programs used today. Most use the SQLite C API to interface with the SQLite db. Many scripting/programming languages use the API like the Perl module DBI::SQLite, PHP's data objects with the SQLite driver, or just straight C programs. Not only can these languages (and many more) use the SQLite C API to access the SQLite db but most OS's have a statically linked native binary that can also be controlled completely from the command line. How cool is that?
sqlite database documentation howto sql tips command general faq sqlite3 commands help pretty information guide dbms
No further bookmarks found.