Speed From Second Machine Bad
I am new to MySQL (mysql-4.1.7-win) with MySql ODBC (MyODBC-3.51.10-x86-win-32bit) and (vb 6 with service pack 5 or Access 2003) to connect via adbc to MySQL.
My seccond machine are terribly slow and would like to know if there are any suggestions.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2. Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared! I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.
Load On My DS Machine
I've got dedicated server , 30mbp/s line, and solving very strange issue, my hosting told me i burn about 2.8mb per sec., so i get a lot of traffic, i don't use mysql very often, i use mysql only for special cases, no more than 5 requests at same time. i'm checking top function via telnet console, and i can see sometimes huge loads on server, from 0,8-1 it skips to 20, then 30, 50, 100, somewhere between 20-30 it crashes mysql, and i can't connect , sometimes it went to 150 load, and then it slowly going back to normal.
Migrating My Mysql DB From One Machine To Another
We are moving our mysql db from one machine to another -- both linux. Origin machine is running mysql 3.23, destination machine is running mysql 4.1. Can we simply copy all *.MYD / *.MYI / *.frm files from one machine to the other and have things work? Or do we *NEED* to do a text dump of the tables, and reload each one individually on the new machine?
How To Go About Re-installing MySQL On A New Machine?
I have MySQL installed and a database already built and loaded with data that is collected nightly from the mainframe database. I am currently running on NT and will be loading a new image onto the machines to change the operating system to Windows2000. From what I understand, I will need to copy all files I want to keep, including my database. My question is, once the new image is on, I will need to re-install MySQL, is it as easy as just copying back the MySQL directory back onto the machine and the database still work? If not, can someone tell me what the general process is to do this without losing the database and any issues that I am going to run into?
Can't Connect From Remote Machine
I am writing some code in ASP3 on an XP windows machine. I am trying to connect to a linux machine which is Redhat 7.3 that is hosting my MySQL database. I am use this code to connect. objConn.Open "Driver={mySQL};Server=http://4.7.165.99;Port=3306;Option=131072; Stmt=;Database=DB name;Uid=User Id;Pwd=MyPassword;" This is the Error message I keep getting: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have been looking all over the web, and can't find how to fix this issue, can anyone help me?
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
Connecting On A Local Machine
I have recently installed Mysql on my local machine. I can access Mysql through the Mysql Command line client. But I can't connect through mysql_connect.php script. I have always used mysql through our hosting company with no problem. This is the first time I have installed it on my machine. When running the script I recieve the following error Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061
Connect To MySql From Another Machine
I have RHEL 4.0 installed on a x86 box, and am using the standard MySql server that comes with RHEL 4 (MySql version 4.1.12). I tried downloading the Administrator tool, but had problems installing it. (This issue has already been reported at http://forums.mysql.com/read.php?34,65093,65093#msg-65093). I have an Administrator install on a Windows machine, and I want to use it to connect to the MySql server on the RHEL box, but get the error that says: Host '<my_machine>' is not allowed to connect to this MySql Server. Can I use the Windows Administrator tool to connect to a MySql server on Linux? (same network and sub-net) During the RHEL install, the firewall option has been disabled, so that's not an issue. I think I need to add an entrry somewhere in the MySql db that allows other machines to connect, but am unsure of how to add it, and what the syntax looks like.
When Should I Scale Out From One LAMP Machine?
I just have one server that runs Apache, MySQL, PHP. It handles requests fine and never had problems. When should I think about a small step into scaling? By maybe having an independent MySQL server? How many QPS (Querys Per second) (approx) on the MySQL DB will it be optimal for me to have MySQL on a seperate maybe more powerful machine? The current server has 1GB Ram and intel duo core processors..
Connect To Another Machine With SQL-Server
just installed a mysql server, database and user on one machine [1] (debian-linux) Now I want to connect to the database from another machine [2]. Actually I am sure that I have to configure connectors or named pipes. But I can't find these topics in the manual. When starting mySQL as user on the server everything is ok. When starting mySQL as user on the client computer [2] I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) actually '/var/run/mysqld/mysqld.sock' is not existing. What do I have to put into that one? Or rather into /etc/mysql/my.cnf
Access MySQL From Another Machine
how do I make MySQL server accessible from the network to other web servers. Right now I have the MySQL server and the web Server all on the same server. But I want to have a server that is solely responsible for MySQL and 3 others servers that are responsible for web page serving via Apache. The web servers need to be able to access the MySQL database. |-----| |----| |----| |Web | |Web | |Web | |-----| |----| |----| ! ! ! !!!!!!!!!!!!!!!!!!!! | |----| |My- | |SQL | |----|
Usinq MySQL And MS-SQL On The Same Machine?
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Usinq MySQL And MS-SQL On The Same Machine
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Move SQL Files On Same Machine
How do you move the directory where MySQL files reside and inform the local MySQL server of this? I'd like to be able to move my data files to different locations on my hard drive AND move them to another machine when I have to use them on the road.
Moving Database To New Machine
I'm trying to relocate my site to a new host and I'm having a lot of trouble moving the database. I did the export for the old host/database with phpmyadmin. It saved to a txt/sql file with no problems. When I try to import it into the new host/database I get all kinds of syntax errors. Then I realized, after purchasing the new host that: Old host/db = MySQL version 5.0.24a New host/db = 4.0.27 Is there any way to convert a 5.0 db to 4.0?
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
Create Dsn On Linux Machine
i am raghvendra. i am working on linux. i am using a php4 with apache 2 on linux machine. i want to create a dsn on linux machine. but i donot know how can i do this. my database is on remote windows machine.
Md5 Problem After Moving Database To Another Machine
I moved my MySQL database to my own web server (Windows NT4 server, Apache 2.0.55, PHP v4.4.0, and MySQL v4.0.26). I used "mysqldump" and "mysql -u root -p ccs < sqldumpfile" to backup and reload the tables. Some PHP scripts that work fine on my ISP (MySQL v3.23.58) do not work on my local PC (MySQL v4.0.26). The part of the select statement where the problem lies is: and password='".md5($MD5_PREFIX.$_POST["password"])."' I did some testing via the mysql command line interface and it appears that the md5 function is generating a different value. If I set the password to '123' with no encryption and remove the md5 stuff from the PHP script it works (the $MD5_PREFIX has not been changed and I even did some testing in mysql by hardcoding the value) -- so I'm pretty sure the problem lies with the md5 function. Is there a difference in md5 between different versions of MySQL? If not, can someone point me in the direction of a solution?
Mysql Runs On A Machine With Multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of user@localhost instead it will be equal to the rights of the user@PrimaryIPAddress. Is this behaviour correct or a bug.
Moving Database To Alternative Machine.
Have installed version 4.1 on 2 machines. I am trying to copy a database that i created on one machine by simple going to the data folder and copying the database folder pasting it to a removable device. I then copied the folder into the data folder on my second machine. However, when i attempt to do a select * on any of the tables on the second machine, I am told that the table is corrupted or does not exist.
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
BACKUP DATA TO LOCAL MACHINE
Is there an easy way I can backup / copy MySql tables to my desktop PC. It would be neet if I could query these backups once of my desktop PC with MS Access.
Blank Password When Restarting The Machine
I mainly use MySQL Administrator to create/update table/users/etc. And I noticed that whenever I restart my machine (Windows 2003 Server with MySQL database running) and login to the MySQL Administrator, it takes blank or wrong password for any user account including root. So I end up resetting my root password. Does anyone know why it keeps happening?
Installing MySQL On WIN98 Machine
I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file? I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password. The checkbox for "Install as windows service" is disabled, so I can't check it.
Nightly Backups To My Local Machine
I have a MySQL database on one of my sites with shared hosting company which has nightly DB backups. However I would like to have a nightly copy for myself on my local machine. Is there a way to automatically expoxt the entire MySQL database and FTP it to my local machine nightly? Do i just need an FTP program that provides scheduling or are there other ways?
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
MySQL VmWare Virtual Machine - Password?
I just downloaded and installed the MySQL-provided VMware linux virtual machine. To logon to it there is a linux user 'lxuser' provided. Anyone know the password for lxuser? root?
How To Insert Machine (local) Time In Mysql
This is a problem I encountered in mysql: how do I insert local (machine) time? To do this in MS Access, just put now(). I tried this in mysql, it does not work. see graph(the red chinese characters means the same thing as above.)
Importing MySQL Database To Local Machine
I have exported a MySQL Database from a remote server using PHPMYADMIN, saved on my local XP machine as an sql file to insert (with name _DB_.sql) but am not sure how to get this to run on my local XP machine which is running MySQL locally; When I view the file on Notepad it appears to be executable in some way as it includes CREATE command etc. I tried the following from MySQL command line SOURCE C:/Program files/MySQL/_DB_sql but can't see any evidence of the database having been created on my local machine.
Multiple MySQL Server Installations On One Machine
First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.) If so, what naming convention (and infrastructure) distinquishes between the two MySQL servers? What network connectivity file entries would exist to differentiate between the two servers such that I could connect to one or the other servers from a remote client?
Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!). I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection. What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used). I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
Dumping My Live Database And Then Putting It On My Local Machine Problem..
I have tried copying the dumped sql code in mysql query browser once dumped from live and it doesn't execute it, i have to extract it line by line and that would take forever to do this all, is there an easier way to do this or can someone run me through the basics on how to achieve this? i have on my live site: 4.0.25 (patched) and on my desktop computer : 5.0 Would this be part of the reason? i don't know..
Speed
I recently started using a MySql 5.0. I had been using a 4.1 server. After changing I've noticed a sufficient increase in the connection times. The biggest speed problem I've faced is when I try to read from a table. In 4.1 it seems rather instantaneous. In 5.0 I see a 2 to 3 second delay.
Speed Up
I have 3 tables cat: The Main Category scat: The Sub Category product: The Product info, cat_ID and scat_ID I need to output all product BY Main Category then sub category. Right Now I get all the records for Main Category then loop though and in the loop I get all Sub Categories Where cat_ID is the current Main Category. Then I loop through again and get all product where the scat_ID id the current s_cat. Then I loop through and output the product info. Anyway the page load times are not great and I'm sure I am hitting the database way to much.
Speed
which is faster/better: Having a single table with all the information you need for a query in it but with duplicated data (not entire rows) OR Having what would be duplicated data in lookup tables. This is in a database that will have millions of records to query. It needs to run super fast - like anything over 1s from submitting the form to getting the result is considered slow...My head is telling me to use lookup tables, because duplicated data is bad but surely thats going to have a performance hit with so many records and with high traffic - expected 25k+ visiters per day.
Can You See Any Way To Speed This Query Up A Bit?
SELECT SQL_CALC_FOUND_ROWS title, content, URL, id, (MATCH(URL) AGAINST ('$searchQuery' IN BOOLEAN MODE) * 1.5) + (MATCH(title) AGAINST ('$searchQuery' IN BOOLEAN MODE) * 0.8) + (MATCH(content) AGAINST ('$searchQuery' IN BOOLEAN MODE) * 0.5) AS score FROM $searchType WHERE MATCH(title, URL, content) AGAINST ('$searchQuery' IN BOOLEAN MODE) AND content != '' ORDER BY score DESC LIMIT $limit OFFSET $offset
Speed Of Query
I was on the PHP forum and they sent me here. I am quite new to working with large databases (approx 1 million records per table) and am having problems with the speed of viewing the data. I have a page that requests all users from a certain department and displays their names etc (this uses a simple 'SELECT first_name etc FROM staff WHERE department = 3' style query). There are around 800,000 staff in the table and so this query can take a long time to run (sometimes only to return 1 record). Is there any way of speeding up this query? Someone mentioned that creating an index on the department field may speed things up but they didn't seem sure, and I don't know how to do this so would only spend time learning if it might make a large difference! Large websites must deal with tables far larger than this and I was wondering how.
Speed This Query Up?
I have a simple query I am running, but it is taking 6 seconds to run. Im not sure what I can do to speed this up. Am I simply SOL or am I not doing something I could be?
Speed Up A Group By
would like to know whether CHAR(10) AUTO_INCREMENT will work like INT(10) AUTO_INCREMENT? or is there another field definition that will allow me to implement alphabetical increment?
COUNT() Speed
I am fairly experienced with MySQL, but I am having trouble with this certain query. I am running mysql 4.1.18 The basic query is the following, I will refer to it from now on as '_BQ_' for simplicity:
Speed Issue
We had version 4.1 installed on a server and a multiuser application accessing it. Over a period of a year or so, accessing queries etc. has become slower and slower, although the number of records have increased dramatically over that time. Recently we installed 4.1 again on a new server and moved the database over and instantly there was a dramatic increase in speed. However, over the last 3 or 4 weeks it has started slowing down again. For the moment, let us assume that it is not the application that is causing the problem. Is there anything about the way MySQL is set up that might cause it to slow up in this way? We are using both InnoDB and ISAM tables.
DB Speed Issues?
I am having the oddest issue that I can't put my finger on. It's probably something simple.. I have two DB [prod & stage] on the same RedHat 9 server. These 2 databases share a copy of Apache 1.3.31 with same dbd/dbi drivers. This application is 100% perl with dbd/dbi. Issue: When I point the code to the staging DB a particular page (Large calendar page, with lots of selects) takes 3 seconds to load. I then point the same code to the prod DB and the page takes 12 seconds to load. What parameters could cause something this drastic? I will add one more thing here... the volume of data is the same (I copied the prod DB back to staging to rule that possibility out as well.)
|
TRACKER
