Tagged Questions

MySQL is an open-source, relational database management system.

learn more… | top users | synonyms (4) | mysql jobs

4
votes
0answers
184 views

Laravel & PHPUnit : allow process isolation to prevent Mysql Too many connections error

Since four months we build a complex web app with Laravel 4 with a good unit test coverage. Now we have 159 tests and 592 assertions to prevent against regression and allow us to easily refactor our ...
3
votes
0answers
21 views

Hibernate list mapping in a separate table

We have two POJOs below public class Notification extends AbstractDomainObject{ private String name; private List<User> users; //setter getter } public class User extends ...
3
votes
0answers
174 views

Unrepairable crashed MySQL table?

a couple of days ago, my user's forum suddenly went down because of a database problem. More specifically, when performing any query on the "forum_users" table, I get the error message Table ...
3
votes
0answers
147 views

…mysql2/mysql2.so: [BUG] Segmentation fault ruby 2.0.0p247

I'm using windows7x64, ruby2.0.0p247, rails4.0.0 and mysql5.5.27. When I run the $ rails server command, I got the following error. ...
3
votes
0answers
64 views

Threading and SQLAlchemy Sessions

I know this question has been asked a few times, but I'm still unsure about the usage of scoped_session with threading. Basically, I have an application with 10 worker threads. I have one Engine with ...
3
votes
0answers
67 views

MySQL 5.6 deadlock for locking the same rows twice?

I am seeing a deadlock with MySQL 5.6 because of what seems like trying to lock the same row/s twice. From the snippet below, rows where id = (11, 12, 13, 14, 15) already have a lock. And when ...
3
votes
0answers
75 views

How to quote identifiers with LINQPad + IQ Driver + MySQL?

I'm working with a rather horrible schema designed by an external party and it contains a table named order so when I invoke a query that references this table in LINQPad I get a SQL syntax error. I ...
3
votes
0answers
130 views

MonoTouch MySQL Database Access

Is there a MySQL provider compatible with MonoTouch for iOS? Can Mono provider for MySQL database be used with MonoTouch?
3
votes
0answers
409 views

Using SqlFunctions or Equivalent Collection of EdmFunctions with MySql and Entity Framework

I'm using Linq to Entities, backed by MySql. I'd like to be able to use various built in MySql functions such as rand. If I were using MS SQL Server I could use the SqlFunctions class, but this does ...
3
votes
0answers
642 views

convert WKT polys in MySQL to Google Maps polys

I have a column of WKT POLYGON values in MySQL (I inherited the db). The polys are queried and rendered on Google Maps. Since Google Maps polygon overlay requires an array of points, the previous user ...
3
votes
0answers
1k views

Improving mysql Full Text search: Stemming and synonym

i am having hard time to figure out what should i do for improving my full text searches. I have 2 problems: Stemming: mysql full text searches doens't include plurals and singulars of words. ...
2
votes
0answers
38 views

MySQL, Error 126: Incorrect key file for table

I read the following question that has relevance, but the replies didn't satify me: MySQL: #126 - Incorrect key file for table The problem I get ERROR 126 (HY000): Incorrect key file for table ...
2
votes
0answers
45 views

MySql query runs very slow(actually never gives output) without where clause

I have a mysql query and it works fine when i use where clause, but when i donot use where clause it gone and never gives the output and finally timeout. Actually i have used Explain command to check ...
2
votes
0answers
44 views

How to insert double quoted string value in database using codeigniter active records?

I know codeigniter automatically escape characters to prevent possible sql injections. But how would I able to store string value in the database with double quotes on it. Is this possible? Or is ...
2
votes
0answers
19 views

Saving web page text range, highlight it, then restore selection cross browser

I've been searching around a long time, but I can't find a way to get a specific selection on a webpage, then store the range selection in a MySQL DB, then restore it. There are many ways to do this ...

1 2 3 4 5 … 2369
15 30 50 per page