Im working on developing a webapplication with MySQL Server 5.1, Spring 3.0.5 and Hibernate 3.6. I use Springs Transaction Management. Im a newbie, so please be patient with me if I ask a question whi
Is the internal locking of MySQL sufficient for a small to medium sized website? My tables are MyISAM. There might be a few hundred people concurrently hitting a specific table with SELECT\'S and INSE
I have a table with 30 million records, using MyISAM engine. I have recurrent DELETE statements every 15 minutes to clean the table from old records.
I am facing a problem where I am trying to add data from a python script to mysql database with InnonDB engine, it works fine with myisam engine of the mysql database. But the problem with the myisam
Is there an easy way to turn a mysql table into a redis equivalent? I have a myisam table in MySQL that is basically used as a key-value store that I want to \"move\"开发者_如何转开发 to Redis so it
What are key differences and wh开发者_如何学Cat is a use case for both of them? Thanks!Full-text search is the kind of search based on special sort of index (full-text, obviously). So you get the powe
I have a situation where I have to create tables dynamically. Depending on some criteria I am going to vary the size of the columns of a particular table.
I am having I/O related开发者_开发百科 performance problems that would be solved if a few relatively small tables were running on a SSD.I can\'t move the entire DB to SSD because it is much too large.
I have a MySQL table with about 2 million rows, and a script that updates approximately 100 rows per second. I\'d like to reduce the amount of disk write I/O that\'s going on. For this particular tabl
This question alr开发者_开发问答eady has answers here: Closed 11 years ago. Possible Duplicate: MyISAM versus InnoDB
加载中,请稍侯......