|
И снова mysql...
1 hour ago
by Марат Радченко
mysql > create table t (a bigint , b bigint ) ; Query OK , 0 rows affected ( 0.11 sec ) mysql > insert into t values ( 1 , 1 ) ; Query OK , 1 row affected ( 0.08 sec ) mysql > insert into t values ( 1 , 2 ) ; Query OK , 1 row affected ( 0.02 sec ) mysql > update t set b = null where b not in ( selec ...
Здесь живёт ... - slonopotamus.livejournal.com · 3 references
|
|
Consultar tamanho de string
1 hour ago
by Junior
Existe várias funções no MySQL para extrair texto, trabalhar posicionamento, calcular tamanho entre outras. Neste post vou demonstrar como utilizar a funlção LENGTH(). A função LENGTH() no MySQL retorna o tamanho de uma string em bytes. A função pode ser substituida pela função CHAR_LENGTH() se quis ...
Shiguenori - blog.shiguenori.com
|
|
Secure existing MySQL installation
2 hours ago
by Dmitri
MySQL is a free, easy-to-use database server that supports multiple databases and tables, and allows clients to query them with SQL. This cheat-sheet shows how to secure MySQL in a few simple steps. Change MySQL root password First step to secure MySQL is changing the database superuser password, wh ...
SysAdmin.MD - sysadmin.md · 4 references
|
|
Fixing a MariaDB package bug
3 hours ago
by Kristian Nielsen
One of the things that I am really happy about in MariaDB is that we have our releases available as apt (and yum for Centos) repositories. This is largely thanks to being able to build this on the OurDelta package build infrastructure (which again builds on things like the Debian packaging scripts f ...
Kristian Nielsen - kristiannielsen.livejournal.com · 3 references
|
|
Installing LAMP on Kubuntu or Ubuntu
4 hours ago
by bojan
This post represents a small guide of how to setup your LAMP (Linux-Apache-MySQL-PHP) under Kubuntu (this works also for Ubuntu). Usually LAMP tutorials guide you to install one by one all the applications, that looks something like this: sudo apt-get install apache2 sudo apt-get install php5 sudo a ...
bojanpejic.com - bojanpejic.com
|
|
Oracle Performance Tuning Tactics Part 2: Using Indexes
4 hours ago
by admin
To recap, the “weapons” available in your “arsenal” for performance tuning are as follows:- Full table scans ; Indexes; Joins; Views; De-normalization; Oracle Stored Procedures; Sub-queries. 2. Indexes There are several types of indexes available with Oracle databases: * normal/B-Tree (balanced/ bin ...
Database Experts - dbpundit.com
|
|
MySQL на ZFS под FreeBSD: подготовка
4 hours ago
by Алексей Самойлов
Итак, что есть на руках: # uname -rm 8.0-RELEASE amd64 # atacontrol list ATA channel 2: Master: ad4 ST3500320NS/SN06 SATA revision 1.x Slave: no device present ATA channel 3: Master: ad6 ST3500320NS/SN06 SATA revision 1.x Slave: no device present # zpool status pool: tank state: ONLINE scrub: none r ...
Простые рецепты - sav.ecom24.ru
|
|
Linkeria (4. Dezember – 17. Dezember)
5 hours ago
by Martin
Diese Links habe ich in den letzten Tagen in meinem del.icio.us-Account gespeichert. Browser Size Browser Size legt ein halbtransparentes Bild ber eine angegebene Webseite und zeigt an wie viel die Besucher sehen. Die Daten ber die verwendeten Fenstergrößen der Benutzer stammen von Google. namebench ...
martin schneider - der tag ... - dertagundich.de · Rank: 105,098 · 40 references
|
|
Part1: Quad-Core Workstations for Desktop Virtualization Projects - ...
5 hours ago
by natiku
For our virtualization projects like JeOS Prototype / Virtual Appliances / VM Templates we need to have Desktop hardware with latest Hardware Accelerated Virtualization support, currently this mean AMD = AMD-V and Intel = VT-x platforms. Today is avaiable next (SECOND) generation of Hardware Acceler ...
VirtualGuru - blogs.sun.com/VirtualGuru · Rank: 183,381 · 10 references
|
|
Virutalization reality 2010 - It will be a multi-hypervisor world !!!
6 hours ago
by natiku
I found one interesting comment in this blog: Four Virtualization Realities of 2010 Reality #2: It will be a multi-hypervisor world. Will VMware be the main Data Center Operating System? Not with Microsoft, Citrix, Oracle, RedHat and IBM having a say. There's Hyper-V, IBM's AIX/LPARs, Citrix XenServ ...
VirtualGuru - blogs.sun.com/VirtualGuru · Rank: 183,381 · 10 references
|