Tag | Thread |
---|
1005 | Soln. for MySql 1005 (Can't create table) |
ERROR 1005 (HY000): Can't create table 'Azienda.#sql-697_c9' (errno: 150) |
10060 | Solotion of errno: 10060(1) |
Connect remote server using ODBC connection |
10061 | Running MySQL with no Internet |
Can't connect to Mysql 127.0.0.1 (10061), before never had the problem. What coudl have caused that? |
1016 | Replication error? |
1067 | How do I change this table to get it to load |
Erroe #1067 |
10x | Slow Query stuck on "Sending Data" |
12 | Got error 12 from storage engine |
1206 | Question about merging big tables? |
121 | Foreign Key Error 121 |
1236 | Replication fun |
134 | error 134 |
1364 | MYSQL Error n4 1364 (authentication string no default) while configuring |
1366 string error | data type and Character set for DUTCH language |
139 | Got error 139 from storage engine |
150 | Soln. for MySql 1005 (Can't create table) |
errno: 150 - foreign key constraint was not correctly formed |
ERROR 1005 (HY000): Can't create table 'Azienda.#sql-697_c9' (errno: 150) |
Help! Foreign Key error from SQL generated by workbench modelling |
ERROR 1005: Can't create table (errno: 150) |
Alter table add foreign key causes can't create table error |
16kb | Estimate table size |
2 ranges | Index with two date fields using comparison operators |
2-field index | problem for selecting range of date between 2 dates |
2002 | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) |
MySQL error, please help |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) |
MySQL startup - ERROR 2002 (HY000) |
Could socket failure be related to InnoDB errors? |
how do you fix error 2002 |
MySQL Error Nr. 2002 |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
2006 | Running Large scripts from command line |
2d | Simple query seems to be ignoring date index |
3 machines | Multi-Master replication in MySQL 5.1 |
30% | Select * from MyISAM table returns PK order / filesort order |
4g | MAX_ROWS on Partitions |
5.5 regression | performance degrades. why??? |
50x | index is not used why? |
5x | how to optimize this query |
64-bit | 32-bit BIGINT value |
768 | Is BLOB stored in InnoDB buffer pool? |
Performance LONGTEXT / LONGBINARY |
:= | Using a Parameter in Load Data Infile Command (Instead of direct filename) |
compare two rows in the same column |
RANK() emulator? |
Trying to Update Table with Rank... |
accents | accent sensitivity in fulltext search |
Searching with accented words |
access | Configure Database |
Access 97 to MySQL |
Microsoft Access & mySQL |
Database Import |
Db access/privileges philosophy |
MS Access transfer to MySQL on host server |
Converting Access to MySQL |
help please |
acid | COUNT(*) very slowly in large InnoDB table |
what's the purpose of InnoDB |
How does MySQL ensure ACID nature of transactions ? |
ad | Database Sharding at Netlog, with MySQL and PHP |
add pk | Adding primary key afterwards |
ai | Error Duplicate entry - Master-Slave replication |
aliases | speed of query/can index help? |
allow_invalid_dates | Load data infile not working |
alter | Table fragmentation and optimization |
Reverse Index columns |
How to clean up database after deleting records |
enable keys, force sort, not keycache |
Will increaseing table size affect current data? |
Large table designissue |
Require suggestion for changing character set in Master master replication setup |
adding index to a table |
Performing table inserts/selects while a alter-table query is running? |
Migrating from latin1 to utf-8 |
Adding columns to live tables |
does innodb table need 'optimize table'? |
alter enum | Need to change datatype for an enumerated field |
alter on dual master | Alter table with million of records - estimate how long does it take |
alter table | Index re-creation after composite primary key change |
alter via copy | seeking for better solution to change indexed column size |
Alter large table(MYISAM) |
Partitioning and multiple threads |
analyze | ANALYZE TABLE not working correctly |
Mysql does not use index, even if example is trivial? |
and2union | Index structure |
apparmor ubantu | Problem with LOAD_FILE |
application lock | Table Row Locking |
aramaic | Best collation to use for ancient languages |
attributes | Theoretical Database Table Structure |
audio player | MySQL + PHP Audio Reference |
audit trail | Audit Trail Help...again |
Snapshot Table -- over the long run |
auditing changes via replication |
upon retrieving the last insert id get the table name? |
auditing | How to audit entire database? |
auto-normalize | Importing a Tab-Delimited file into multiple tables |
autocommit | turning autocommit off by default |
Replication Slave update question |
autocommit=off | How to identify which connection has locked a particular table |
autocomplete | understanding the best design method for links table |
autoextend | innodb_data_file_path |
Automatic Extension Question |
auto_increment | AUTOINCREMENT & ROLLBACK |
autoincrement without primary key |
auto_increment behaviour |
AUTO_INCREMENT value increases by powers of two after INSERT ... SELECT |
insert ignore ... auto increment value |
Automatic field in a table |
Suggestable Engine |
autoincrement id missing when i do load data local into file |
MySQL Workbench 5.2.35: Error 1064: You have an error in your SQL syntax |
Resetting Auto Increment? |
table with multiple primary key |
auto_increment gap | Problem with "false" increment in InnoDB using a table with UNIQUE constraint |
auto_increment gaps | Can Autoincrement find the next free number ? |
b*tch | Is this database structure correct? Please help oh wise ones :) |
back tics | how to drop database named as database |
backslashes | Correct syntax to search for backslashes "\" |
backup | mysql with innodb and myisam |
MySQL Replication |
Replicating a big db |
MySQL Enterprise Backup Remotely |
Replication setup (for the first time) |
backup options | How can we ensure if mysql backups are consistent |
backup replay | restoring a DB from slave to the master in a replicated 2 node environment |
bad design pattern | select top x with a union |
banking | Ensuring data integrity |
batch insert | Batch Insert |
batch normalization | Alternate for Varrays in Oracle |
batched inserts | How to improve the insertion speed |
how to update with array (containing arrays) into table? or inserting? hot to combine with escaping? |
bbwc | Mixed engines within same database |
benchmark | Anyone know where a recent MySQL benchmark vs others can be found? |
benefical subquery | Larger than expected tmp files querying InnoDB format database |
best practice | Real-world DB schema |
between | Slow query |
big | About performance for Database of millions of records |
Questions about performance for huge table (100M+ rows) |
A lot of rows for a very specific task |
How to scale MySQL Cluster to support PB storage |
use index on a view |
Up to 1 million rows Performance + Design Help |
MySQL Appropriate for 1T- 5T DW ? |
Multiple Tables Split By Date |
bigint | Performance Issue |
bind-address | ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
binlog | Binlog not being updated... |
DRBD and Binary logs |
binlog off end | Could not parse relay log event entry |
binlog-do-db | slave replicates databases it should not |
binlog-row-event-max-size | ERROR 1153 (08S01) at line 356771902 in file: 'mysqlmulti-bins.sql': Got a packet bigger than 'max_allowed_packet' bytes |
blob | slow queries and high % of wait I/O |
Performance LONGTEXT / LONGBINARY |
MySQL blob performance |
STORE FINGER PRINT IN MYSQL |
block splits | Row size computation |
book | Kimball book recommendations & Schema question |
Online/Free Book Recommendations |
Is MySQL the tool I need? |
Getting started, need WINDOWS information |
book recommendations | Reading list suggestions for query skills |
Any tips for an MS SQL DBA trying to break into MySQL? |
Tips to close a reference book |
boolean | Strange result from DELETE query - can anyone explain?! |
brag | Queries to limit only this month and next month |
btree | Is this model correct? |
COUNT(*) very slowly in large InnoDB table |
Index re-creation after composite primary key change |
bucketizing | Counting occurences of data falling betwen a series of limits (buckets) |
buffer | INSERT/UPDATE within transactions (autocommit=0) |
buildins | Why does "in ()" give syntax error? |
bulk | Bulk collect |
Best primary key or index |
bulk insert | Bulk Insert Prepared Statement |
bulk_insert_buffer_size | Importing huge dump files into mysql |
c api | Which strategy is better to traverse a big table? |
cache | Basic Standards of Mysql server variable setting |
caches | re writing database |
Linking to a LUT more than once |
cannot connecct | Unable to connect to database: Can't connect to MySQL server on '[database server]' (4) |
canonical string | Charset and Collation Question |
case range | Optimizing a Query on a Very Large Table |
changelog | How much data to save |
auditing changes via replication |
changes | Database upgrade character column sizes may have changed |
char vs int | Best primary key or index |
char vs varchar | CHAR vs VARCHAR |
Query to find values that are the same in multiple tables |
char(0) | What is quicker for searching out of these two? |
character set filename | How to get database encoded name in mysql 5.6 |
charset | Problem inserting german and french characters |
Having tough time with spanish/catalan characters in my PHP/MySQL app |
Can replicating between versions cause crashed tables? |
Converting latin1 charset to utf8 |
Weird utf-8 encoding problem using webserver that does not occur in command line client |
cannot change character set |
MYSQL doesn't 'see' accents |
Encoding problem... |
connection collation |
Thai Characters display as ??? |
chcp | Character set for French Candian ? |
chcp 65001 | Proper display of special latin1 characters in Powershell / MySql client ? |
checksum | CHECKSUM TABLE on InnoDB |
chinese collation | Chinese sorting and filtering on an table with charset UTF-8 |
chinese regexp | how to retrieve only Chinese text from a table? |
chunking big operation | optimising a create table as select |
chunks | How to process very large result set from a dynamic cursor |
circular | mysql very slow after million insert/delete |
cjk | Asian language problems |
classic | Any way to optimize join to find rows without conditional foreign rows? |
Performance with select query that joins two tables one with 45MM and another with 12MM |
I have queries that sporadically take a very long time |
Portal Database design help |
3 Table Join (indexed) results in where-temp-filesort |
JOIN, LIMIT, ORDER performance problems |
clone slave | replication - slave copy - unclear points |
Moving dbs to new server |
cloud | partioning question |
cluster | Query optimization question |
MySQL training on Cluster and High Availability |
collation | Unproper order of sorting in utf8. Collation? |
"Duplicate entry" error using utf8_unicode_ci |
Will changing Default Collation on live BSD box cause any problem? |
A tip: Avoiding implicit charset matching errors |
Can someone please explain this misbehavior? |
collation benchmark | Case sensitive vs non case sensitive performance |
collation on sp | Illegal mix of collations |
combining diacriticals | Searching database for strings with Swedish characters |
comma | search comma separated db column |
Split Values by comma and Check in another Table? |
Column for mutiple and not-predefined values |
Iterating through SQL table |
parse by delimiter and search a data field? |
Setting up some new tables |
arrays or joins for multiple values? |
comma-join | "In" Statement Returning 6 Records…overall SQL statement returns 22 |
commalist | PREG_Match? |
Trying to retrieve data where a variable is in an array |
Having an argument about table design |
commalist normalization | Need Help W/ Query |
commandline | error logging |
complex | Slow SELECT on two tables |
compound gt | Showing recordsets from tables with one (main table) to many (secondary table) relationship |
compound index | Range on primary key using secondary index. |
Index on Datetime Col is not used When Where Clause combines two or more predicates |
Multi-Column indexes |
is good have single index an composite index on same field |
computer science | Delete Query |
concat | CONCAT Dates returning "BLOB" or '?' |
conditional average | sum and display issue |
connections | mysql max_connections |
Database Pool Size |
Site closes when two many connections |
consecutive values | Highest interval between two date same table |
construct queries | Basic update statement |
continuous compound index | Newbie question about correct settings to achieve better performance |
conversion | Mixed encoded DB Latin1 & UTF8 |
convert_tz | converting timezone for data in specific table |
cores | The result of MySQL's high concurrency and very large data performance benchmark. |
InnoDB Plugin Version 1.0.3 for MySQL 5.1.30/31/32 Released |
Maximize MySQL Performance on DBT2 Benchmark with Virtualization Technology on T5240 Server |
Something awfull with latest mysql on latest FreeBSD |
Help make my big new server fast |
Intra-Query Parallelism in MySQL Server |
MySQL + 2 x Intel Xeon (6 cores) performance problem |
Queries on MyISAM |
Why does MySQL's performance decrease when queries are executed in parallel? |
count | Alternative to FOUND_ROWS() |
COUNT(*) very slowly in large InnoDB table |
any faster select count(*) |
Slow queries with very large table |
count the disk hits | is it good add 3 index on a table with 30,000 insert in every 15 minutes? |
count(*) caching | count(*) speed in InnoDB |
covering index | Strange performance with JOIN/COUNT |
cp850 | Characters not getting stored |
cpus | MySQL 20x faster on RHEL 4 over Solaris 10? |
crash | Replicating server has died |
critical read | separate the Query and direction |
Three Node Replication (US West, US East and Europe) |
MySQL Master(Active) - Master(Active) Replication |
csv | Export Recordset query to a file nightly? Ubuntu and MySQL |
current_user | Can see Databases can't see tables |
cursor | Cursor usage with Prepared Statements |
custom collation | Problem with LIKE on index over custom utf8 collation, 5.0 |
dag | Unary many-to-many relationships |
data directory | data file location |
data masking | Tools for Scrubbing Entire Mysql Database |
data models | Car Parts Catalogue Database design |
data warehouse | Kimball book recommendations & Schema question |
Online/Free Book Recommendations |
Slow Inserts |
Database Design for huge set of data |
Inserting 5000 samples per sec in real time |
mysql TABLE tuning and performance |
Query optimization or better table design? |
innodb or myisam for logging |
MySql table disappears at random after multiple TRUNCATE queries |
database | One big DB or two not-too-big DBs? FKs across DBs are slower? |
database layer | how to upgrade database schema in M-M environment |
datatype size | Estimating disk space required for MySQL DB |
Confused about integer disk space |
Estimating Index Size on Innodb Tables |
How much space take each column in table |
datatype storage | how table rows are stored at the file level |
physical bytes |
data_free | file_per_table=1 question |
fragmentation in innodb index |
data_length | Automatic Extension Question |
date | UPPER with substring is not working |
Query Question |
MySQL Date Query issue |
how to convert timestamp value to string in MySql |
date modulo | Grouping by hour, day, weekday, week, month and year |
date range | Query taking a lot of time if there is no record in table |
date reformat | Casting Varchar to a date |
datetime | Time series database design |
Calculating TIME ELAPSED SINCE in days OR hours OR minutes |
missing data after partitioning - bug? |
datetime in partition | let table grow for two months then delete first month |
datetime vs timestamp | let table grow for two months then delete first month |
store SET time_zone as part of a VIEW statement |
daysequence | Query results from one table against a list created by another |
db stats | Deployment Statistics.... |
dbd | dbd::mysql not in ppm on windows |
deadlock | mysql_ping before transaction commit |
deadlock vs lock_wait_timeout | hard to test select for update scenario |
deadlocks | lock block deadlocks |
decimal | Is it possible to get MORE results by adding an AND clause to a SQL query? |
size of Decimal(18,4) |
Math function logarithm |
default | How do I change this table to get it to load |
Should I add a default value for a field that is set to NOT NULL |
definer | View problems when updating to 5.5 from 5.1 |
defragmentation | Optimize table and fragmentation |
delete | mysql very slow after million insert/delete |
Statement/row questions |
would like best table/index structure advice? |
Performing multiple updates and selects |
Very slow DELETE, UPDATE, INSERT on a new server |
CPU Usage during DELETE and OPTIMIZE |
MYsql getting crash |
Cursor usage with Prepared Statements |
Replication lag when no primary key on InnoDB |
delimiter | error using divide operator in function in mysql 5.5.9 |
delta | Query to find difference between data |
design | Simple Database Design Problem |
diff | need help with cross referenced tables |
dimensions | Optimizing a query so that the smaller table is handled first |
dims | appropriate database design and query |
directory structure | Changing Data directory |
disaster recovery | Mysql SAN Related Scenarios |
disaster recovery topologies | How to configure multiple instances on 2 hosts? |
disk hits | delete timing-feasible? |
disk usage | Old databases that are no longer required |
dissect explain | optimize request with order by and limit |
distinct | distinct vs. group by |
dll | Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\practice\testsql.php on line 17 |
Apache/MySQL/PHP Problem |
dns | Slow Connection |
How to troubleshoot slow response from MySQL |
double | MySQL Workbench 5.2.35: Error 1064: You have an error in your SQL syntax |
double encoding | Character encodings issues with php, mysql, apache |
fulltext search with utf8 characters (umlaut) with 5.1 |
double press | Unwanted multiple inserts: Should I use insert or replace into? |
double range | Optimizing a query so that the smaller table is handled first |
drbd | DRBD and Binary logs |
drupal | temp table or query for API |
dual master | MySQL Master/Master Replication |
MySQL settings for multiple server setup |
MySQL & SAN |
Replicating server has died |
What is Best solution for DR and 24*7 using two identical systems, cluster is not available here(hw) |
Multi Master and Slave MySQL servers |
Is this a suitable plan |
Masters in HA and slaves in LB |
Multi-master & Multi data-paths |
Replication & failover with 4 servers |
Can anyone give an advise in Multy-master structure |
Replication after dump |
Mysql 2 server replication setup with fail over |
dual master maintenance | Performance maintaining a live database |
dual master setup | Master database crashed |
Solving problems with mysql replica |
dump | take incremental backup |
dump master | re syncing a broken replicatoin |
duplicate key | Error Duplicate entry - Master-Slave replication |
eah disaster | RE: Academic Paper |
eav | Searching by using an index table, efficient queries? |
How to speed up Query with WHERE AND/OR, with Subqueries using IN |
Different data types |
User defined fields in a schema |
edge list | relationship query question |
either but not both | Compare two tables |
encryption | Building Memory Table from AES Encrypted Physical Table |
entities | Simple Database Design Problem |
Circular reference |
Database Structure Help |
Learning Management System MySql Database design |
enum | ENUM columns and blank values |
using enum as means of compression |
<char dimension with charset UTF8> |
enum alternatives | Poblem with a create table Query |
enum trick | Correcting spelling errors in an ENUM definition |
eq_range_index_dive_limit | Optimizer executes inperformant subquery first |
er | Query Performance Problem |
Modeling and Normalizing |
Searching by using an index table, efficient queries? |
school exercise I am suck on |
Database efficiency question |
Data model metadata design and data driven joins |
Simple Database Design Problem |
Circular reference |
Database Structure Help |
DB structure - Managing a collection of books |
My First Database (HELP) |
Learning Management System MySql Database design |
Designing a forum - general design logic question |
Lookup Table with Optional Fields? Null primary key for blanks? |
Problem creating table with 2 primary keys |
erd | ERD Design HELP! |
error -1 | got error -1 while reading table 'tablename' |
error 108 | InnoDB: File (unknown): 'flush' returned OS error 108. Cannot continue operation |
error 150 | query not running |
#1005 - Can't create table (errno: 150) |
error 24 | Replication error? |
escaping | delete query doesnt work with php |
replacing (escaping) unescaped apostrophes already in mysql |
"#" symbol inside text of databse |
How do I assign unique id to call data? |
ethernet | connect 46 pcs on my pc MySql server |
etl | Update more than 30,000 records row by row |
uploading 300+MB files to MySQL db |
euro sign | load data infile: "Incorrect string value" with special chars |
events | Events: what if server is down? |
Has anyone used "event" in mysql |
excel | Connecting to MySQL from Excel 2007 |
Import Excel in MySQL?? |
LOAD DATA |
exchange partition | Partition data backup and restore |
exchange partition with table | Is there a SWITCH equivalent in MySQL? |
exclusion join | which kind of join? |
exit handle | Transaction won't end |
expand and contract | Question about LIMIT |
explain | Slow select with sub queries |
greatest-n-per-group performace for different data types |
understanding towards Using where; Using temporary; Using filesort is right? |
Help optimizing query/index |
failover | Switching to backup DB on error |
Mysql 2 server replication setup with fail over |
fast ingestion | MySql table disappears at random after multiple TRUNCATE queries |
fast random update | Optimize multiple writes on the same row |
federated | How do I find out details of a Server link for Federated tables? |
feed processing | uploading 300+MB files to MySQL db |
field | Re: MYSQL Sorting IN by orignal order? |
file priv | CSV import with mysqlimport |
file redirection | Store dump from DB on Server A to Server B (File) and test restore on C |
filesort | Query Optimization - order by |
always uses filesort even after adding indexes |
Subquery with range uses filesort |
filesystem | databases and log files on separate hard drives |
file_per_table | All Innodb tables using seperate ibd, but ibdata1 still being modified? |
TableSpace |
filing cabinets | random reads |
find id hole | How to create a solid sequence? |
firewall | Replication: Connecting Slave and Master |
Error encountered on slave "Waiting to reconnect after a failed master event read" |
first partition | I searched table on one partiton, but MySQL scanning two partitons |
first slave | Start slave fails |
Initial setup of replication with large tables |
Setting up replication in a Windows Sever 2003 environment |
Replication setup (for the first time) |
fixed | Estimate table size |
Text(1024) |
how table rows are stored at the file level |
fixed vs dynamic | MYSQL manual using MANY frequently changing Varchar(255) |
Questions related to Row Format, Encoding, and performance |
fk | Foreign Key Error 121 |
Need help to improve innodb performance |
another fool having problems with FK in InnoDB |
flags | Ноw better to store large number of flags? |
best for true or false, Yes or No |
float | Bug in the floating point value |
Is it possible to get MORE results by adding an AND clause to a SQL query? |
Math function logarithm |
float double decimal | Comparison Between Floating Point Types |
float unequal | BINARY operator not working properly |
for update | table locking |
foreach | write trim into INSERT and SELECT Queries |
foreign key | Soln. for MySql 1005 (Can't create table) |
dropping a foreign key constraint |
Why use JOINS when have FK |
ERROR 1005 (HY000): Can't create table 'Azienda.#sql-697_c9' (errno: 150) |
Multiple references of a PK |
Error 1005 Errno 150 |
#1005 - Can't create table (errno: 150) |
foreign keys | drop all constraints, then reinstate all constraints??? is there a way to do this?? |
Can't create table with Foreign Keys - errno:150?? |
found_rows | Alternative to FOUND_ROWS() |
fractional seconds | [SOLVED] DATETIME does not keep fractional seconds (5.6.11) |
fragmentation | Table fragmentation and optimization |
Performance increased after mysqldump restoration ? |
does innodb table need 'optimize table'? |
ft_min_word_len | Working with short words in full text search |
fulltext | match against search won't match strings with a forward slash in them |
accent sensitivity in fulltext search |
Using FULLTEXT index with a boolean on the matched field? |
Seeking advice on setup |
Cascading deletes |
Query not returning result in fulltext search boolean modeeven though records exist |
functions good practice | Connecting to MySQL on numerous pages |
gap lock | Minimize row locking for update statement |
gaps | scanning for data gaps in time series |
general log timestamp | No timestamps in general query log |
geo | Unused index, slow query |
GEO Search with large table is very slow |
grant | One big DB or two not-too-big DBs? FKs across DBs are slower? |
remote access and privilages |
HOW DO CREATED USERS LOG ON MySQL CLI? |
Re: Can't seem to create a new user account |
How to change mysql username from "root" to "apps" |
Make Table or Catalog Read Only |
User password being modified as a result of grant statements? |
MySQL users question |
Why doesn't root get full privileges? |
Revoke privileges from user issue! |
Creating a restricted user account |
grant host names | connect as remote server |
Can't connect with non-root user to created database |
grant localhost | creating database users |
graphing | Building Graphs with MySql data |
group by | problem with concat() distinct() min() and GROUP BY |
Unsure about query... random column? |
using GROUP_CONCAT |
MySql 4.1 optimization search poor performance |
distinct vs. group by |
Noob query issue |
group by trick | Complex Select with Min/Max Syntax |
Listing threads by newest posts? |
How does group by algorithm works? |
Subquery and JOIN's |
limiting rows returned |
max function |
Help with minimum/group by |
create function help |
select max date in Inner Join |
aggreate data |
query returns unwanted duplicates |
Require help to formulate a query. |
Slow Query |
Assistance required for query with subquery |
Last or Max? |
Unexpected Result when using MAX(id) and GROUP BY |
group union | [Query help] Table transformation |
groupwise max | max row from table |
groupwise-max | select max date in Inner Join |
group_concat | multiple rows into one line string with |
Simple statement |
group_concat. join | Database efficiency question |
guid | SELECT took lengthy of time |
How can I decide which partition type can I chose |
GUID field |
guid performance | Deadlock Detection in InnoDB storage engine |
ha | MySQL HA 2 instances + iscsi shared data dir |
replication or mirroring? |
When do I start... partitioning? |
Fail Over |
hacker protection | How do I assign unique id to call data? |
handler | HANDLER statement questions |
Expected query time? |
hash | How should I make text column search faster? |
having | Simple statement |
heartbeat for replication | measuring slave lag without sysdate() - 4.1.13 |
hide password | Running backup in cron without clear text pw |
hierarchy | Return the level and count of a closure table. |
select max date in Inner Join |
Building a widget/graph from mysql view |
Unary many-to-many relationships |
relationship query question |
challenging problem -spliting different values within one field |
high cpu | Mysql using 95% of cpu |
highwater | Milli and Micro seconds in mysql |
hints | Intermittent slow performance |
history | MAX_ROWS on Partitions |
Snapshot Table -- over the long run |
Mysql cluster 7.1.5 can't use table partition! |
New to design; how to optimize 3 column single table with high I/O? |
holidays | Query results from one table against a list created by another |
horizontal partitioning | RAM requirements- new server |
hosts file | Slow connection |
How to troubleshoot slow response from MySQL |
html | why do I need to set encoding in the browser in order to see Arabic letters |
html entities | Storing Special Characters in Table |
htmlentities | Problem with fulltext search using encoded german umlauts (strange behaviour of "MATCH(column) AGAINST ('keyword' IN BOOLEAN MODE)") |
htmlspecialchars | Something like Server.HTMLEncode for MySQL |
huge | Which storage engine? |
load data infile real-time data load |
trillion records? |
huge pages | innodb memory usage vs swap |
hugepages | sanity check on innodb config |
ibd | How to restore innoDB tables without ibdata1 with innodb_file_per_table=1 |
TableSpace |
BLOB storage file |
ibd recovery | InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past |
ibdata | How do we resize ibdata file? |
ibdata1 | After creating tablespace .ibd, Mysql doesnot start |
Switch to file_per_table using a slave |
Different ibdata files for every database |
mysqldump and import to de-fragment tables |
data_free not empty |
All Innodb tables using seperate ibd, but ibdata1 still being modified? |
changing from 1 big file to file_per_table |
TableSpace |
ibdata1 contents | ibdata1 and undo log |
iblog | Connection lost |
Different ibdata files for every database |
Innodb Log File Error |
id | Real-world DB schema |
identifying relationship | Please explain identifying/non-identifying relationships |
ie caching | MYSQL appears to not recache Selected table after Insert |
ieee754 | Sum of doubles giving incorrect value |
image | Image database in mySQL |
image display problem from mysql database |
retrieving a photo from mysql database |
saving image in mysql |
User-friendly approaches to displaying subtable data |
image as blob | Where are BLOBs useful? |
image output | Show images from database |
imagecreate | Show images from database |
images | Using images with php and sql |
img src | Show images from database |
implode | loop doesnt seem to run |
import | Need to Convert Date Time at Query runtime |
impossible position | Got fatal error 1236 from master when reading data from binary log |
in | PHPMYADMIN hangs on this query!.HELP!!!! |
Efficient string comparison to a group of values |
Why isn't an index being used here (nested query) |
Optimizer executes inperformant subquery first |
in select | Using NOT IN |
Optimizing a query so that the smaller table is handled first |
in-list | PHP filesize and storing a big WHERE clause in a variable |
incompatibilities | Moving Mysql to a new server |
Re: max(DateField)+C <> max(DateField+C) |
index | Re: Large range query stops using indexes |
Slow query on very large table |
index selection |
How does index perform with LIKE? |
how to solve this complex query |
making a row unique |
GEO Search with large table is very slow |
how to optimize this query |
Order by using filesort on where |
Advice on redundant indexing |
Help with optimize SELECT |
does unique index do more than just being a constraint? |
Preferable Index Length |
Mysql does not use index, even if example is trivial? |
DATETIME vs. INT(11)? |
Statistics used by optimizer. |
Concat Occasionally Drops a Character or Two |
Query is so slow |
Index not being used |
Is index needed or not? |
Rebuild Indexes Online after Insert/Update |
combined index ignored |
Multi column indexing question |
index performance on "limit" condition |
Problems with query not using expeced indexes |
Attempt to split big table into smaller one made query slower |
Primary key - link to data ? |
Need help on indexing |
Statistics |
Improving Slow Query |
Indexes: how many, how much? |
Lock wait timeout exceeded; try restarting transaction |
InnoDB to MyISAM |
Query with > 500000 entities in in where clause crashes server |
tables with 3,500,000 rows, indexed but still v slow |
multicolumn index & forcing index to avoid filesort |
COUNT(*) very slowly in large InnoDB table |
performance issue on order by index |
Estimating Index Size on Innodb Tables |
Join Statement with math operation |
Huge row size compared to MyIsam |
CREATE TABLE ignores DATA DIRECTORY option |
Need Database Structure Help |
Size of INDEX_LENGTH is higher than DATA_LENGTH ! |
Index recomendations |
Slow query with order by and limit |
11 millions records : more than 30 seconds to retrieve simple request |
Table marked as crashed and last (automatic?) repair failed |
Partition on day of year |
Stop using filesort |
physical bytes |
Best primary key or index |
Problem with a query performance |
indexing |
Help optimizing query/index |
Creating an Index |
Does LIMIT 1 without ORDER BY ID bring the record with minimum ID? |
Understanding MySql optimization of Queries |
Optimize Inner Join With WHERE BETWEEN dates |
Slow insert rate in mysql innodb |
Question about indexes |
is good have single index an composite index on same field |
Function and indexes |
index creation | checking status of CREATE INDEX |
index design | MySQL not using indexes |
Backup and trimming data idea |
index details | how index grows in size |
index examples | Slow query. Why is it slow? |
index join | ideal indexing for inner join, rowcount of 1 |
index not used | Indexing is done for single table, but its not working for most of the queries. |
index order | Optimization of where clause |
index size | I've got two Tables and wonder why a table with less data can have a bigger keysize? |
index-10-30 | MySQL 5.1.49 - Optimal settings for memory usage |
indexing | Looking for understanding of optimizing queries |
Issues with possible duplicate indices on table |
MYISAM INDEX KEY Question |
information schema | SHOW VARIABLES: which table holds my.cnf startup varibles? |
Wrong info from Information_schema |
information_schema | creating data dictionary |
Procedure is not working |
init_connect | Encoding problem |
injection | Unique Constraint Using My Own Definition of "Equals" |
Db access/privileges philosophy |
inner join | Optimizing query |
innodb | evaluating table locking |
ANALYZE TABLE not working correctly |
slow queries and high % of wait I/O |
Reduce Index space |
Alternative to FOUND_ROWS() |
mysql very slow after million insert/delete |
AUTOINCREMENT & ROLLBACK |
Negative consequences of converting to InnoDB? |
Insert into table on duplicate key update - performance issue |
COUNT(*) very slowly in large InnoDB table |
Replication lag when no primary key on InnoDB |
Huge row size compared to MyIsam |
New to design; how to optimize 3 column single table with high I/O? |
Does LIMIT 1 without ORDER BY ID bring the record with minimum ID? |
innodb analyze | Different Servers Using Different Index for Same Query on Same Data |
innodb blocks | Varchar does it cause data file to continously grow |
innodb corruption | Table corruption |
innodb count(*) | Slow access to large tables |
innodb fragmentation | Is my data fragmented? |
fragmentation in innodb index |
innodb free | Can I automatically reuse the free space of a table that in the InnoDB |
innodb free space | data_free not empty |
InnoDB File Size |
fragmentation in innodb index |
innodb fulltext | MySQL 5.6: InnoDB Full Text Search (FTS) |
innodb index | problem about second index on innodb |
innodb internals | JemeryCole/Twitter: Deep Dive into InnoDB Internals |
innodb io | buffer pool read/write? |
innodb log files | Setting innodb_log_file_size disables the innodb engine |
innodb pk | Need help to improve innodb performance |
innodb primary key | Primary key for referee table. |
innodb random dives | can mysql use 2 different execution plans for the same query ? |
innodb row size | Row size |
innodb semaphore contention | quantifying activity at the buffer pool? |
innodb settings | Innodb_buffer_pool_pages_free = 0 |
innodb size | Automatic Extension Question |
innodb transportable tablespac | InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past |
innodb vs myisam | InnoDB to MyISAM Disadvantages? |
Innodb v/s Myisam |
innodb_buffer_pool_size | Max size of innodb_buffer_pool_size |
innodb_file_per_table | poor performance on good hardware |
Can we have different tablespace for indexing in innodb storage engine? |
How to create TableSpace |
Separate databases in separate files |
How to stop a database growing in size on the disk |
innodb_flush_log_at_trx_commit | limitation on request per second |
Very slow query for no apparent reason |
MySQL InnoDB performance tuning |
innodb_locks_unsafe_for_binlog | Getting "Lock wait timeout exceeded;" when using "for update" |
MySQL 5.6.12 and many deadlock |
innodb_log_file_size | Switch off InnoDB logging - Possible? |
Reset Root Password causing ib_logfile issues |
values in my.ini for 2GB RAM |
Unexplained drop in performance? |
innodb_log_file_size |
Correctly setting mysql options for a huge DB with intense trafic |
Power failure and innodb |
innodb_log_file_size formula | how to calculate innodb log file size |
innodb_max_purge_lag | mysql very slow after million insert/delete |
innodb_os_log_written | MySQL Server locks up daily |
innodb_stats_sample_pages | More Stable Query Execution Times by Improving InnoDB Statistics |
innodb_table_monitor | Foreign Key Error 121 |
ins | Updating multiple rows with an array using PHP with mySQLi |
insert | Slow Inserts |
Inserting 5000 samples per sec in real time |
insert on duplicate key | Problem of indexing Country, State , City |
insertion speed | Need mysql Configuration Parameters that affects Insertion rate |
inserts | Need help to improve innodb performance |
Insert into table on duplicate key update - performance issue |
install on windows | Solution: Cygwin and DBD::mysql |
installing php | Apache 2.2.22 with PHP 5.2.17 don't connect to MySQL |
interactive_timeout | Close conections |
into outfile | Export Recordset query to a file nightly? Ubuntu and MySQL |
io big | random-access I/O |
ip | What data type should I use and what storage engine? |
Help with the best table layout for message board |
Slow query |
ip range | Optimize IP Range Join |
optimize IP range join: postgresql is 496 times faster |
update big table cause an excution time out |
How can I optimize this query? |
Keys ignored for larger tables!? |
iterative update | Updating 100 million record tables |
java time | Storing Java Timestamp (long) in database as BIGINT? |
join | Some general questions |
JOIN table USING vd JOIN table ON table_field=another_table_field |
PHPMYADMIN hangs on this query!.HELP!!!! |
trouble figuring out joins, any gurus out there? |
INNO DB performance problems with temporary tables |
nested select |
tables, joins or not, to script or not |
After upgrade from 4.1.22 to 5.1.44 query not working |
JOIN, and LEFT OUTER JOIN: I don't get it |
Join Syntax Confusion |
Difference between two SQL queries |
join 101 | Need help with a more difficult query |
join opt explained | MySQL 5.1.31 -- Same query scans widely different # of rows |
join order | can I use two join in a single query ? |
join vs subquery | Faster SQL - newbie needs help |
"Optimizing sub queries with joins" |
join vs union | Left Join between two large tables too slow!! |
joins | Problem with SQL query :( |
json | User defined fields in a schema |
json for eav | What's the worst that can happen with below database design? Immediately or in the future? |
key value | linked data |
Query Optimization |
Create tables: Shall i use one table or different tables in order to store data? |
How best to storing User Profile data |
Help collating multiple rows from multiple tables into a single row |
Large number of columns causing - Unknown Error |
table/query help |
How to speed up Query with WHERE AND/OR, with Subqueries using IN |
Data model metadata design and data driven joins |
key-value | User defined fields in a schema |
key_buffer | Processor at 99.9%, memory at 5%. Configuration help? |
Queries slow down daily, optimizing helps -> why? |
Key_Buffer_Size |
large multiple table update taking a very long time, help! |
mysql max_connections |
key_buffer_size version | Help make my big new server fast |
key_len | Multi-Column indexes |
key_reads | Memory settings for server with 4GB RAM |
What happens if the size of an index file exceeds physical RAM? |
kill | how to stop it |
kv | Opinions on this schema please =) |
kv table | “CACHE INDEX” and “LOAD INDEX INTO CACHE” |
Having an argument about table design |
language recommendation | MySQL / WebFront End / Best Language to support? |
last_inserted_id | How do I combine 3 queries into one |
last_insert_id | Looking up a value in a 'subtable' and inserting it if it doesn't exist |
Update query problems |
Transaction deadlock with many threads |
Select and update at the same time (with selected value)? |
Problem of indexing Country, State , City |
lat lng | Slow select on table with 1.8 million rows (filtering on lng/lat) |
How to improve query performance in expression related order by? |
lat-lng | select query in from clause creates problem |
latitude and longitude | Optimised way to search over 2 milllion poi data in mysql |
latitude/longitude | query not using index |
layer | mysql user access level |
When do I start... partitioning? |
lead and lag | Oracle Analytical Functions |
leaderboard | RANK() emulator? |
leap seconds | PHP and MySQL time not same |
lecture | Poor Performance with tables over 1Million entries |
left join | Help w/ data modeling, 1 to 1, 1 to none? hack? |
need help with cross referenced tables |
Help with query with conditions |
Help with Join Query |
need help! query to get absentees list |
left off | 30M rows - is dynamic sorting and selecting even possible? |
How do deletes and updates affect fetching of rows? |
Innodb PK in secondary index |
next/previous on a date select query |
left_off | should i go with myisam or innodb? |
licensing | MYSQL Community vs entreprise |
like | is good have single index an composite index on same field |
like suffix | How to fast search in 3 millions record? |
limit | MySql 4.1 optimization search poor performance |
Using LIMIT in a SELECT statement which does a JOIN |
index performance on "limit" condition |
Index not working as I expect |
limit helps/hurts optimization | MySQL Explain rows limit |
limits | Storage capacity |
Max quantity users in MySQL |
Data object standards |
Maximum Constraints Per Table |
ln -s | How to Install MYSQL that comes with SLES 10 on a SAN mount point instead |
load | Testing the updated database whether it is properly updated or not |
load balancer | Master-Master Active-Passive loadbalancing with ultramonkey |
load data | Append with LOAD DATA INFILE |
need to upload .txt to SQL table. |
Load Infile - Not able to import microsecond level datetime from CSV |
CSV import with mysqlimport |
loading data problem |
Proper syntax of LOAD DATA INFILE |
load data expression | Mass Import Innodb |
load data local | load data errror ONLY on remote server |
load data paradigms | Importing Data from an XML Document into a MySQL Table |
load data set variable | Null values are replaced with zeros in infile. |
load data variables | Is it possible to use variables and string functions with LOAD DATA LOCAL INFILE? |
localhost | creating connection to "Server Administrator" |
locate | Comparing strings |
locking | Minimize row locking for update statement |
locks | Solving table locking issues |
Help with locks |
Are queries queued? |
lock block deadlocks |
log files | Log files filling up |
log sequence | Index not used in certain DELETE-queries? |
log-slow-slave-statements | Replication server is running behind |
login | Mysql and CentOS 5.2 |
Need Help - Server was hacked |
MySQL on Ubuntu mess...pls. help |
login access | Access |
logs | mysqldump for BLOB?, InnoDB log files? |
log_warnings | Prevent logging for unsafe statements |
long running transaction | Query id on SHOW INNODB STATUS |
longblob | MySQL kills itself when cannot allocate X bytes |
look for | impact of havig both concurrent_insert=2 and low_priority_updates=1 together? |
loop thru | Cursor usage with Prepared Statements |
Select query too slow from merge table of 1 billion records |
lots of tables | MySQL 4.1 to 5.1 large scale upgrade |
lower | Using DECODE with SELECT and LIKE |
lower_case_table_names | Change DB to case-insensitive = problems |
lvm | Replication setup (for the first time) |
maatkit | How to know if a slave is identical to his master ? |
mac install | Problems creating my.cnf / options file |
make commalist | while loop - how to remove last comma |
many tables | tables per company - why not |
many-to-many | Need help on designing simple db |
Problem creating table with 2 primary keys |
Simple many to many query... |
many:many | Bulk data question |
1 to many and many to many help |
Learning Management System MySql Database design |
Unary many-to-many relationships |
many:many relationship | best practices in relationship |
mapping | Basic conception for database |
mapping table | Tables optimization for messages feature |
Inverse Lookup in Key-Value Storage: avoid disk seeks |
INSERT IGNORE ... SELECT performance question |
master-master | How best to support global website? |
max | InnoDB to MyISAM |
max-allowed-packet-size | ERROR 1153 (08S01) at line 356771902 in file: 'mysqlmulti-bins.sql': Got a packet bigger than 'max_allowed_packet' bytes |
maxclients | To many sleeping connections |
max_allowed_packet | Maximum number of records the "SELECT IN" operation can handle! |
MySQL server has gone away |
How long does a query take? |
max_allowed_packet and its impact on backup (and replication) |
Not enough memory to allocate insert buffer of size 1073741824 |
max_connections | Debugging too many connections |
How to get MySQL concurrent query nos. |
Does a too many connections error always really mean it? |
Question on max_connections |
Both master and slave stop accepting connections |
max_connection |
Can the use of Ephemeral ports be disabled? |
max_heap_table_size | Real weird slow down with select count(distinct x) and high max_heap_table_size |
max_join_size | "SHOW VARIABLES" and "mysqladmin variables" show different settings |
max_open_files | Error 23, 1016: Partition with MyISAM |
max_rows | Will increaseing table size affect current data? |
MAX_ROWS |
max_updates | ERROR 1226 (42000) at line 1129: User 'root' has exceeded the 'max_updates' resource (current value: 100) |
md5 | Fastest way to check for an image in a table |
How should I make text column search faster? |
SHA-256 which data type is the best? |
meb | MySQL Enterprise Backup Remotely |
median | How do I get the median instead of average? |
meet in the middle | Multiple Databases - Search and retrieve. |
meet me halfway | Ignoring certain characters with SELECT query |
I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table |
memory | InnoDB log group capacity error |
Anybody met this errors :Out of memory (Needed 16777224 bytes) ? |
Slow Updates on Memory table - (detailed) |
Optimising max_heap_table_size & tmp_table_size |
how to estimate the real mysql memory consumption? |
mha | Disaster Recovery with master-master replication |
Setting up Circular replication in existing replication infrastructure |
middle | Another Complex Query |
regexp challenger |
milliseconds | Date/Time Query |
Milli and Micro seconds in mysql |
mixed replication | Replicating from innodb server to myisam server |
mongodb | Comparison b/w mongodb and mysql |
more_results | stored procedure with cursor only returning one row in PHP -- works in MySQL client |
move datadir | Not able to move database to mounted LUN in linux |
moving average | Moving average |
mrr | MySQL 5.6 update doubled IOs |
mssql | DataMigration from Sqlserver to MYSQL (Experts help need!) |
mssql conversion | convert mssql function to mysql function |
mssql functions | Converting Functions from MSSQL to MYSQL |
mssql to mysql | Migrate a MS SQL server database to MySQL |
mtype | MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE |
multi-master | Multimaster replication set up with a single slave |
multiple disks | Chaning database dir to another hard drive |
multiple key_buffers | Anyway to identify the special key_buffer_size |
multi_query | stored procedure with cursor only returning one row in PHP -- works in MySQL client |
mutex | What's the difference between concepts--latch and mutex? |
mutexes | MySQL + 2 x Intel Xeon (6 cores) performance problem |
Why does MySQL's performance decrease when queries are executed in parallel? |
my.cnf | Slave is not updating some tables ..... |
my.ini location | Error 10061: connect to MySQL server failed |
my.ini my.cnf | How do I find what configuration files were loaded |
myd | BLOB storage file |
myisam | random reads |
is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? |
myisam advantages | Transactional vs. NonTranscational For The Layman? |
myisam auto_increment | How MySQL MYISAM manage the auto_increment column |
myisam indexes | Significance of Primary Keys |
myisam pointer size | Table full message when data is just over 16MB |
myisam vs innodb | should i go with myisam or innodb? |
Database effeciency |
HELP! making choises on Performance - Storage engine - Caching |
New to InnoDB (want to convert from MyISAM) |
myisam-innodb | Error Duplicate entry - Master-Slave replication |
myisam_data_pointer_size | myisam_data_pointer_size |
myisam_max_sort_file_size | enable keys, force sort, not keycache |
myisam_sort_buffer_size | myisam_sort_buffer_size |
Repair Will Not Use Filesort |
"Alter table enable keys" randomly using "Repair with keycache" |
mysql history | Why does MySQL's performance decrease when queries are executed in parallel? |
mysql server has gone away | Running Large scripts from command line |
mysqldump | Aborting Optimize Table for Innodb |
How To bakcup Databse per table ? |
Best Prctice export from MySQL 5.1 to 4.1 |
what should i do when backup ? |
Partition-wise mysqldump backup script at MySQL Forge |
MySQL Backups - Innodb |
backup database |
stored procedures and functions |
moving mysql database |
mysqldumpslow | Problematic Query identification at the time of load on server |
mysql_proxy | MySQL Proxy - Production Worthy? |
mysql_real_escape_string | Adding a filename to a MySql database |
my_use_result | Memory Allocation error |
name | Order by using filesort on where |
navicat | Import and export flat files containing backslashes |
netstat | Replication: Connecting Slave and Master |
network | Switching to backup DB on error |
net_buffer_length | max_allowed_packet and its impact on backup (and replication) |
new slave | Adding slaves to replication environment |
new slave from old | 1 Master -> Many slaves, need to update dump file |
new thread | 1135 Can't create a new thread (errno 11)... |
newbie | building tables |
nmap | Replication: Connecting Slave and Master |
nondeterministic replication | A qq reg SBL with current_timestamp() |
nor | indexing on every column? |
normalization | Design of tables |
ERD Design HELP! |
Is my database normalized? |
How do I count the number of rows with certain data |
select * where value>1 |
Newbie Normalization Question |
Insert keys from 1 table into 2 others. |
Rock/paper/scissors design |
normalize | Time series database design |
finding it hard to setup the relationships |
Performing multiple updates and selects |
Standard way to store user information |
Database Normalization: Always the best thing to do? |
JOIN vs Denormalize table vs Vertical partition |
not using index | Problem with a query performance |
null | after moving database problems with NULL value |
Using null to mean all or any |
nulls | NULL but TRUE |
numa | Poor performance of MySQL 5.5 |
numbering rows | SubQuery and result |
o'brian | Mysql query produces different results for different users |
odbc | Configure Database |
How to open MySql? |
offline backup | Offline Backup |
omg | UPDATE a field SEVERAL times in 1 UPDATE |
on duplicate | Deadlock occuring since setting a unique index. |
on duplicate key | How do I combine 3 queries into one |
one-to-many | Subtypes can they be related |
oo | PHP OO mysqli query problem |
open file limit | max_open_files error |
optimize | does innodb table need 'optimize table'? |
optimize innodb | Optimizer for innodb does not reduce "data_free" |
optimize table | Optimize table statement |
Optimize table and fragmentation |
Execute table optimization concurrently |
optimizer | Optimize Inner Join With WHERE BETWEEN dates |
optimizer_search_depth | Query Performance Problem |
select with join of 25 tables crashes mysql database |
or | Extreme high load and low throughput using MySQL & Hybris on an HP DL380G5, quad-core Intel, 4GB RAM |
Help optimize query |
index usage dependent on in(group) content |
Poor performance with an "OR" |
or to union | Long execution time despite LIMIT 3 |
WHERE OR performance issue |
oracle | Bitmap Index |
order by | unique ID field, getting next and previous existing ID from table |
Re: MYSQL Sorting IN by orignal order? |
distinct vs. group by |
Query Optimization - order by |
order by field | Order by my order. How to ? |
How to keep order of values inside IN() operator |
showing records in order given by in clause |
order by list | IN order |
order by rand | Slow MySQL Queries |
org chart | Building a widget/graph from mysql view |
os | Table fragmentation and optimization |
os limit | Error: ORDER BY clause |
MySQL fails to start |
over-normalized | Big problems on optimizing query |
pager | Index not used in certain DELETE-queries? |
pagination | MySQL Performance Tuning on my server |
Query performance on database with joins |
Slow search query |
Query performance question (using index slows down?) |
Alternative to FOUND_ROWS() |
Very Slow Simple Query |
break mysql query? Is this possible in my sql |
Query that returns indexed fields involves FILESORT, why? |
join in union |
Efficient MySQL for pagination of large amounts of data on website |
Showing recordsets from tables with one (main table) to many (secondary table) relationship |
Use of memory table vs temporary table question |
Heavy task on mysql by AJAX Pagination? |
Jet Profiler says I'm slow.... |
pagination - precalc | Handling Large Datasets |
pairs | Query To Find the Number of Self-Joins? |
paragraph | Retaining paragraphs in text data type |
parallel | Performance LONGTEXT / LONGBINARY |
large multiple table update taking a very long time, help! |
parallelism | Intra-Query Parallelism in MySQL Server |
partition | MAX_ROWS on Partitions |
How to partition my table |
Table partitioning |
How to create partition on existing table? |
Partitioning with range(to_days) issue |
Partition-wise mysqldump backup script at MySQL Forge |
Improving Slow Query |
How to handle secondary keys in partitioning? |
Exceptions with Partition Pruning |
How can I decide which partition type can I chose |
Open tables with Partitioning |
MySQL performance help |
partition by range on decimal type |
count rows in a partition |
How to stop a database growing in size on the disk |
Simple query seems to be ignoring date index |
partition add drop | Using MySQL Partitioning Instead of MERGE Tables |
partition auto_increment | Partitioning by date, and maintaining uniqueness |
partition by day | Problem with granularity choosen |
Add new partition for Range by date |
partition by list | Fortnight partitions |
partition discard | Backup one of the sections in innodb table |
partition mapping table | How to partition that table? |
partition null | Partition Pruning |
partition priority queue | KEY vs RANGE partitioning |
partition suggestions | Move from unpartitioned database to partitioned database |
partition use cases | When partition a table |
password | Help on MySQL 4.1 & PHP 4.3.11 |
creating connection to "Server Administrator" |
any cheat-sheet style documents? |
What do you do with the database user passwords? |
pdf | MySQL blob performance |
pem | SSL error: Unable to get certificate from '/etc/mysql/newcerts/client-cert.pem' |
percent improvement | What hardware factors influence MySQL query execution time |
percentile | Why I can't insert more than 100,000 rows in a script?(mysql+php) |
can i quickly do a 95th percentile in mysql |
Calculation of a '95th percentile' |
Counting occurences of data falling betwen a series of limits (buckets) |
perf | slow queries and high % of wait I/O |
random reads |
Statement/row questions |
Any way to optimize join to find rows without conditional foreign rows? |
Very slow DELETE, UPDATE, INSERT on a new server |
performance | CentOs or Oracle Linux? |
performance_schema | MySQL Performance Schema: Overview |
MySQL 5.6 update doubled IOs |
permissions | Replication problem |
persistent innodb statistics | timestamp, datetime as default value as current_timestamp [PARTITION] |
petabyte | How to scale MySQL Cluster to support PB storage |
phone numbers | When to use separate tables. |
phones | printing fetched values |
Creating a variable variable name |
php | Storing Special Characters in Table |
php build where | mutiple field query |
php escaping | Mysql query produces different results for different users |
php file upload | How insert data in table using a .txt file |
php flow | Creating report filter by name in one table |
php install | Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions |
Error when trying to configure PHP to work with MySQL |
php log_errors | Pasted text not saving |
php mysql_fetch_array | PHP access not working right |
phpmyadmin | cannot change character set |
physical copy | physical export |
piping | Store dump from DB on Server A to Server B (File) and test restore on C |
pivot | Need help with a Query....cross tab format |
Pivot Table Rows into Columns stored procedure |
insert 0 when combing tables? |
Cross-table in stored procedure |
Pivot tables |
plesk ubuntu | Always get "Access denied for user 'root'@'localhost'" after installing |
plugin | Plugin 'InnoDB' init function returned error. |
upgrading to innodb plugin |
How to create TableSpace |
polish | Unproper order of sorting in utf8. Collation? |
portuguese | Using accentuation or other special characters and printing with php. |
ppm | perl script hangs on query with where clause |
precision | Math function logarithm |
prefix | index usage dependent on in(group) content |
Slow Query for Alphabetically Adjacent Terms |
prefix index | Very slow sort on Order By for MySQL query. |
preload cache | Preloading Index - LOAD INDEX INTO CACHE problem |
prepare | prepared statements for multiple queries |
prev value | Getting data from previous row |
primary key | Primary Index |
Replication lag when no primary key on InnoDB |
Question about indexes |
table with multiple primary key |
privileges | Db access/privileges philosophy |
procedure | Procedure is not working |
progress bar | is automatically monitoring progress impossible? |
prune | Noob question - simplist way to store last 4 viewed products? |
pt-query-digest | Problematic Query identification at the time of load on server |
pt-table-checksum | Comparing large slaves to master |
pt-table-sync | Comparing large slaves to master |
pta | Tracking past group memberships of multiple groups |
pwd security | Designing a forum - general design logic question |
qc | Linking to a LUT more than once |
qc too big | Randomly slow Insert / Update on small table |
qps | Help make my big new server fast |
Database Pool Size |
query cache | Queries slow down daily, optimizing helps -> why? |
Why is my entire database getting locked for a slow select query? |
Query cache was never filled up |
Understanding the Query Cache and the Innodb_buffer_pool??? |
A fast (>0.01s) query sometimes slow (>2s) |
Query Cache Causing High CPU Load |
Poor performance of MySQL 5.5 |
query cache no | MySQL 5.5 and Query Cache |
queue | row-level lock that prevents SELECT? |
queuing | FOR UPDATE and LOCK IN SHARE MODE |
quotes | delete query doesnt work with php |
Looking for Rule on quoting |
quoting | MySQL Output Help |
raid | databases and log files on separate hard drives |
CREATE TABLE ignores DATA DIRECTORY option |
InnoDB and separated disks |
5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes) |
raid controller | Inserts very slow |
ram | MySQL eats all of RAM memory |
is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ? |
rand | evaluating table locking |
small DB, big problems |
select limit records from 600000 records |
rand() to randomize rows only once daily |
random | Horrible performance on BLOB's when using WHERE or ORDER BY |
random sorting - what is the quickest method? |
random dives | Analyze question |
random fetch | Very Large Non-Dynamic Table for Lookups |
random id | best way to generate a random unique id |
random index | Fact Table Partition Design |
range | Select * from MyISAM table returns PK order / filesort order |
Simple Query -- Needs to be Mind Numbingly Fast! |
ranges | I want to write a user-defined Aggregate Function |
What Method is Best |
rank | RANK() emulator? |
your ranked out #x of X accounts? |
Get row of a specific result |
rank order | sp vs query window |
rbr | Row based Replication: Deadlock is not rolled back |
rdf | About performance for Database of millions of records |
linked data |
read committed | MySQL Backups - Innodb |
read-write separation | Forwarding writes to master |
recovery | Restore InnoDB schema from partial backup |
redo logs | Power failure and innodb |
redo transaction | fix "Deadlock found when trying to get lock; try restarting transaction" |
ref range | Query using "ref" instead of "range" access |
regexp | REGEXP() Question |
RegExp Question |
how to find particular string from text column |
mysql regexp issue range |
Pass Numeric Values From Form To Set Data Lenght +... |
regression | Mysql 5.1 to 5.5.1.18 Upgrade Poor Performance |
relay | how to setup master, primary slave master and slaves |
relay log | PURGE BIN LOGS FILES NOT WORKS |
remote | connecting to Mysql server running on a different machine |
rename | Bulk updates on live database |
insert or load ? best practices and performance |
rename table | Importing a database dump created with --single-transaction does not result in single-transaction import of the file |
why my db don't use index? |
reorganize partition | help making event for auto delete of partitions |
repeatable read | Uncommitted rows are updated by a second transaction |
repeatable-read | MySQL server configuration for a 8 cpu+20gb RAM server |
repl | mysql replication issue (Handling write load on slaves)? |
replace | Character encodings issues with php, mysql, apache |
replication | master-slave replication good solution? |
Upgrade from 5.0 to 5.1 |
Replication multiple database |
Can't restart slave - Could not initialize master info structure |
Replication problem |
Need advice to Setup replication server (INNODB) |
replication or mirroring? |
update slave after failover |
Error Duplicate entry - Master-Slave replication |
replication bug | MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE |
replication checklist | setup mysql replication on CentOS error |
replication designs | conflict resolution |
replication lag | Slave is lagging from master |
Master - slave connection |
replication sequence of events | is it possible replicate with mysql5..5 |
reset root password | Setting up root password |
unable to create database even as root user |
resignal | Stored procedure, stored function and signals |
resize | Different ibdata files for every database |
resize iblog | Caonot change innodb_data_file_path |
result caching | Memory Allocation error |
resultset | Question: Technical Background Of The Result_Set |
reverse | How to fast search in 3 millions record? |
reverse lookup | Slow Connection |
revoke | Make Table or Catalog Read Only |
Revoke privileges from user issue! |
revoke proxy | Create new user by using MySQL CREATE USER statement |
rollback | Transaction won't end |
rolling window average | No Window Fns in MySQL? |
root | Resetting the Root Password on Windows |
Need Help - Server was hacked |
Debugging too many connections |
creating connection to "Server Administrator" |
any cheat-sheet style documents? |
MySQL users question |
Why doesn't root get full privileges? |
rot | Help optimizing query/index |
roundtrips | Alternate for Varrays in Oracle |
row size | exact row size of InnoDB table |
blob to mediumblob or largeblob |
rowid | internal rowId |
safe-updates | "SHOW VARIABLES" and "mysqladmin variables" show different settings |
san | What is the story of NAS and SAN file systems for Database? |
How to Install MYSQL that comes with SLES 10 on a SAN mount point instead |
scaling | Skyblog, Friendster, twitter, yahoo mail..... how to design database for huge no. of users and rows |
design distributed database |
word index - is there a better solution? |
scaling via slaves | Three Node Replication (US West, US East and Europe) |
schema | select query not using indexes |
Where to find a tool for differences between two database structures |
Up to 1 million rows Performance + Design Help |
I have queries that sporadically take a very long time |
scrubbing | Tools for Scrubbing Entire Mysql Database |
search | Searching with accented words |
search form | Problem with search when add BETWEEN to query |
searching | SQL instructions enclosed in "/*! ... */" |
seconds_behind_master | "Seconds behind master"-Value jumping |
secrets | Long query locking up MySQL Server |
security | Replciation Security |
Actual Newbie Question with mysql connect |
Changing Plain Text Passwords to Hashed Passwords |
Database Encryption |
Connecting as a User |
Building Memory Table from AES Encrypted Physical Table |
What do you do with the database user passwords? |
select | Rewrite Full Outer Join into Subquery |
select * | optimised way |
self join trick | grouping query results in their order |
selinux | Moved datadir and now get: ERROR! The server quit without updating PID file |
startup mysql as service on redhat enterprise linux 6.4 |
semanage | startup mysql as service on redhat enterprise linux 6.4 |
sequence | A sequence solution for those that want it |
Unique columns over two tables |
Record Position in Ordered Selection |
Last/highest ID? |
Simulating sequences |
server_id | How server id is communicated? |
session | Max_used_connections |
set | search comma separated db column |
PREG_Match? |
set names | Re: Korean characters displaying as ??? |
load data character set question |
import utf8 to latin |
Data is being in non readable format. |
Problem with Accented characters while migrating SQL server to MySql server |
set names utf8 | Problems with Spanish characters |
Encoding problem |
sets | Help with query... |
setup slave | New to MySQL Replication |
sharding | performance: sharding and replication ideal? |
How to scale MySQL Cluster to support PB storage |
Database Sharding at Netlog, with MySQL and PHP |
Skyblog, Friendster, twitter, yahoo mail..... how to design database for huge no. of users and rows |
Are there any pitfalls with having multiple MySQL databases on 1 server node? |
When do I start... partitioning? |
sharding steps |
How to enable index fast in MyISAM table |
shared memory mode | How to connect with Workbench to server in shared-memory mode ? |
sharp s | Problem inserting german and french characters |
utf8_general_ci (MySQL 5.0.x vs. 5.1.36) |
show master status | how to setup master, primary slave master and slaves |
show slave status | slave stuck |
sig alrm | SIGALRM blocked by MySQL |
signal example | Date check on insert. |
simple index | Query Tuning techniques |
skip grant tables | unable to create database even as root user |
skip-name-resolve | [SOLVED] Can't connect to remote server |
skip-name-resolve and access issues |
slam | Help collating multiple rows from multiple tables into a single row |
slave | PURGE BIN LOGS FILES NOT WORKS |
slave initialization | Quick replication questions |
slave invalid position | Exec_Master_Log_Pos doesn't move (invalid position?) |
slaves | Slave to master replication |
slave_open_temp_tables | Replication, Stored Procedures & Temporary Tables |
sleep | To many sleeping connections |
sliding segment | Adding Segments in Table |
slow | select query not using indexes |
my system usage hits 100% at every 6 hours. |
Slow search query |
use index on a view |
350+ million rows -- is this as fast as it can get? (too slow at the moment!) |
Slow Mysql optimizer |
slower | I have queries that sporadically take a very long time |
slowlog | MySQL using 80-90% of CPU |
CPU usage spikes to 100% every week or so |
Query Tuning techniques |
MySQL performance on a HP DL385G7 |
snapshot | MySQL & SAN |
MySQL Replication |
Replicating a big db |
Mysql SAN Related Scenarios |
Faster dump using mysqldump |
snodgrass | Time series database design |
social search | Theoretical Database Table Structure |
socket | MySQL Socket Error |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
sort-union | Queries using WHERE IN and ORDER BY LIMIT |
sort_buffer_size | Optimizing MySQL filesort with small limit. |
sp | create function help |
sp backup | How to backup Stored Procedures |
sp prepare limit | ERROR 1064 , in stored procedure |
space | Aborting Optimize Table for Innodb |
speed up inserts | No Limits - Memory Engine |
speedup | I need Optimizaton of a Query - DISTINCT |
sql injection | Two usefull functions(XSS/SQL injection). |
Multi user issue |
SQL Injection |
$_POST Help : |
Text box security |
Multiple databases |
Assistance with securing input |
Numbers Vs. Characters in MySQL Database |
sqlexception | Transaction won't end |
sqlite | Convert MySQL to SQLite |
sqlserver | Switching from Sql Server |
sql_calc_found_rows | full table scan for limit?? |
Query that returns indexed fields involves FILESORT, why? |
resultset rows performance |
sql_mode | Load data infile not working |
sql_slave_skip_counter | Replication Errors on Slave DB |
ssl | SSL error: Unable to get certificate from '/etc/mysql/newcerts/client-cert.pem' |
Failed to Setup SSL warning |
SSL connection works but SSL Replication does not |
ssn | field types syntax |
start end | How MySQL Uses Indexes |
start_time | Index on datetime type |
start_time end_time | Query not using index |
stateless html | When to open/close the MySQLConnector |
stateless http | How many users on one connection? |
stddev | What is the SQL equvalance to VARIANCE |
stopwords | FULLTEXT search failing |
stored procedure | MySQL Stored procedure Tutorial |
stored procedure with cursor only returning one row in PHP -- works in MySQL client |
strict | Testing the updated database whether it is properly updated or not |
Upgraded MySQL - Lot's of Similar Errors |
string as number | Problem with MySQL SELECT |
stripe | Can a Mysql MyISAM or InnoDB table benefit from the STRIPE feature of disk device? |
Can a Mysql MyISAM or a InnoDB table benefit from a set of multi-thread and multi-disk I/O device? |
str_to_date | Need to Convert Date Time at Query runtime |
Datetime conversion fails |
stumbling | Why INSERT performance has not increase in sub-table? |
subqueries | Why are no indexes used in this case? |
subquery | Please help with slow easy query |
Get statistics using self joins |
Performance of WHERE EXISTS query |
100% cpu usage on single cpu core |
nested select |
tables, joins or not, to script or not |
Partition on day of year |
slow query in Inndb |
Rewrite Full Outer Join into Subquery |
subquery - 5.6 optimization | Dead query |
subquery can help | Optimizing it even more |
Simple JOIN is extremely slow. |
Strategy needed for picking random rows |
subquery to join | How kan I optimize this Code? |
sum data_length | MySQL 5.5.31 cripplingly slow |
summary | Design approach for summary table by 3 items |
compressing tables |
Counters |
Database Design for huge set of data |
InnoDB CPU Spikes |
Very long query doubt... (Monster query...) |
Slow JOIN to convert IP to Country Code |
Best way to store/access large amounts of data? |
should i go with myisam or innodb? |
Large table designissue |
Partitioning with range(to_days) issue |
Multiple complex queries |
UNIX_TIMESTAMP Duplicate key |
views, unions and different dbs |
Slow 'sending data' phase on mySQL query, for simple query |
Thinking about sorting articles.. |
Index performance |
Storing a large, dense tensor (35gb scientific data) -- is mysql appropriate? |
Large Table Architecture |
summary table | Bitmap Index |
To store or calculate on the spot? |
summary tables | Solving table locking issues |
Which storage engine? |
Killed by joins. 1 minute selects in Access, 15 minutes in mySQL |
GROUP causing Using Temporary Using Filesort |
Partitioning or Not Partitioning? |
super freaking | select with join of 25 tables crashes mysql database |
surrogate key | Primary key for referee table. |
swap | Regarding use of swap memory for MySQL. |
Basic Standards of Mysql server variable setting |
Strange disk usage in mysql datadir (partition) |
swap tables | MySql table disappears at random after multiple TRUNCATE queries |
swapping | Very Slow Simple Query |
symbol | Simple query seems to be ignoring date index |
symlink | Different data directories for different databases? |
sync_binlog | Got fatal error 1236 from master when reading data from binary log |
Got Fatal Error 1236 From Master Reading Data from binary log possibility to loose data/? |
crash recovery of sync_binlog=1 and innodb_flush_log_at_trx_commit=2 |
table design | DB Design - Users Table |
table lock | SELECT queries Locking Problems |
table name case | Case Sensitivity for View Names |
table name casefolding | mysql and xampp |
table of ints | select dates in a month that fall on a given day of the week |
table scan | Select * from MyISAM table returns PK order / filesort order |
field equal to OR between 2 fields? |
full table scan for limit?? |
Optimising a GROUP BY and ORDER BY in a joined query |
Question on bad execution plan |
tablespace | How to create TableSpace |
tablespaces | Importing Data with Single .ibd file |
table_cache | Optimizing table_cache - Open files? |
table_open_cache | Open tables with Partitioning |
teaching | Teaching mysql to teens |
tee | importing Text to MySQL |
temp table | Outfile Using too much disk space |
temporal | MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE |
temporary table | Storage engine used by temporary tables |
text | InnoDB log group capacity error |
TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500) |
large multiple table update taking a very long time, help! |
thread stack overrun | Writing my first Stored Procedure |
What is wrong with my Stored Procedure? |
timestamp | Different timestamps for time of creation and time of update |
how to convert timestamp value to string in MySql |
Date - unix_timestamp |
timestamp default | Timestamp fields |
timestamp microseconds | convert seconds to minuts |
timestamp vs datetime | DATETIME vs. INT(11)? |
#1452 - Cannot add or update a child row: a foreign key constraint fails? |
timestamp(14) | Error: Too big precision 14 specified for 'time'. Maximum is 6. |
timezone | How to time sync MySQL with system time |
DST and UTC_TIMESTAMP |
timestamp column behavior |
Curdate() returning one day old date |
ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist |
Mysql ADDTIME can it do this ? Daylight savings time issue |
converting timezone for data in specific table |
TIMESTAMPADD and Daylight Savings Time issue??? |
Probable timezone problems: can anyone confirm and offer a solution? |
timezone tables | convert_tz giving null even after updating time zone files |
time_zone_id | CONVERT_TZ time_zone_id reliable? |
tiny | Oracle CLOB in MySQL? |
tmp | how to solve this complex query |
question about create a table |
/tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files |
tmp tables | Optimising max_heap_table_size & tmp_table_size |
tmpdir | ERROR 126 (HY000): Incorrect key file for table |
tmp_table_size | Changing tmpdir causes InnoDB to break |
top n | Top n Scores |
Selecting max for each day |
topn | [SQL] Left join order |
Select N per Value |
touch | Poor Performance with tables over 1Million entries |
transaction | Transaction/Locking Question |
transaction rollback | mysql innodb transaction concurrency |
transactional | what is transactiona and non transactional table in mysql? |
transcoded column | specific collation issue |
transcription | Checking for exact match in row |
transpose | Query Slowness |
tree | Multi Level Sorting - Queries Question |
Modifed Preorder Tree Transversal Child Roll Up (including grandchildren) |
Building a widget/graph from mysql view |
tree walk | How to transform NESTED SETS to XML? |
trigger | Trigger Replication is not same as in the documentation |
Delete record with backup |
trigger example | Mysql |
Date check on insert. |
trigger limitations | Triggers & sProcs |
triple master | Multi master problem |
trx | limitation on request per second |
tuning | MySQL Performance Tuning on my server |
High CPU use (spikes) and Page Faults in VM |
MySQL Performance Tuning Help |
Optimal Mysql Configuration (my.cnf) |
tutorials | Self-Help |
tv listing | What Method is Best |
typos | Strange results when doing a Fuzzy comparison of two email addresses with the match/against function |
union | Paging on Union queries |
N-to-N Model: Table Size vs Complexity |
Opinions on this schema please =) |
Slow query - help me optimize ? |
INNO DB performance problems with temporary tables |
join in union |
Poor performance with an "OR" |
Rewrite Full Outer Join into Subquery |
unique | Question related to unique key |
update | Performing multiple updates and selects |
update subselect | calculating total products in each category |
upgrade | Upgrade from 5.0 to 5.1 |
Can replicating between versions cause crashed tables? |
Moving Mysql to a new server |
replication from 4.1 to 5.5 and character set change |
upgrade dual master | Master Master Replication Upgrade from 5.0 to 5.5 |
upgrade via dump | botched data post-upgrade |
user | MySQL users question |
Why doesn't root get full privileges? |
Revoke privileges from user issue! |
using index | InnoDB CPU Spikes |
Use of DISTINCT in INNER JOIN |
using index for group-by | Index optimized left join with group by |
utf8 | utf8 inputs store as html entities, how to retrievesubstr of utf8 inputs? |
Mixed encoded DB Latin1 & UTF8 |
Re: Korean characters displaying as ??? |
Storing UTF-8 strings in MySQL Database |
Character encodings issues with php, mysql, apache |
load data character set question |
Problem with Batch Import |
what is the step to convert a db from latin1 to UTF8 |
UTF-8 problem |
Require suggestion for changing character set in Master master replication setup |
Storing Hebrew strings Ok, but gibberish when pulling data on another server |
Migrating from latin1 to utf-8 |
problems with charset |
replication from 4.1 to 5.5 and character set change |
Windows: problem with unicode after update |
utf8 bom | Proper display of special latin1 characters in Powershell / MySql client ? |
utf8mb4 | Arabic text in mysql Varchar row |
Charset and Collation Question |
uuid | UUID as a primary key |
utf-8 uuid varbinary |
varchar | InnoDB log group capacity error |
Join Statement with math operation |
varchar index | mysql search performance |
varchar vs tinytext | VARCHAR vs. TEXT - some performance numbers |
varchar(255) | Outfile Using too much disk space |
variance | What is the SQL equvalance to VARIANCE |
vb6 text | How to store long string from VB6 to MySQL database |
version diffs | Simple performance question - differs on 2 computers |
version incompatibility | Need advice to Setup replication server (INNODB) |
vertical partition | JOIN vs Denormalize table vs Vertical partition |
JOIN, LIMIT, ORDER performance problems |
Error while creating the table in InnoDB |
Cascading deletes |
vertical partitioning | RAM requirements- new server |
Partition by threadid or postid? |
view | use index on a view |
view charset | Database migration failing. |
views | View insertion failing |
Can we expect an enhancement for derived table merge optimization? |
vista | perl script hangs on query with where clause |
wait_timeout | how much time can i set in wait_timeout in mysql(wait_timeout variable) |
Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003 |
MySQL 5.1.36 on FreeBSD 7.2 amd64/i386 not honoring wait_timeout |
MySQL Timeout |
Does a too many connections error always really mean it? |
Close conections |
Can the use of Ephemeral ports be disabled? |
web | Mysql RAM |
where | Problem with search when add BETWEEN to query |
wheres | write trim into INSERT and SELECT Queries |
Not working in MYSQL5.1 |
wide rows | Innodb with HUGE row of varchar(500)s |
width | Display Width Clarification (numeric data types) |
windows data dir | Where in the harddisk? |
Where are the databases? |
word boundary | help in select ... where ...like... |
wordpress | get info about a mysql call |
world db | online sample database to test MySqL queries against? |
wrap around table | combine this 2 simple querys into 1 query for performance. |
combine this 2 simple querys into 1 query for performance. |
wrong index | simple uses of order by datetime keep causing 'using filesort' |
x | 8 CPU Cores.....only 1 or 2 being used at the same time... |
xss | Two usefull functions(XSS/SQL injection). |
Text box security |
Assistance with securing input |
yashinori matsunobu | Disaster Recovery with master-master replication |
zerofill | Display Width Clarification (numeric data types) |
search for query that result one random url from domain |