MySQL : Open-Source, Relational Database Management System
1
vote
0answers
16 views
MySQL Workbench, how to refresh EER diagram?
I'm using MySQL Workbench to design my MySQL database and model how entities would look like and how they would relate to each other. Now, sometimes I use Doctrine ORM. When using Doctrine ORM, I ...
3
votes
1answer
15 views
How to determine which SQL Server user or database overuses server resources
I have a Microsoft SQL Server instance on my server with more than 100 databases and users. Sometimes, the SQL Server process use 100% of server CPU and I want to know which query/user/database is ...
2
votes
0answers
3 views
Can underscore be forced as a word splitter without a full-text parser plugin?
Is there any way in MySQL to force underscore to become a word splitter character (like space or dash) without having to use a fulltext parser plugin?
If not, does such a plugin already exist or do I ...
0
votes
0answers
21 views
Why does MySQL (InnoDB) table get faster after OPTIMIZE TABLE, but then don't work?
I have a Django web application that stores data in a MySQL InnoDB database. There is a particular page that is accessed a lot on the django admin, and the query is taking a long time (~20 seconds). ...
0
votes
0answers
75 views
When is a relational database worth?
I have a database with one table which contains a few varchar columns which can contain data from a fixed set (testdata1 can contain three different values in about 10,000 rows).
I thought about to ...
3
votes
1answer
39 views
Robust Mysql failover using free tools
I am looking for a free solution to set up Mysql in an active/passive configuration, in order to provide high-availability. In particular, a Bugzilla installation, and MediaWiki needs to stay alive ...
0
votes
1answer
21 views
MySQL table relations, inheritance or not?
Im building a micro CMS. Using Mysql as RDMS, and Doctrine ORM for mapping.
I would like to have two types of pages. Static Page, and Blog Page. Static page would have page_url, and page_content ...
1
vote
1answer
32 views
Index strategy for a Queue Table, getting rid of filesort
I am trying to get rid of a filesort operation (and preferably also optimize a bottleneck query). We are using an innodb mysql table as a queue to process various incoming business activities. It is ...
0
votes
1answer
13 views
MySql - Changing expire_logs_days without restarting the server
I'm using MySql 5.5.
Is it possible to change expire_logs_days and have the changes take effect without restarting the server?
2
votes
1answer
35 views
When should I think about upgrading our RDS MySQL instance based on memory usage?
It seems like our DB server is doing garbage collection at a increasingly faster rate, which seem normal since it's growing. What's a good rule of thumb of when to switch to a bigger instance, I'm not ...
-1
votes
0answers
32 views
mysql IO read rate very slow [closed]
Possible Duplicate:
Select * from statement execute very slowly, innodb io read speed is low
I have a very simple query " select * from ap_statistic " running in my servers. the servers ...
1
vote
0answers
27 views
Regularly import tab-seperated log file to MySQL
I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
1
vote
1answer
31 views
MySQL performance slows down when accessed from different regions via the Internet
I have a MySQL database hosted in a server in Brazil.
When I connect through an ODBC connection (FE is access) with a Brazilian IP everything runs fine.
When I connect from the U.S. with the same ...
-2
votes
0answers
39 views
mysql - LIMIT WHERE LIKE [closed]
Do we take an equal amount of performance-hit using LIMIT, WHERE or LIKE?
Of the three, which would be the slowest for mysql?
If I have 2 possible values for a column, which is faster, LIKE or NOT ...
1
vote
0answers
46 views
Select * from statement execute very slowly, innodb io read speed is low
I have a very simple query " select * from ap_statistic " running in my servers. the servers have the same hardware and software configuration (CPU 8 core, mem :32G, OS: redhat 5.5, mysql version: ...
