Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 3417

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

0
votes
1answer
points. I need to add an auto_incrementing number outside the primary key/partitions, but I am concerned about how MySQL will be able to keep the right sequenced number, if under the hood, all partitioned … tables are in essence different tables and as that auto_incrementing number cannot be in a separate unique index. So the question is, will I get consistency issues with the sequence doing this or does MySQL have a way to keep it accurate? …
asked Oct 9 by Jonathan
1
vote
RBR basically updates the slave with the entire row as it is after it has been inserted/updated and updates using the primary key of the table. The advantages to this over statement is if the master …
answered Oct 9 '11 by Jonathan
3
votes
You can use symbolic links with MySQL. All you would need to do is make a symbolic link for the .frm, .MYI and .MYD files of your MyISAM tables into the MySQL database schema directory that you want … . After that, run flush tables; and they should show up. It is also important that the MySQL user is able to access those files, so you might have a bit of an issue with user rights. Also, depending …
answered Sep 19 '11 by Jonathan
3
votes
, then you can use 2 tools to make it an "online" alter table. One if from facebook https://www.facebook.com/notes/mysql-at-facebook/online-schema-change-for-mysql/430801045932 And one is from … openark http://openarkkit.googlecode.com/svn/trunk/openarkkit/doc/html/oak-online-alter-table.html (MySQL 5.1+ only) Both these tools basically create a new table, copy the data over and keep it updated …
answered Sep 25 '11 by Jonathan
1
vote
Your new slave server can possibly be slow in some respect and not able to process the queries in the binary log as quickly as the other servers. You should also look at the possibility that you may …
answered Sep 14 '11 by Jonathan
19
votes
Yes, there is. Put this in your my.cnf file: replicate-rewrite-db="dbname1->dbname1test" See Replication Slave Options and Variables: replicate-rewrite-db
answered Sep 17 '11 by Jonathan
6
votes
To switch binlog_format at runtime you can do: set global binlog_format = 'MIXED'; This will set all NEW sessions to be mixed binlog format. All existing sessions will be whatever was set previousl …
answered Sep 27 '11 by Jonathan
2
votes
You need to find out first what makes the load get too high so that you are able to plan ahead. If its IO bound then you need faster disks. If its memory bound then you need to add more memory or fi …
answered Sep 27 '11 by Jonathan
1
vote
I would suggest this, but please test it before running on some sample data: UPDATE animal_table t1 inner join animal_table t2 ON t2.category_id = t1.category_id AND t2.sumary_id = t1.summary_id AN …
answered Sep 27 '11 by Jonathan
3
votes
It probably means that you ran a lot of commands that start with "SET something = somethingelse;" I would say to set your general_log on for a short while on your dev environment and search for SET c …
answered Sep 14 '11 by Jonathan
4
votes
I would say to try to use a different storage engine like InnoDB. It sounds like you were using MyISAM which isn't crash safe. If you want to continue using MyISAM and it crashes in the future, you c …
answered Sep 14 '11 by Jonathan
1
vote
Have you considered using an ETL tool like http://www.pentaho.com/ for this? Sounds ideal..
answered Sep 14 '11 by Jonathan
3
votes
Sphinx or Lucene. You can alternatively, create an additional column with a hashed version of another and as long as its 1000 bytes or less, then it can be indexed by MySQL. I hope I have answered your question. …
answered Sep 14 '11 by Jonathan
1
vote
I think what you need to do is: mysqldump -u[username] -p[password] -h[hostname] --databases [database] | gzip > [backup file path].sql.gz or mysqldump -u[username] -p[password] -h[hostname] --all …
answered Jun 7 '12 by Jonathan
1
vote
MySQL would query every partition one-by-one until it answers the query. So if you query a partitioned table on a column that it is not partitioned on, you may get slower results then if the table was …
answered Feb 12 '12 by Jonathan

15 30 50 per page