uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 49 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 work user process database share manage hardware professional buy industry internet dance advice installation developer 3d search access customer travel camera material test standard review documentation css money engineering develop webdesign engine device photography digital api speed source management program phone discussion question event client story simple water marketing app yacht content setup package fast idea interface account communication cheap compare script study market live easy google resource operation startup monitor training
Tag selected: mysql.
Looking up mysql tag. Showing 49 results. Clear
How do I allow MySQL connections through SELinux? - Server Fault
Saved by uncleflo on July 11th, 2019.
I'd like to for once leave SELinux running on a server for the alleged increased security. I usually disable SELinux to get anything to work. How do I tell SELinux to allow MySQL connections? The most I've found in the documentation is this line from mysql.com: If you are running under Linux and Security-Enhanced Linux (SELinux) is enabled, make sure you have disabled SELinux protection for the mysqld process.
fedora permission firewall subscribe overflow answer solution question connection database access administration documentation apache server selinux linux howto infrastructure mysql mariadb
sql - MySql : Grant read only options? - Stack Overflow
Saved by uncleflo on June 23rd, 2019.
Is there a way to group all read operations in grant ? If there is any single privilege that stands for ALL READ operations on database. "Reading" from tables and views is the SELECT privilege. If that's what you mean by "all read" then yes: However, it sounds like you mean an ability to "see" everything, to "look but not touch." So, here are the other kinds of reading that come to mind: "Reading" the definition of views is the SHOW VIEW privilege. "Reading" the list of currently-executing queries by other users is the PROCESS privilege.
solution read readonly write administration development privilege query database mariadb mysql data permission user howto question
MySQL Workbench: Database Migration
Saved by uncleflo on May 4th, 2019.
The MySQL Workbench Migration Wizard is designed to save DBA and developer time by providing visual, point and click ease of use around all phases of configuring and managing a complex migration process: White Paper: Migrating from Microsoft Access to MySQL » With the MySQL Workbench Migration Wizard, users can convert an existing database to MySQL in minutes rather than hours or days that the same migration would require using traditional, manual methods. The Migration Wizard allows you to easily and quickly migrate databases from various RDBMS products to MySQL. Click on image to enlarge.
workbench wizard migration migrate database developer process software download mysql mariadb rdbms product traditional visual phase manage administration data structure
MySQL: Scaling & High Availability
Saved by uncleflo on June 27th, 2018.
Production experience for the last decade(s). Peter Zaitsev, CEO, Percona. June 19, 2018. Percona Technical Webinars. Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and executed many different ways of scaling applications. Percona can help ensure your application is highly available. Come learn from our playbook, and leave this talk knowing your MySQL database will run faster and more optimized than before.
experience percona technical webinar scaling high availability performance application presentation pdf database fast speed howto mysql insight explanation references administration production
Data Warehousing Summary Tables
Saved by uncleflo on June 27th, 2018.
This document discusses the creation and maintenance of "Summary Tables". It is a companion to the document on Data Warehousing Techniques. The basic terminology ("Fact Table", "Normalization", etc) is covered in that document. Summary tables are a performance necessity for large tables. MariaDB and MySQL do not provide any automated way to create such, so I am providing techniques here. (Other vendors provide something similar with "materialized views".) When you have millions or billions of rows, it takes a long time to summarize the data to present counts, totals, averages, etc, in a size that is readily digestible by humans. By computing and saving subtotals as the data comes in, one can make "reports" run much faster. (I have seen 10x to 1000x speedups.) The subtotals go into a "summary table". This document guides you on efficiency in both creating and using such tables.
mysql mariadb warehouse warehousing summary table technique terminology normalization performance large material view total guide efficiency improve development developer create database average administration administrator infrastructure howto blog article description solution
Amazon - High Performance MySQL: Optimization, Backups, and Replication - Third Edition
Saved by uncleflo on June 27th, 2018.
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
amazon mysql power performance technique design index query tune server system hardware potential practical scale application replication balance availability failover infrastructure advanced optimization backup high performance buy product book information developer administration
How to use MySQL to search in php serialized fields
Saved by uncleflo on June 22nd, 2018.
Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays: SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' In case you have assoc array serialized you can use: SELECT * FROM table WHERE your_field_here REGEXP '.*"array_key_here";s:[0-9]+:"your_value_here".*' Of course it won’t be very fast but in small tables should be enough
rule index mysql search query array regex fast table associate serialized reason field php database stored solution development code sql
Create MySQL table by using another table
Saved by uncleflo on May 29th, 2018.
Let's look at a common task that a developer does in their day-to-day job. A database table is to be modified for its data and/or structure. Before making any changes, the first thing that is always wise to do is to back up the database table. The easy way to accomplish this is to write a piece of SQL script like below. The scenario is we're going to make some changes to Products table, so here we go. Copy and paste the following SQL to your SQLyog free Community Edition query window. Note that the SQL needs to end with semi-colon if you have multiple queries in the query window. Most of the queries in the tutorials need Northwind MySQL database, you can download the database script on this page.
common task database table development administration windows query tutorial mysql create howto example script modify structure web
MySQL Table Locking
Saved by uncleflo on May 9th, 2018.
In this tutorial, you will learn how to use MySQL locking for cooperating table access between sessions. MySQL allows a client session to acquire a table lock explicitly for preventing other sessions from accessing the table during a specific period. A client session can acquire or release table locks only for itself. It cannot acquire or release table locks for other sessions. Before going into detail, we will create a sample database named sampledb that includes a simple table named tbl to practice the table locking statements.
mysql lock howto tutorial demonstration table client session explicit administration rdbms db database practice technical understand article demo concurrency control learn guide description
UTF-8 all the way through
Saved by uncleflo on May 9th, 2018.
I'm setting up a new server, and want to support UTF-8 fully in my web application. I have tried in the past on existing servers and always seem to end up having to fall back to ISO-8859-1. Where exactly do I need to set the encoding/charsets? I'm aware that I need to configure Apache, MySQL and PHP to do this - is there some standard checklist I can follow, or perhaps troubleshoot where the mismatches occur? This is for a new Linux server, running MySQL 5, PHP 5 and Apache 2.
server utf8 web application encoding charset lookup reference apache mysql php iso troubleshoot linux lamp new howto details list problem description question solution development properly support website text content answer
Locking for Concurrency in MySQL
Saved by uncleflo on May 9th, 2018.
The first and most important point is that the primary use of locking is to solve concurrency problems. If scripts are being implemented that write to the database but aren't multistep operations susceptible to the problems described in the last section, locks aren't needed. Simple scripts that insert one row, delete one row, or update one row, and that don't use results of a previous SELECT or data entered by the user as input, don't require a lock.
lock database concurrency problem script operation howto description article technical result implement php mysql tutor resource reference control mechanism command
Object Oriented Programming is an expensive disaster which must end
Saved by uncleflo on May 9th, 2018.
Object Oriented Programming is an expensive disaster which must end. (written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at: lawrence@krubner.com. I work with a broad set of technologies, including PHP, NodeJS, Python, Ruby, PHP, Apex, Java and Clojure, and databases such as MySQL, PostGreSQL, Redis, ElasticSearch and MongoDB. I bring the perspective of someone who has been both an entrepreneur and a software developer. Having grown businesses from scratch, I have some experience with every aspect of development: marketing, design, technology, sales and raising funds.
oop programming expense disaster quote technology development description opinion article howto market sale intention business scratch php mysql blog why insight
How to find out who is locking a table in MySQL
Saved by uncleflo on April 18th, 2018.
MySQL is adding more tools to monitor its internals with every new release, but one thing it still lacks is a way to find out who is locking what, and therefore which transactions block which other ones. This is such a vital feature that I’m considering writing my own patch to the source! Still, it is possible, to a limited extent, to find out who’s locking resources. In this article I’ll explain how you can do that. This article is the second in a series on how to use the innotop MySQL and InnoDB monitor.
mysql sql lock mechanism deadlock error development administration howto article description innodb innotop release monitor tool feature transaction explain blog
MySQL LOCK TABLES and UNLOCK TABLES Syntax
Saved by uncleflo on April 18th, 2018.
MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to them. A session can acquire or release locks only for itself. One session cannot acquire locks for another session or release locks held by another session. Locks may be used to emulate transactions or to get more speed when updating tables. This is explained in more detail later in this section. LOCK TABLES explicitly acquires table locks for the current client session. Table locks can be acquired for base tables or views. You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.
lock unlock lock mechanism sql mysql database db development administration howto release data table code deadlock solution description reference documentation
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
phpMiniAdmin for MySQL
Saved by uncleflo on March 8th, 2018.
phpminiadmin - extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases. Instead of installing huge phpMyAdmin (~11Mb) and trying to figure out how to use all it's features, just upload one ~30Kb file and it's ready to use! Then access it via the browser (ex. http://yoursite.com/phpminiadmin.php). Script will ask you for DB login/pwd. After successfull db login you will see area where you able to enter any SQL commands (select, update, insert, etc.). Even if you don't know SQL it's still easy to: browse tables and see all the data, click to un/highlight rows
manage tables in DB, export and import data to .sql and CSV using 'quick links' on the top bar (see screenshots), see what databases you have permission with, check server status and statistics, ability to do CRUD (i.e. insert, select, update, delete), and launch any SQL supported by any version of MySQL. And due to it's simplicity script really fast and need just a little server resources! (your hosting provider will be glad ;)
installation mysql script page fast mini admin administration web website data database db sql browser permission table server developer work
Simple Bookmarking App With PHP, JS & MySQL
Saved by uncleflo on March 8th, 2018.
Part of the developer's life, is to strive for simplicity in every aspect of their work. When searching for solutions to common problems, you have the choice to lock yourself into all kinds of third party services and API's, or take the opportunity and develop the functionality yourself. In this week's tutorial, we are making a simple link sharing app. This app will give you the ability to instantly share any web page, with a single click of a bookmarklet in your bookmarks bar, and display it in a widget on your site. Note: This tutorial is quite old and doesn't work in PHP7 and above. We are keeping it online only as a reference.
bookmark app example php js mysql link share reference lookup development administration website simple search solution code learn blog howto
Running MySQL *.sql files in PHP Ask Question
Saved by uncleflo on February 15th, 2018.
I have two *.sql files that I use when creating a new web site database. The first file creates all the tables. The second file populates some default records. I would like to execute these files from PHP. I also use the Zend_Framework, if that will help accomplish this? Answer: This question comes up from time to time. There's no good solution for running a .sql script directly from PHP. There are edge cases where statements common in a .sql script can't be executed as SQL statements. For example, the mysql tool has builtin commands that are not recognized by the MySQL Server, e.g. CONNECT, USE, and DELIMITER.
question stackoverflow mysql php execute solution answer tool command statement config script shell linux howto good technical development administration security website webdev
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
How to avoid many-to-one problems in SQL
Saved by uncleflo on May 15th, 2017.
It’s been a while since I’ve posted an abstract, theoretical article on a fine point of SQL. Today I want to bring your attention to two ways in which an RDBMS can allow you to do something that has no well-defined result. These involve queries where several values are eligible, but only one is chosen – and chosen in an undefined manner. I’ll show you the two blunders, tell you when they might occur, and explain how to avoid them.
sql blog article problem query database description relation involve eligible many-to-one one-to-many explanation mysql
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
Centreon Development - How to write a module
Saved by uncleflo on December 9th, 2016.
You want to create a new module for Centreon 2 or to adapt an existing one? You’re at the right place! You should know Centreon contains a page dedicated to the installation and the uninstallation of modules (Administration > Modules). To make the module appears on this page, its directory must be placed inside Cetreon’s modules/ directory.
documentation development nagios module extend howto example structure php db mysql install uninstall functionality feature sql
How to Use Unique Indexes in MySQL and Other Databases - SitePoint
Saved by uncleflo on April 4th, 2015.
If you’ve been using databases for a while, you’ve probably set a primary key in most of your tables. A primary key is a unique identifier for each record. In this example, the ‘id’ column is our primary key. When we INSERT telephone numbers, if we don’t specify an id, an AUTO_INCREMENT number will be generated by adding one to the highest existing id.
mysql database development sql tutorial programming unique guide howto blog article description index search filter reference lookup
mysql - Find highest level of a hierarchical field: with vs without CTEs - Database Administrators
Saved by uncleflo on March 26th, 2015.
I have a self-referencing table with a primary key, id and a foreign key parent_id. Given a name, how can I query the top-level parent? Given a name, how can I query all of the id's associated with a record of name = 'foo'?
mysql hierarchical reference table record parent tree sql primary key database development howto solution question
Hierarchical data in MySQL: easy and fast
Saved by uncleflo on March 26th, 2015.
Storing hierarchical data in a relational database is a classic problem. Relational databases are not really designed for this purpose, because they store data in flat rows. Storage is actually the least of our problems. Imagine a commenting system with an unlimited level of nesting in replies.
hierarchical data mysql fast easy sql purpose system problem tree build construct development database howto
