| 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 |
| 1016 |
Replication error? |
| 1067 |
Erroe #1067 |
| How do I change this table to get it to load |
| 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 |
| 1364 |
MYSQL Error n4 1364 (authentication string no default) while configuring |
| 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 |
| 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 '/var/run/mysqld/mysqld.sock' (2) |
| MySQL Error Nr. 2002 |
| how do you fix error 2002 |
| Could socket failure be related to InnoDB errors? |
| MySQL startup - ERROR 2002 (HY000) |
| ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) |
| MySQL error, please help |
| ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) |
| 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 |
| help please |
| Converting Access to MySQL |
| MS Access transfer to MySQL on host server |
| Db access/privileges philosophy |
| Database Import |
| Microsoft Access & mySQL |
| Access 97 to MySQL |
| acid |
what's the purpose of InnoDB |
| How does MySQL ensure ACID nature of transactions ? |
| COUNT(*) very slowly in large InnoDB table |
| 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? |
| alter |
Table fragmentation and optimization |
| does innodb table need 'optimize table'? |
| Adding columns to live tables |
| Migrating from latin1 to utf-8 |
| Performing table inserts/selects while a alter-table query is running? |
| adding index to a table |
| Require suggestion for changing character set in Master master replication setup |
| Large table designissue |
| Will increaseing table size affect current data? |
| enable keys, force sort, not keycache |
| How to clean up database after deleting records |
| Reverse Index columns |
| 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 via copy |
Alter large table(MYISAM) |
| seeking for better solution to change indexed column size |
| Partitioning and multiple threads |
| analyze |
Mysql does not use index, even if example is trivial? |
| ANALYZE TABLE not working correctly |
| and2union |
Index structure |
| 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 |
upon retrieving the last insert id get the table name? |
| Snapshot Table -- over the long run |
| auditing changes via replication |
| Audit Trail Help...again |
| 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 |
| auto_increment |
Resetting Auto Increment? |
| 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 |
| Automatic field in a table |
| 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 |
| Suggestable Engine |
| 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 Enterprise Backup Remotely |
| mysql with innodb and myisam |
| MySQL Replication |
| Replicating a big db |
| 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? |
| best practice |
Real-world DB schema |
| between |
Slow query |
| big |
Questions about performance for huge table (100M+ rows) |
| use index on a view |
| MySQL Appropriate for 1T- 5T DW ? |
| Up to 1 million rows Performance + Design Help |
| About performance for Database of millions of records |
| How to scale MySQL Cluster to support PB storage |
| A lot of rows for a very specific task |
| 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 |
| STORE FINGER PRINT IN MYSQL |
| MySQL blob performance |
| block splits |
Row size computation |
| book |
Getting started, need WINDOWS information |
| Is MySQL the tool I need? |
| Online/Free Book Recommendations |
| Kimball book recommendations & Schema question |
| book recommendations |
Any tips for an MS SQL DBA trying to break into MySQL? |
| Reading list suggestions for query skills |
| 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 |
| 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 |
Linking to a LUT more than once |
| re writing database |
| cannot connecct |
Unable to connect to database: Can't connect to MySQL server on '[database server]' (4) |
| case range |
Optimizing a Query on a Very Large Table |
| changelog |
auditing changes via replication |
| How much data to save |
| 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 |
| charset |
Can replicating between versions cause crashed tables? |
| cannot change character set |
| Weird utf-8 encoding problem using webserver that does not occur in command line client |
| Converting latin1 charset to utf8 |
| Having tough time with spanish/catalan characters in my PHP/MySQL app |
| MYSQL doesn't 'see' accents |
| Problem inserting german and french characters |
| 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? |
| 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 |
3 Table Join (indexed) results in where-temp-filesort |
| Portal Database design help |
| I have queries that sporadically take a very long time |
| Performance with select query that joins two tables one with 45MM and another with 12MM |
| Any way to optimize join to find rows without conditional foreign rows? |
| JOIN, LIMIT, ORDER performance problems |
| clone slave |
Moving dbs to new server |
| replication - slave copy - unclear points |
| cloud |
partioning question |
| cluster |
Query optimization question |
| MySQL training on Cluster and High Availability |
| collation |
Will changing Default Collation on live BSD box cause any problem? |
| Unproper order of sorting in utf8. Collation? |
| "Duplicate entry" error using utf8_unicode_ci |
| A tip: Avoiding implicit charset matching errors |
| collation on sp |
Illegal mix of collations |
| comma |
Setting up some new tables |
| Split Values by comma and Check in another Table? |
| arrays or joins for multiple values? |
| search comma separated db column |
| parse by delimiter and search a data field? |
| Iterating through SQL table |
| Column for mutiple and not-predefined 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. |
| Multi-Column indexes |
| Index on Datetime Col is not used When Where Clause combines two or more predicates |
| computer science |
Delete Query |
| concat |
CONCAT Dates returning "BLOB" or '?' |
| conditional average |
sum and display issue |
| connections |
mysql max_connections |
| Database Pool Size |
| 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 |
MySQL + 2 x Intel Xeon (6 cores) performance problem |
| Why does MySQL's performance decrease when queries are executed in parallel? |
| Queries on MyISAM |
| Intra-Query Parallelism in MySQL Server |
| Something awfull with latest mysql on latest FreeBSD |
| Help make my big new server fast |
| Maximize MySQL Performance on DBT2 Benchmark with Virtualization Technology on T5240 Server |
| InnoDB Plugin Version 1.0.3 for MySQL 5.1.30/31/32 Released |
| The result of MySQL's high concurrency and very large data performance benchmark. |
| count |
COUNT(*) very slowly in large InnoDB table |
| Alternative to FOUND_ROWS() |
| any faster select count(*) |
| count(*) caching |
count(*) speed in InnoDB |
| covering index |
Strange performance with JOIN/COUNT |
| cpus |
MySQL 20x faster on RHEL 4 over Solaris 10? |
| crash |
Replicating server has died |
| critical read |
MySQL Master(Active) - Master(Active) Replication |
| separate the Query and direction |
| Three Node Replication (US West, US East and Europe) |
| csv |
Export Recordset query to a file nightly? Ubuntu and MySQL |
| 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 warehouse |
mysql TABLE tuning and performance |
| Inserting 5000 samples per sec in real time |
| Slow Inserts |
| Online/Free Book Recommendations |
| Database Design for huge set of data |
| Kimball book recommendations & Schema question |
| Query optimization or better table design? |
| innodb or myisam for logging |
| database |
One big DB or two not-too-big DBs? FKs across DBs are slower? |
| 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 |
| date |
Query Question |
| MySQL Date Query issue |
| how to convert timestamp value to string in MySql |
| UPPER with substring is not working |
| 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 |
| datetime |
Time series database design |
| Calculating TIME ELAPSED SINCE in days OR hours OR minutes |
| 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 |
| deadlocks |
lock block deadlocks |
| decimal |
size of Decimal(18,4) |
| Is it possible to get MORE results by adding an AND clause to a SQL query? |
| 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 |
| delete |
mysql very slow after million insert/delete |
| Statement/row questions |
| Replication lag when no primary key on InnoDB |
| 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 |
| 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 |
| disk hits |
delete timing-feasible? |
| disk usage |
Old databases that are no longer required |
| 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 |
| dual master |
MySQL settings for multiple server setup |
| Replicating server has died |
| Multi Master and Slave MySQL servers |
| What is Best solution for DR and 24*7 using two identical systems, cluster is not available here(hw) |
| MySQL Master/Master Replication |
| 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 |
| MySQL & SAN |
| 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 |
How to speed up Query with WHERE AND/OR, with Subqueries using IN |
| Searching by using an index table, efficient queries? |
| Different data types |
| User defined fields in a schema |
| edge list |
relationship query question |
| either but not both |
Compare two tables |
| entities |
Circular reference |
| Simple Database Design Problem |
| Database Structure Help |
| Learning Management System MySql Database design |
| enum |
using enum as means of compression |
| <char dimension with charset UTF8> |
| ENUM columns and blank values |
| enum trick |
Correcting spelling errors in an ENUM definition |
| er |
Circular reference |
| Designing a forum - general design logic question |
| Database Structure Help |
| Simple Database Design Problem |
| Data model metadata design and data driven joins |
| Database efficiency question |
| Searching by using an index table, efficient queries? |
| Modeling and Normalizing |
| Lookup Table with Optional Fields? Null primary key for blanks? |
| school exercise I am suck on |
| Learning Management System MySql Database design |
| My First Database (HELP) |
| DB structure - Managing a collection of books |
| erd |
ERD Design HELP! |
| error 150 |
query not running |
| error 24 |
Replication error? |
| escaping |
replacing (escaping) unescaped apostrophes already in mysql |
| "#" symbol inside text of databse |
| delete query doesnt work with php |
| How do I assign unique id to call data? |
| ethernet |
connect 46 pcs on my pc MySql server |
| etl |
uploading 300+MB files to MySQL db |
| Update more than 30,000 records row by row |
| 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 with table |
Is there a SWITCH equivalent in MySQL? |
| exit handle |
Transaction won't end |
| expand and contract |
Question about LIMIT |
| explain |
Slow select with sub queries |
| Help optimizing query/index |
| greatest-n-per-group performace for different data types |
| understanding towards Using where; Using temporary; Using filesort is right? |
| failover |
Mysql 2 server replication setup with fail over |
| Switching to backup DB on error |
| 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 |
| filesystem |
databases and log files on separate hard drives |
| file_per_table |
TableSpace |
| All Innodb tables using seperate ibd, but ibdata1 still being modified? |
| filing cabinets |
random reads |
| find id hole |
How to create a solid sequence? |
| first partition |
I searched table on one partiton, but MySQL scanning two partitons |
| first slave |
Initial setup of replication with large tables |
| Start slave fails |
| Setting up replication in a Windows Sever 2003 environment |
| 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? |
| float |
Bug in the floating point value |
| Math function logarithm |
| Is it possible to get MORE results by adding an AND clause to a SQL query? |
| for update |
table locking |
| foreach |
write trim into INSERT and SELECT Queries |
| foreign key |
Error 1005 Errno 150 |
| dropping a foreign key constraint |
| Why use JOINS when have FK |
| ERROR 1005 (HY000): Can't create table 'Azienda.#sql-697_c9' (errno: 150) |
| Soln. for MySql 1005 (Can't create table) |
| Multiple references of a PK |
| 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() |
| fragmentation |
does innodb table need 'optimize table'? |
| Performance increased after mysqldump restoration ? |
| Table fragmentation and optimization |
| fulltext |
match against search won't match strings with a forward slash in them |
| accent sensitivity in fulltext search |
| Seeking advice on setup |
| Cascading deletes |
| Using FULLTEXT index with a boolean on the matched field? |
| 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 |
Creating a restricted user account |
| remote access and privilages |
| MySQL users question |
| Revoke privileges from user issue! |
| User password being modified as a result of grant statements? |
| Make Table or Catalog Read Only |
| How to change mysql username from "root" to "apps" |
| Re: Can't seem to create a new user account |
| HOW DO CREATED USERS LOG ON MySQL CLI? |
| One big DB or two not-too-big DBs? FKs across DBs are slower? |
| Why doesn't root get full privileges? |
| grant host names |
connect as remote server |
| Can't connect with non-root user to created database |
| group by |
problem with concat() distinct() min() and GROUP BY |
| distinct vs. group by |
| Unsure about query... random column? |
| MySql 4.1 optimization search poor performance |
| Noob query issue |
| using GROUP_CONCAT |
| group by trick |
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 |
| How does group by algorithm works? |
| Subquery and JOIN's |
| limiting rows returned |
| max function |
| Listing threads by newest posts? |
| Complex Select with Min/Max Syntax |
| Help with minimum/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 |
GUID field |
| How can I decide which partition type can I chose |
| SELECT took lengthy of time |
| 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 |
| hierarchy |
select max date in Inner Join |
| Building a widget/graph from mysql view |
| Unary many-to-many relationships |
| relationship query question |
| Return the level and count of a closure table. |
| highwater |
Milli and Micro seconds in mysql |
| hints |
Intermittent slow performance |
| history |
MAX_ROWS on Partitions |
| New to design; how to optimize 3 column single table with high I/O? |
| Mysql cluster 7.1.5 can't use table partition! |
| Snapshot Table -- over the long run |
| holidays |
Query results from one table against a list created by another |
| horizontal partitioning |
RAM requirements- new server |
| hosts file |
How to troubleshoot slow response from MySQL |
| Slow connection |
| 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 |
| ibdata |
How do we resize ibdata file? |
| ibdata1 |
After creating tablespace .ibd, Mysql doesnot start |
| Switch to file_per_table using a slave |
| TableSpace |
| 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 |
| ibdata1 contents |
ibdata1 and undo log |
| iblog |
Connection lost |
| Different ibdata files for every database |
| id |
Real-world DB schema |
| 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 |
| 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 |
| in |
PHPMYADMIN hangs on this query!.HELP!!!! |
| Why isn't an index being used here (nested query) |
| Efficient string comparison to a group of values |
| 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 |
Re: max(DateField)+C <> max(DateField+C) |
| Moving Mysql to a new server |
| index |
Help with optimize SELECT |
| DATETIME vs. INT(11)? |
| Creating an Index |
| how to optimize this query |
| Slow query on very large table |
| how to solve this complex query |
| Mysql does not use index, even if example is trivial? |
| Does LIMIT 1 without ORDER BY ID bring the record with minimum ID? |
| Preferable Index Length |
| How does index perform with LIKE? |
| Re: Large range query stops using indexes |
| index selection |
| Help optimizing query/index |
| making a row unique |
| GEO Search with large table is very slow |
| Order by using filesort on where |
| Advice on redundant indexing |
| does unique index do more than just being a constraint? |
| Statistics used by optimizer. |
| Concat Occasionally Drops a Character or Two |
| 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 |
| Statistics |
| Need help on indexing |
| Primary key - link to data ? |
| 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 |
| Estimating Index Size on Innodb Tables |
| Join Statement with math operation |
| Problem with a query performance |
| Best primary key or index |
| physical bytes |
| Stop using filesort |
| Partition on day of year |
| Table marked as crashed and last (automatic?) repair failed |
| 11 millions records : more than 30 seconds to retrieve simple request |
| Slow query with order by and limit |
| Huge row size compared to MyIsam |
| CREATE TABLE ignores DATA DIRECTORY option |
| Need Database Structure Help |
| indexing |
| Index recomendations |
| Size of INDEX_LENGTH is higher than DATA_LENGTH ! |
| 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 join |
ideal indexing for inner join, rowcount of 1 |
| 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 |
| information schema |
Wrong info from Information_schema |
| SHOW VARIABLES: which table holds my.cnf startup varibles? |
| information_schema |
creating data dictionary |
| Procedure is not working |
| init_connect |
Encoding problem |
| injection |
Unique Constraint Using My Own Definition of "Equals" |
| inner join |
Optimizing query |
| innodb |
Alternative to FOUND_ROWS() |
| Reduce Index space |
| mysql very slow after million insert/delete |
| slow queries and high % of wait I/O |
| evaluating table locking |
| ANALYZE TABLE not working correctly |
| AUTOINCREMENT & ROLLBACK |
| Insert into table on duplicate key update - performance issue |
| Negative consequences of converting to InnoDB? |
| Does LIMIT 1 without ORDER BY ID bring the record with minimum ID? |
| New to design; how to optimize 3 column single table with high I/O? |
| Huge row size compared to MyIsam |
| Replication lag when no primary key on InnoDB |
| COUNT(*) very slowly in large InnoDB table |
| 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? |
| 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 |
| innodb fulltext |
MySQL 5.6: InnoDB Full Text Search (FTS) |
| innodb index |
problem about second index on innodb |
| 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 settings |
Innodb_buffer_pool_pages_free = 0 |
| innodb vs myisam |
Innodb v/s Myisam |
| InnoDB to MyISAM Disadvantages? |
| 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 |
| 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" |
| innodb_log_file_size |
Correctly setting mysql options for a huge DB with intense trafic |
| Switch off InnoDB logging - Possible? |
| innodb_log_file_size |
| Unexplained drop in performance? |
| values in my.ini for 2GB RAM |
| Reset Root Password causing ib_logfile issues |
| 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 |
| 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? |
| Slow query |
| Help with the best table layout for message board |
| ip range |
Keys ignored for larger tables!? |
| How can I optimize this query? |
| update big table cause an excution time out |
| optimize IP range join: postgresql is 496 times faster |
| Optimize IP Range Join |
| iterative update |
Updating 100 million record tables |
| java time |
Storing Java Timestamp (long) in database as BIGINT? |
| join |
Join Syntax Confusion |
| JOIN, and LEFT OUTER JOIN: I don't get it |
| After upgrade from 4.1.22 to 5.1.44 query not working |
| tables, joins or not, to script or not |
| nested select |
| INNO DB performance problems with temporary tables |
| trouble figuring out joins, any gurus out there? |
| PHPMYADMIN hangs on this query!.HELP!!!! |
| JOIN table USING vd JOIN table ON table_field=another_table_field |
| Some general questions |
| 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 |
"Optimizing sub queries with joins" |
| Faster SQL - newbie needs help |
| json |
User defined fields in a schema |
| key value |
Large number of columns causing - Unknown Error |
| table/query help |
| linked data |
| Query Optimization |
| How best to storing User Profile data |
| Help collating multiple rows from multiple tables into a single row |
| Data model metadata design and data driven joins |
| How to speed up Query with WHERE AND/OR, with Subqueries using IN |
| Create tables: Shall i use one table or different tables in order to store data? |
| key-value |
User defined fields in a schema |
| key_buffer |
Key_Buffer_Size |
| mysql max_connections |
| Processor at 99.9%, memory at 5%. Configuration help? |
| Queries slow down daily, optimizing helps -> why? |
| large multiple table update taking a very long time, help! |
| 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 |
Having an argument about table design |
| “CACHE INDEX” and “LOAD INDEX INTO CACHE” |
| last_inserted_id |
How do I combine 3 queries into one |
| last_insert_id |
Transaction deadlock with many threads |
| Select and update at the same time (with selected value)? |
| Update query problems |
| Looking up a value in a 'subtable' and inserting it if it doesn't exist |
| lat lng |
How to improve query performance in expression related order by? |
| Slow select on table with 1.8 million rows (filtering on lng/lat) |
| lat-lng |
select query in from clause creates problem |
| 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? |
| Help with Join Query |
| Help with query with conditions |
| need help with cross referenced tables |
| 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 |
| limit |
MySql 4.1 optimization search poor performance |
| index performance on "limit" condition |
| Index not working as I expect |
| Using LIMIT in a SELECT statement which does a JOIN |
| limits |
Maximum Constraints Per Table |
| Data object standards |
| Max quantity users in MySQL |
| Storage capacity |
| 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 |
need to upload .txt to SQL table. |
| loading data problem |
| Append with LOAD DATA INFILE |
| Load Infile - Not able to import microsecond level datetime from CSV |
| CSV import with mysqlimport |
| load data expression |
Mass Import Innodb |
| 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 |
Help with locks |
| Are queries queued? |
| Solving table locking issues |
| lock block deadlocks |
| log sequence |
Index not used in certain DELETE-queries? |
| log-slow-slave-statements |
Replication server is running behind |
| login |
MySQL on Ubuntu mess...pls. help |
| Need Help - Server was hacked |
| Mysql and CentOS 5.2 |
| login access |
Access |
| logs |
mysqldump for BLOB?, InnoDB log files? |
| 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 |
Select query too slow from merge table of 1 billion records |
| Cursor usage with Prepared Statements |
| lots of tables |
MySQL 4.1 to 5.1 large scale upgrade |
| lower |
Using DECODE with SELECT and LIKE |
| maatkit |
How to know if a slave is identical to his master ? |
| mac install |
Problems creating my.cnf / options file |
| many tables |
tables per company - why not |
| many-to-many |
Need help on designing simple db |
| many:many |
Bulk data question |
| 1 to many and many to many help |
| Learning Management System MySql Database design |
| Unary many-to-many relationships |
| 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 |
| 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) |
| max_connections |
Question on max_connections |
| Does a too many connections error always really mean it? |
| Both master and slave stop accepting connections |
| How to get MySQL concurrent query nos. |
| Debugging too many connections |
| max_connection |
| 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 |
| md5 |
Fastest way to check for an image in a table |
| SHA-256 which data type is the best? |
| How should I make text column search faster? |
| 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 |
Anybody met this errors :Out of memory (Needed 16777224 bytes) ? |
| InnoDB log group capacity error |
| Slow Updates on Memory table - (detailed) |
| how to estimate the real mysql memory consumption? |
| Optimising max_heap_table_size & tmp_table_size |
| mha |
Setting up Circular replication in existing replication infrastructure |
| Disaster Recovery with master-master replication |
| middle |
regexp challenger |
| Another Complex Query |
| milliseconds |
Date/Time Query |
| Milli and Micro seconds in mysql |
| mixed replication |
Replicating from innodb server to myisam server |
| 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 |
| 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 |
| 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 |
| 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 |
| myisam |
random reads |
| 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 |
Database effeciency |
| should i go with myisam or innodb? |
| 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? |
| mysqldump |
How To bakcup Databse per table ? |
| Aborting Optimize Table for Innodb |
| stored procedures and functions |
| backup database |
| MySQL Backups - Innodb |
| Partition-wise mysqldump backup script at MySQL Forge |
| what should i do when backup ? |
| Best Prctice export from MySQL 5.1 to 4.1 |
| 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 |
| 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 |
| newbie |
building tables |
| nondeterministic replication |
A qq reg SBL with current_timestamp() |
| nor |
indexing on every column? |
| normalization |
Insert keys from 1 table into 2 others. |
| Newbie Normalization Question |
| select * where value>1 |
| How do I count the number of rows with certain data |
| Design of tables |
| ERD Design HELP! |
| Is my database normalized? |
| 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 |
| numa |
Poor performance of MySQL 5.5 |
| 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 |
| open file limit |
max_open_files error |
| optimize |
does innodb table need 'optimize table'? |
| optimize table |
Optimize table statement |
| optimizer_search_depth |
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 |
Query Optimization - order by |
| unique ID field, getting next and previous existing ID from table |
| Re: MYSQL Sorting IN by orignal order? |
| distinct vs. group 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 |
Jet Profiler says I'm slow.... |
| break mysql query? Is this possible in my sql |
| MySQL Performance Tuning on my server |
| Heavy task on mysql by AJAX Pagination? |
| Use of memory table vs temporary table question |
| Showing recordsets from tables with one (main table) to many (secondary table) relationship |
| Efficient MySQL for pagination of large amounts of data on website |
| Query performance question (using index slows down?) |
| join in union |
| Query performance on database with joins |
| Query that returns indexed fields involves FILESORT, why? |
| Very Slow Simple Query |
| Slow search query |
| Alternative to FOUND_ROWS() |
| pagination - precalc |
Handling Large Datasets |
| pairs |
Query To Find the Number of Self-Joins? |
| parallel |
Performance LONGTEXT / LONGBINARY |
| large multiple table update taking a very long time, help! |
| parallelism |
Intra-Query Parallelism in MySQL Server |
| partition |
Table partitioning |
| How to create partition on existing table? |
| Open tables with Partitioning |
| MAX_ROWS on Partitions |
| Improving Slow Query |
| How to handle secondary keys in partitioning? |
| Exceptions with Partition Pruning |
| How can I decide which partition type can I chose |
| Partition-wise mysqldump backup script at MySQL Forge |
| Partitioning with range(to_days) issue |
| How to partition my table |
| MySQL performance help |
| partition add drop |
Using MySQL Partitioning Instead of MERGE Tables |
| partition by day |
Problem with granularity choosen |
| Add new partition for Range by date |
| 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? |
| pdf |
MySQL blob performance |
| pem |
SSL error: Unable to get certificate from '/etc/mysql/newcerts/client-cert.pem' |
| percentile |
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) |
| Why I can't insert more than 100,000 rows in a script?(mysql+php) |
| perf |
slow queries and high % of wait I/O |
| Statement/row questions |
| Any way to optimize join to find rows without conditional foreign rows? |
| Very slow DELETE, UPDATE, INSERT on a new server |
| random reads |
| performance_schema |
MySQL Performance Schema: Overview |
| 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 |
| phones |
Creating a variable variable name |
| printing fetched values |
| php |
Storing Special Characters in Table |
| php build where |
mutiple field query |
| php file upload |
How insert data in table using a .txt file |
| php install |
Error when trying to configure PHP to work with MySQL |
| Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions |
| php mysql_fetch_array |
PHP access not working right |
| phpmyadmin |
cannot change character set |
| piping |
Store dump from DB on Server A to Server B (File) and test restore on C |
| pivot |
insert 0 when combing tables? |
| Pivot tables |
| Cross-table in stored procedure |
| Need help with a Query....cross tab format |
| Pivot Table Rows into Columns stored procedure |
| 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 |
| 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 |
| 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 |
A fast (>0.01s) query sometimes slow (>2s) |
| Understanding the Query Cache and the Innodb_buffer_pool??? |
| Queries slow down daily, optimizing helps -> why? |
| Query Cache Causing High CPU Load |
| Query cache was never filled up |
| Poor performance of MySQL 5.5 |
| Why is my entire database getting locked for a slow select query? |
| query cache no |
MySQL 5.5 and Query Cache |
| 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 |
| InnoDB and separated disks |
| CREATE TABLE ignores DATA DIRECTORY option |
| raid controller |
Inserts very slow |
| ram |
MySQL eats all of RAM memory |
| rand |
evaluating table locking |
| small DB, big problems |
| select limit records from 600000 records |
| rand() to randomize rows only once daily |
| random |
random sorting - what is the quickest method? |
| Horrible performance on BLOB's when using WHERE or ORDER BY |
| random dives |
Analyze question |
| random fetch |
Very Large Non-Dynamic Table for Lookups |
| random id |
best way to generate a random unique id |
| range |
Simple Query -- Needs to be Mind Numbingly Fast! |
| Select * from MyISAM table returns PK order / filesort order |
| ranges |
I want to write a user-defined Aggregate Function |
| What Method is Best |
| rank |
your ranked out #x of X accounts? |
| RANK() emulator? |
| rbr |
Row based Replication: Deadlock is not rolled back |
| rdf |
linked data |
| About performance for Database of millions of records |
| read committed |
MySQL Backups - Innodb |
| read-write separation |
Forwarding writes to master |
| recovery |
Restore InnoDB schema from partial backup |
| 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 |
| 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? |
| Error Duplicate entry - Master-Slave replication |
| update slave after failover |
| replication or mirroring? |
| Need advice to Setup replication server (INNODB) |
| Replication problem |
| Can't restart slave - Could not initialize master info structure |
| Upgrade from 5.0 to 5.1 |
| Replication multiple database |
| 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 |
unable to create database even as root user |
| Setting up root password |
| resignal |
Stored procedure, stored function and signals |
| resize |
Different ibdata files for every database |
| result caching |
Memory Allocation error |
| resultset |
Question: Technical Background Of The Result_Set |
| 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 |
word index - is there a better solution? |
| Skyblog, Friendster, twitter, yahoo mail..... how to design database for huge no. of users and rows |
| design distributed database |
| scaling via slaves |
Three Node Replication (US West, US East and Europe) |
| schema |
Where to find a tool for differences between two database structures |
| select query not using indexes |
| Up to 1 million rows Performance + Design Help |
| I have queries that sporadically take a very long time |
| 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 |
Actual Newbie Question with mysql connect |
| Database Encryption |
| Changing Plain Text Passwords to Hashed Passwords |
| Replciation Security |
| 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 |
| sequence |
Last/highest ID? |
| Record Position in Ordered Selection |
| Unique columns over two tables |
| A sequence solution for those that want it |
| 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 ??? |
| Data is being in non readable format. |
| import utf8 to latin |
| load data character set question |
| set names utf8 |
Encoding problem |
| Problems with Spanish characters |
| sets |
Help with query... |
| setup slave |
New to MySQL Replication |
| sharding |
performance: sharding and replication ideal? |
| sharding steps |
| When do I start... partitioning? |
| Are there any pitfalls with having multiple MySQL databases on 1 server node? |
| Skyblog, Friendster, twitter, yahoo mail..... how to design database for huge no. of users and rows |
| How to scale MySQL Cluster to support PB storage |
| Database Sharding at Netlog, with MySQL and PHP |
| 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 |
skip-name-resolve and access issues |
| [SOLVED] Can't connect to remote server |
| slam |
Help collating multiple rows from multiple tables into a single row |
| slave |
PURGE BIN LOGS FILES NOT WORKS |
| slave initialization |
Quick replication questions |
| 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 |
use index on a view |
| Slow Mysql optimizer |
| 350+ million rows -- is this as fast as it can get? (too slow at the moment!) |
| my system usage hits 100% at every 6 hours. |
| Slow search query |
| select query not using indexes |
| 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 |
| Faster dump using mysqldump |
| Mysql SAN Related Scenarios |
| snodgrass |
Time series database design |
| social search |
Theoretical Database Table Structure |
| socket |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) |
| MySQL Socket Error |
| 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 |
| speedup |
I need Optimizaton of a Query - DISTINCT |
| sql injection |
Two usefull functions(XSS/SQL injection). |
| Numbers Vs. Characters in MySQL Database |
| Assistance with securing input |
| Multiple databases |
| Text box security |
| $_POST Help : |
| SQL Injection |
| Multi user issue |
| sqlexception |
Transaction won't end |
| sqlite |
Convert MySQL to SQLite |
| sqlserver |
Switching from Sql Server |
| sql_calc_found_rows |
Query that returns indexed fields involves FILESORT, why? |
| full table scan for limit?? |
| resultset rows performance |
| sql_slave_skip_counter |
Replication Errors on Slave DB |
| ssl |
Failed to Setup SSL warning |
| SSL error: Unable to get certificate from '/etc/mysql/newcerts/client-cert.pem' |
| ssn |
field types syntax |
| start_time |
Index on datetime type |
| start_time end_time |
Query not using index |
| stateless html |
When to open/close the MySQLConnector |
| stddev |
What is the SQL equvalance to VARIANCE |
| stopwords |
FULLTEXT search failing |
| stored procedure |
MySQL Stored procedure Tutorial |
| 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 |
Datetime conversion fails |
| Need to Convert Date Time at Query runtime |
| subquery |
100% cpu usage on single cpu core |
| nested select |
| tables, joins or not, to script or not |
| slow query in Inndb |
| Get statistics using self joins |
| Please help with slow easy query |
| Performance of WHERE EXISTS query |
| Partition on day of year |
| subquery can help |
Strategy needed for picking random rows |
| Simple JOIN is extremely slow. |
| Optimizing it even more |
| subquery to join |
How kan I optimize this Code? |
| summary |
views, unions and different dbs |
| Database Design for huge set of data |
| Very long query doubt... (Monster query...) |
| Large Table Architecture |
| Storing a large, dense tensor (35gb scientific data) -- is mysql appropriate? |
| Index performance |
| Thinking about sorting articles.. |
| Slow 'sending data' phase on mySQL query, for simple query |
| UNIX_TIMESTAMP Duplicate key |
| Multiple complex queries |
| Partitioning with range(to_days) issue |
| Large table designissue |
| should i go with myisam or innodb? |
| Design approach for summary table by 3 items |
| compressing tables |
| Counters |
| InnoDB CPU Spikes |
| Slow JOIN to convert IP to Country Code |
| Best way to store/access large amounts of data? |
| summary table |
Bitmap Index |
| To store or calculate on the spot? |
| summary tables |
Killed by joins. 1 minute selects in Access, 15 minutes in mySQL |
| Which storage engine? |
| Solving table locking issues |
| super freaking |
select with join of 25 tables crashes mysql database |
| surrogate key |
Primary key for referee table. |
| swap |
Basic Standards of Mysql server variable setting |
| Regarding use of swap memory for MySQL. |
| swapping |
Very Slow Simple Query |
| symlink |
Different data directories for different databases? |
| table design |
DB Design - Users Table |
| table lock |
SELECT queries Locking Problems |
| table name case |
Case Sensitivity for View Names |
| table of ints |
select dates in a month that fall on a given day of the week |
| table scan |
Question on bad execution plan |
| Optimising a GROUP BY and ORDER BY in a joined query |
| full table scan for limit?? |
| Select * from MyISAM table returns PK order / filesort order |
| field equal to OR between 2 fields? |
| tablespace |
How to create TableSpace |
| 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 |
| temporary table |
Storage engine used by temporary tables |
| text |
large multiple table update taking a very long time, help! |
| InnoDB log group capacity error |
| TINY TEXT vs Varchar(240) and TEXT vs Varchar(300-500) |
| 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 vs datetime |
DATETIME vs. INT(11)? |
| #1452 - Cannot add or update a child row: a foreign key constraint fails? |
| timezone |
Mysql ADDTIME can it do this ? Daylight savings time issue |
| ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist |
| Curdate() returning one day old date |
| timestamp column behavior |
| DST and UTC_TIMESTAMP |
| How to time sync MySQL with system time |
| converting timezone for data in specific table |
| TIMESTAMPADD and Daylight Savings Time issue??? |
| 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 |
question about create a table |
| /tmp folder getting filled with #sqlXXX.MYI and #sqlXXX.MYD files |
| how to solve this complex query |
| 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 |
Selecting max for each day |
| Top n Scores |
| 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 |
| transcoded column |
specific collation issue |
| transcription |
Checking for exact match in row |
| transpose |
Query Slowness |
| tree |
Building a widget/graph from mysql view |
| Multi Level Sorting - Queries Question |
| Modifed Preorder Tree Transversal Child Roll Up (including grandchildren) |
| 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 |
Optimal Mysql Configuration (my.cnf) |
| MySQL Performance Tuning Help |
| High CPU use (spikes) and Page Faults in VM |
| MySQL Performance Tuning on my server |
| 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 |
| Opinions on this schema please =) |
| N-to-N Model: Table Size vs Complexity |
| Slow query - help me optimize ? |
| INNO DB performance problems with temporary tables |
| join in union |
| Poor performance with an "OR" |
| unique |
Question related to unique key |
| update |
Performing multiple updates and selects |
| update subselect |
calculating total products in each category |
| upgrade |
replication from 4.1 to 5.5 and character set change |
| Moving Mysql to a new server |
| Can replicating between versions cause crashed tables? |
| Upgrade from 5.0 to 5.1 |
| 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 |
| utf8 |
replication from 4.1 to 5.5 and character set change |
| problems with charset |
| Migrating from latin1 to utf-8 |
| Storing Hebrew strings Ok, but gibberish when pulling data on another server |
| Require suggestion for changing character set in Master master replication setup |
| what is the step to convert a db from latin1 to UTF8 |
| Problem with Batch Import |
| load data character set question |
| Character encodings issues with php, mysql, apache |
| Storing UTF-8 strings in MySQL Database |
| Re: Korean characters displaying as ??? |
| Mixed encoded DB Latin1 & UTF8 |
| utf8 inputs store as html entities, how to retrievesubstr of utf8 inputs? |
| UTF-8 problem |
| utf8 bom |
Proper display of special latin1 characters in Powershell / MySql client ? |
| utf8mb4 |
Arabic text in mysql Varchar row |
| uuid |
UUID as a primary key |
| utf-8 uuid varbinary |
| varchar |
Join Statement with math operation |
| InnoDB log group capacity error |
| 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 |
Cascading deletes |
| Error while creating the table in InnoDB |
| JOIN vs Denormalize table vs Vertical partition |
| JOIN, LIMIT, ORDER performance problems |
| vertical partitioning |
Partition by threadid or postid? |
| RAM requirements- new server |
| view |
use index on a view |
| view charset |
Database migration failing. |
| views |
View insertion failing |
| vista |
perl script hangs on query with where clause |
| wait_timeout |
MySQL Timeout |
| Close conections |
| Does a too many connections error always really mean it? |
| MySQL 5.1.36 on FreeBSD 7.2 amd64/i386 not honoring wait_timeout |
| Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003 |
| how much time can i set in wait_timeout in mysql(wait_timeout variable) |
| web |
Mysql RAM |
| where |
Problem with search when add BETWEEN to query |
| wheres |
Not working in MYSQL5.1 |
| write trim into INSERT and SELECT Queries |
| 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. |
| x |
8 CPU Cores.....only 1 or 2 being used at the same time... |
| xss |
Assistance with securing input |
| Two usefull functions(XSS/SQL injection). |
| Text box security |
| 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 |
