checking for repetitive queries

I want to make sure my caching system is working properly and I want to make sure my mysql server isnt being held up by repetitive queries (ie like the side products table that appears on every web page). I'm pretty sure I cached the site pretty well, but want to make sure that I didn't miss

Unicode characters are giving me question marks

Hey guys, I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work in my database. I put default-character-set=utf8 in my my.cnf file and restarted the database. Then I created a brand new database new table, new field. I try hooking into the newly created database with Mysql

MySQL database gets slower over time

have you done any optimize to your tables ? it should help improving the query performance. it's normal to have memory lower on each day, because your index files are growing, and takes memory. if you're not using innodb or bdb, you can try to run flush threads and flush tables. it might

MySQL database gets slower over time

HIdey Ho. I have a fairly large mysql database (a few million records) and queries run pretty damn fast. However, over time (say, over the course of a month), performance gets slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql. No dice. Now, if I reboot the

MySQL gets slower over time

HIdey Ho. I have a fairly large mysql database (a few million records) and queries run pretty damn fast. However, over time (say, over the course of a month), performance gets slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql. No dice. Now, if I reboot the

mysql using wrong indexing keys

I am running this query that is awfully slow. It's a simple query between two heap tables with two joins. I ran a explain statement to see why it is running so slow and realized that mysql was using indexing for one of the lesser inefficient joins! I fixed this problem by adding a

Re: mysqlbug : problem while installing mysql

I've heard a lot of cases where upgrading a windows 98 machine to windows 2000 will cause problems later on. This may be the case with your system. The only thing I can say is try using that same downloaded executable on a friend's machine and see if it works there. If not, theproblem is with

heap tables keep on disappearing!

I have a mysql table that I refer to a lot and needs to be quick. I set it as a HEAP table because of the speed (and HEAP tales ARE fast. zip baaannn). Anyway, whenever I restart the server the contents of the heap tables disappear! What the hell? But I read the manual and it seems

Properly shutting down mysql

If I manually shut down mysql, I usaully use the mysqladmin shutdown command. However, I noticed that the red hat way of stopping mysql in its init scripts is by issuing a kill command to the pid. U, is this wise? What about if the tables aren't written to disk? Isn't the proper way to

Joins are damn slow. . .

Maybe I'm a bit naive in saying this but. . . SQL joins are damn slow! I have a simple database of about 37,000 records in [Court Cases] and 2,000,000 records in [Defendants] (soon to be more). When I do a search on [Defendants] (the big table) alone, a saerch can go in like .7 seconds. But if

Maximum SQL size?

Is there a maximum size to a SQL statement in mySQL? Just wondering. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Joins are slow

Maybe I'm dumb for saying this, but sql joins seems expensive to do in terms of performance (yes, I indexed the joined fields). If I do a query search of a 2,600,000 record defendant table WITHOUT a join (SELECT DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE owen% OR Defendant LIKE

Table joins are slow things to deal with. . .

Maybe I'm dumb for saying this, but sql joins seems expensive to do in terms of performance (yes, I indexed the joined fields). If I do a query search of a 2,600,000 record defendant table WITHOUT a join (SELECT DISTINCT CaseNumber FROM Defendants WHERE Defendant LIKE owen% OR Defendant LIKE

Loading a database into RAM

I have a mySQL database that is about 240 megabytes. I am loading it on a Linux server with 2 gigs of RAM. I would like to have the whole table reside in memory to save time from disk access. Is there any way to load the tables into RAM on startup? I am thinking about creating a heap table,

myODBC, if left alone, can lock up an Access table

I notice that sometimes when I establish a connection with myODBC with Microsoft Access, and send it occasional sql statements it works fine at first. But if you let it sit for, say, 30 minutes and comes back, the Access table locks up. I am not sure if this is a problem with myODBC (which I

MySQL vs MS-SQL performance

Hey guys, Most of the accounts I have read about MySQL was that it was one of the fastest databases around. Now, for development purposes I created a FreeBSD system with JUST MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to server as our development