System Suddenly Running Slow
I have been running mysql server 4.0.14 standard on a Dual Zeon 2.8GHz machine with 2GB RAM and linux redhat 9 for about two years, then all of a sudden it has started to run at a crawl.
The database contains 26 million rows but 19 million are in a table the is very rarely used but occasionally needs to be accessed reasonably quickly (but performance isn't an issue). Approx 5 million rows are in another table this is used daily. The next biggest table is 444,000 rows.
Is there a likely reason for the sudden slow down, can i do anything about it as it is operationally critical that i fix this quickly.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Slow Running Sql
i am not using mysql but an unknown database system on a unix box - i have no control over the database but have purchased an odbc driver that seems very 'clunky' after using mysql - this is an sql statement question rather than a mysql tech question. if i run this: SELECT MK_01_vehicleRecords.registrationnumber, MK_01_VehicleRecords.vehiclenumber FROM MK_01_VehicleRecords WHERE (MK_01_VehicleRecords.vehiclenumber = '36176')
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0. As far as I can tell mysql is configured correctly for the power of the machine. The my.cnf file looks like this: Code:
Access Suddenly Denied
Yesterday MySQL was working perfectly. Having rebooted my machine today, None of my local sites or phpmyadmin can connect any longer, and phpmyadmin is giving me #1045 - Access denied for user 'root'@'localhost' (using password: YES). I would like to stress I have not installed anything new, I have not changed any config files anywhere, this is completely out of the blue. I have since reinstalled MySQL, which has made no difference whatsoever. Does anyone have any idea how I can get this up and running again?
MySQL Suddenly Won't Start
Suddenly MySQL Server has stopped working and I am looking at a red traffic light. I have restarted my computer several times, I have tried to restart MySQL server many times I get Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in c:program filesapache groupapachehtdocszoom|conn.inc on line 6 Unable to select database
Suddenly A Script No Longer Works
I always get the following message when starting a search in my database: Search for titles in the mylibrary database. Search for titles beginning with a:
How Do I Get System Date
I have a Timestamp which shows the Date and Time. I would like to change it to just show the Date. How do I do this using phpMyAdmin?
Getting System Date
I was wondering how to set up table to column to get the system date for a date stamp. Could someone help me with this. I tried date date SYSDATE with no luck
Best Way To Set Up Membership System
My site will have users that sign up and can then become part of multiple groups (think similar to Yahoo Groups or something like that). How would be the best way to set up the database/table structure so queries could be run to find both all the groups that a user is a member of and also get membership lists for each individual group?
System Tables?
Is there documentation on the system tables? I couldn't seem to find anything when I did a search on system tables. I know about the information schema, but I want to know about the tables the information schema uses to build the views it contains.
Registration System
I have my database and HTML forms made. When I click submit to submit the registration it doesnt go to to the database it comes to a page with all of my database stuff on it. Can someone help? I have the page register.html made with the forms on it. When you click on submit its supposed to go to register.php which will send the info to the database. But is doesnt. Here is the register.php code:
System Tables
When I create a new DB it's empty. Are there a base set of system tables / functions and so forth created?
Privilege System
Is there a way to limit update access for a user to a single record? I have a database table that contains various information about people. That information is contained in a record for each person. I want people to have read access to the whole table but update access only to their own record. Is this possible and if so how would I set it up?
System Log For Triggers
Is there a system log file which can be checked to see the histroy of triggers. I am trying to debug a trigger that is not executing when it should.
Rating System
i want to do a rating system like youtube's where it averages out the total ratings. i'd store each of the ratings per each row and have them seperated by comma's then in my code put them in to an array. i also wanted to store the usernames of the voters in the database in the same fashion (without displaying them though) as above say instead of using cookies (as they can be deleted). would method this be feasible? or would this say overload the database and cause slow down?
Booking System
Hi, does anyone know of a site (tutorialised / open source) that offers a PHP-MySQL Online Booking System (similar to a Hotel Booking System)
Privilege System
Can I change structure on "mysql" database to implement new Privilege System? Views named "user", "host" etc will return old structure style.
System Variable
i am connected to the server and i build some tables etc etc. everything is fine. i run the command "show variables". it executes fine and shows me the values of all the variables on the server. now if i try and change the value of the variable tmpdir using the set command, it tells me unknown "error 1193: system variable tmpdir". help needed here........ another point, the variable "tmpdir", points to the dir c:/windows/temp. i put a text file in that dir and try to load some data from that file into a table, and i get an error "file not found".
Ranking System
I've made a forum and i want to have a ranking system with it. I managed to display a postcount but i also want a few images to be displayed, like if you have made more then 50 posts, it displays 50.jpg or something, how can i accomplish this, in another way then just str_replace()ing all the number of posts? And how do i display 2, like if you have 50 posts, 50.jpg and if you have 60 posts, 60.jpg.
System Variable.
i am running mysql version 4.0.16-nt. now, i am connected to the server and i build some tables etc etc. everything is fine. i run the command "show variables". it executes fine and shows me the values of all the variables on the server. now if i try and change the value of the variable tmpdir using the set command, it tells me unknown "error 1193: system variable tmpdir". help needed here........ another point, the variable "tmpdir", points to the dir c:/windows/temp. i put a text file in that dir and try to load some data from that file into a table, and i get an error "file not found".
System.OutOfMemoryException
sql 2 error: Exception of type 'System.OutOfMemoryException' was thrown. this is the error I am getting using Mysql connect and Visual Studio. My program is set on a loop and after the program has opened and closed around a million connections in my error logs i see this error about 80 or 90 times then it gives me a timeout error until I stop the loop. If i try to restart it it will continue to fail unless I restart the computer containing the database. Does anyone know what is causing this or how I can fix it? Edited 1 time(s). Last edit at 07/18/2007 12:39PM by Joe Gates.
Voting System
*********************** | game_id | discussion_id | *********************** SELECT game_id, discussion_id, count( * ) FROM `games_voting` AS votes GROUP BY votes.game_id, votes.discussion_id using the above query to generate a count of votes grouped by game and then user who got the votes right now it returns all the users that received votes for each game, i'd like to only receive the user with the top vote count
Scoring System
Im sure some of you have come across 'neave' games? The scoring system is setup as below: CREATE TABLE games_pacman ( name VARCHAR(20) PRIMARY KEY NOT NULL, score INT(11) DEFAULT '0' NOT NULL, ip VARCHAR(15) ); CREATE TABLE games_banned_ip ( ip VARCHAR(15) PRIMARY KEY NOT NULL ); Clearly, it is possible to ban ip addresses from using the score system. But, can anyone tell me please if it is possible to set it up to ban certain names from being used?
System Configuration
I'm currently rebuilding my home system - a couple of linux boxes with Debian. Although I don't have a high load on any of my systems, I am going to set up a separate box with my mail server and another for my web services. I'm wondering if there is an arguement for or against putting MySQL over on the mail box or even putting it on its own box?Assuming the arguement is for putting MySQL on a different box, are there any pitfalls, tips, tricks I should consider before starting this project?
Heavy Traffic System
I am developing a very heavy traffic site. It may happen that at same time (exactly same) two user will try to register with the same username. What will be the approach to prevent this situation. Which user will be able to register and which one will be denied? Do I need to use any locking facility? If so is it a wise decision to lock entire table?
How To Get Today System Date?
Can anyone tell me how to fire a query in MySQL to get todays system Date. I want to Subtract yesterday's date from Today's date.I want to check that if todays date is greater than yesterdays date i have to delete yesterdays date.
Online Booking System
Im working on a dog walking site for my girlfriend and she wants to have an online booking system for walks. Can i use MySQL & PHP to create this or is the a language more suited to this form of application.
Song Request System
I'm new to MySQL and have been racking my brains at this for hours, studying the MySQL documentation, etc, and have given up. All I want is some form of PHP/MySQL integration on my website that allows visitors to Reuqest Songs, and my DJ's be able to view all the reuqests in a page. It'd just involve adding values to a database (song name and song title) then getting a page to query them out and display them again. Would someone be so kind to write me a very very basic script that will do what I require?
Standardized Naming System ?
is there a common naming system for db objects ? Like: 1) Tables: mytable, tblmytable, tbl_mytable 2) Indices: idx_anindex 3) Columns: int_somenumber, date_lastupdate 4) id for the numerical primary key e.g. table customers.id and then for referencing foreign keys table addresses : addresses.customer_id or addresses.customer_fk OK, I know I could name them the way I want but perhaps there is some kind of common sense in this regard ?
System Variable Tx_isolation
The System Variable tx_isolation is used for what? What this actually means, Development Server System Variable Value tx_isolation READ-COMMITTED Production Server trx_isolation REPEATABLE-READ What will be the difference between these two thing?
System Requirements Of MySQL
I need minimum system requirements for installing MySQL server. This is for service definition. Please provide me the info/link from where I can get the info.
Recommended System Specs?
I was wondering if anybody could point me to any documentation or could suggest some info on a small MySQL server that I'm setting up. This will be running Windows and IIS (i know, i know) and be for a maximum of 20 users; nothing special. Any suggestions for processor and RAM or things to look out for? It will be running the MySQL Community Server 5.0.
How Do I Set Up My System As A Testing Server
I work on a Windows XP Pro. Platform and I am having trouble setting my system up as a Testing Server for PHP pages. I want to be able to test scripts and build my database. I tried downloading and installing MYSQL and PHP but it still does not work. Is there some kind of Configuration I need to do in the PHP.ini file?
System Error 1067
I am just starting mysql and when I go to "net start mysql" I receive this System Error 1067, and that the system could be not started.
Client Login System
I am working on making a client login system. I would like client's to be able to login on my site and just basically see their individual invoices, pay with Paypal, see site progress, that kind of thing. I have some ideas as how to do it, but I was wondering if anyone had some suggestions?
ASP And MySQL Membership System?
I'm trying to set up an ASP and mySQL (or Microsoft Access if absolutely necessary). It needs to allow users to register, certain pages to be "members only," and it needs to have an email password reminder system. I have a good deal of beginning experience with coding (I've studied the beginnings of C++, VB, javascript, CSS, and have sort of worked with PHP on a discussion board). Anyone have a GOOD and somewhat UPDATED and RECENT tutorial?
External System Call
Is it possible to trigger external system calls from mysql db? I want to start an external script after a certain value has been set in DB?
Unkown System Variable
I try to code a store proc. but I always get compiler error: "unkown system variable 'no_more_data' ".....
Posting System With Time
I need to build a system that posts a message on a given time. Example I write a message -> it goes into a db with al the messages posted for the day -> the next day al the messages will be posted in another db for the frontpage at a given time. So you get msg 1 at 12.00 at the fp msg2 at 14.00 at 14.00 at the fp etc.
Request Tracker System
I am trying to develop a simple request tracker system. I am just wondering if php/mysql is a good idea. Can you point me to a sample on the web?
Disable Privilege System
If I set skip-networking, what is the security risk if I also skip-grant-tables? Is there any performance benefit that might justify leaving the privilege system disabled? This is a dedicated database that runs on the same machine that hosts the application that it supports.
Standardized Naming System
is there a common naming system for db objects ? Like: 1) Tables: mytable, tblmytable, tbl_mytable 2) Indices: idx_anindex 3) Columns: int_somenumber, date_lastupdate 4) id for the numerical primary key e.g. table customers.id and then for referencing foreign keys table addresses : addresses.customer_id or addresses.customer_fk OK, I know I could name them the way I want but perhaps there is some kind of common sense in this regard ?
MySQLdump Crippling System
I'm trying to backup a 3 GB MySQL database on a production web server. I started working on this server the other day and it is quite old and is running ancient packaged in FreeBSD, etc. I also had a look at the backup system and it didn't appear to be working as intended. Can someone with experience just verify for me that I can use mysqldump --flush-logs --all-databases > backup.sql in order to backup all of my databases into that file? And is there a better way of doing this? It seems to take up a lot of system resources on this server.
Operating System Error
I have inherited some linux servers running mysql at my company from a prior administrator and have ran into a few problems. For some reason my mysql server daemon stopped running unexpectedly. I attempted to start the daemon with the mysqld command a recieved the following error. 070917 10:22:33 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. I also found another command to start the daemon in some sort of safe mode and it shows the followin error: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mysqlsrvr.pid 070917 10:20:46 mysqld ended I have checked permissions on pretty much every directory I could think of but still I get this error. Can someone please help?
Topic Rating System
I have a rating system on a forum I'm building. Users can rate a topic either good or bad. For each Good rating, one point is added to the topic's score. For every Bad rating, one point is subtracted to the topic's score. Each time a rating is made, several things are inputted into a MySQL table called ratings rating_id rating_date rating_username rating_topic rating_value What I want to be able to do is query this table to grab the highest rated topics and lowest rated topics in a given time period. My MySQL knowledge is pretty limited right now.
|
TRACKER
