Tagged Questions
3
votes
2answers
59 views
Type safety in WHERE clauses
I've spent the most part of yesterday tracking down a strange bug in our PHP/MySQL application and the culprit seems to be a poor query. We have a table like
...
1
vote
1answer
60 views
What is the most effective way to cluster MySQL for my requirements?
Basically I have 3 edge servers and 3 application servers. The edge servers are running nginx and load balance between the application servers. The application servers are running Virtualmin GPL with ...
4
votes
1answer
84 views
Loyalty reward - record for every day of a week
I have a table that contains every login a user makes. I am trying to make a loyalty system that rewards users if they've logged in every day for a week.
So, the real question, how do I get every ...
1
vote
2answers
138 views
Preventing mysql deadlocks in your php application that uses SELECT… LOCK IN SHARE MODE
If I understand SELECT ... LOCK IN SHARE MODE correctly, you can place it into a mysql transaction to select the rows you will be working with during that transaction.
This is done in order to "lock ...
1
vote
2answers
75 views
16 Cores 12 GB RAM server MySql Configuration - my.cnf
The server takes 20+ seconds (wait time/slow IO response time) to response to a HTTP request even with memcached and APC installed. I believe this has something to do with MYSQL since the site as lots ...
0
votes
0answers
54 views
16 Cores 12 GB RAM server insert heavy MySql Configuration [closed]
Possible Duplicate:
16 Cores 12 GB RAM server MySql Configuration - my.cnf
The server takes 20+ seconds (wait time/slow IO response time) to response to a HTTP request even with memcached ...
1
vote
1answer
35 views
keeping database columns consistent with documentation
For a project, the client wanted to be able to add fields to any item and have them be searchable. To make them searchable, that would require the fields to take a column, but that would make the ...
-1
votes
0answers
21 views
I am kind of familiar with mysql, need a book that goes into a little more detail [closed]
Possible Duplicate:
How can I learn to become a DBA?
my mysql experience is limited to making a classified site, nothing significant , and a few webbots here and there. So I am familiar ...
0
votes
1answer
24 views
What would be the best way to design a table in Mysql that handles read items in an RSS feed reader?
I'm working on an RSS feed reader, it is mostly functionnal. But after some time beta testing it, I noticed that its very slow running some queries on a table that handles all the items that have been ...
2
votes
6answers
871 views
importing large SQL file phpmyadmin
I am trying to import this SQL file in phpmyadmin and got this message
#1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right ...
0
votes
1answer
46 views
I want to count all the rows for todays / yesterdays date based on a DATETIME - mysql+php
I have database "db2" with table "menjava"
In table menjava have "id", "author" and "date_submitted" field
id - auto_increment
author - int(11)
date_submitted - datetime
I want to count all the ...
3
votes
1answer
355 views
MySQL 'LOAD DATA INFILE' : Can't replace entry when foreign key exists
Here's a minimal case for my database scheme:
CREATE TABLE `test` (
`id` int(11) NOT NULL,
`name` varchar(22) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT ...
3
votes
3answers
64 views
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted?
Is there any way to temporarily enforce columnar uniqueness on items currently being inserted? For instance, I'm splitting payments and charges to their own tables from a previously unified ...
6
votes
1answer
92 views
Application Settings in Database
In the past I have stored all generic settings and configuration items such as: custom application title, home address, version, debug, etc.. all in a "settings.php" file that I would include into all ...
2
votes
2answers
188 views
MySQL connection doesn't work anymore
I had two MySQL servers running (127.0.0.1:3306 and 127.0.0.1:3307). Now I get this strange error: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet' I can ...
