Questions tagged [MySQL] (11512)

6
answers

Geographically distributed MySQL

Welcome all. There is a desire to geographically distribute the project, and start with one of its components: MySQL. Interesting answers are those who have worked closely with this database and not in theory knows how to operate various schemes geographically distributed balancing. The current scheme like this: one web s...
anastasia_McCullough67 asked October 14th 19 at 12:29
1
answer

How to migrate a database with indexes and foreign keys from MySQL to HSQLDB?

At the base of approximately 2 million records in MySQL all this happiness index takes about 300 megabytes.
Edwin_Rice44 asked October 14th 19 at 11:52
4
answers

Removing mysql-binlog's?

Is it possible to remove binlog'and without fear for replication of database? In this case, to do with the mysql-bin.index? Thanks in advance for your answers.
Hanna62 asked October 14th 19 at 11:36
6
answers

How to work with a constantly changing database in the version control system?

Use subversion, MySQL, NetBeans. I would like to than code base, too, would be in svn. Base of the project is updated quite often. As with the lowest labor costs to upgrade, fix, etc. tables, procedures, views, etc.?
constance.Bei asked October 14th 19 at 11:23
1
answer

Need help writing a Mysql query

There is a table with statistics in it 3 fields (id, time, user_id) Help to make one query to select COUNT(id) WHERE time (broken clock) in the last 7 days grouped by user_id. Just I get terrible Shin guard with a bunch of nested queries, maybe there's a more educated decision
Garry_Gottlieb61 asked October 14th 19 at 11:11
6
answers

To choose values not in the table

Hello. In the table column item_id consist of numbers 1, 2, 3, 4. I have a list of the numbers 2, 3, 5. Need a query which will return only 5, that is, the value of which is not in the table but is in the query. I do not understand how to do this query? It is clear when the data in the two tables, but when the list in the...
phyllis46 asked October 14th 19 at 11:03
2
answers

The schema of the tables, how to organize a rating with pros/cons?

You need to make the rating of posts/comments, on habré. Mean pros and cons that we cannot continue Golovan more than once. How to organize the schema of the tables in MySQL? Now the rating is stored in the rating field from the record itself, but the visitor can vote more than once.
Jodie14 asked October 14th 19 at 10:31
1
answer

Postfix and the user's display name

Hello ladies and gentlemen. There is a program on the basis of postfix+dovecot, with mysql screwed and what point I was somewhat frustrating — the user's display name when sending a message. If you are using a mail client it's simple — the display name is set when creating accounts and all is well, but if the same user su...
Kristy45 asked October 14th 19 at 10:28
3
answers

Module transparent caching mysql queries in memcached

Is there a subject, as the perl module? I would like to make requests, not thinking that there's a frontend in the form of memcached, and the backend in mysql.
Rebekah_Hickle asked October 14th 19 at 10:24
2
answers

Use unsigned indexes in MySQL?

Is there any win/loss of performance when using the UNSIGNED attribute in the primary keys? Anyway, are there any good UNSIGNED indices, in addition to increasing the range of numbers?
Brandon.Jast asked October 10th 19 at 15:30