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:
View Complete Forum Thread with Replies
Related Forum Messages:
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
View Replies !
Reinstalling Mysql On Local Machine
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I atmysqlt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings. The error number is 1045, saying access is denied for the root@localhost user.
View Replies !
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.
View Replies !
Database From A Localhost (local Machine) To A Server
i've setup a web page using MySQL5.0, Apache and Php.. i've finish the webpage but im facing a probs in uploading the database to the server.. i dont even know where the database are stored in my local machine and how will i transfer to the server. My hosting have My SQL 4.1.22-standard and phpmyadmin but to SSH acces..
View Replies !
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.)
View Replies !
Can't Connect To MySQL Server On Local Machine
am following along in Head First's PHP & MySQL book, at chapter 2. I've downloaded PHP, MySQL, and Apache. A couple basic scripts have worked fine, so I know PHP is working. I can create a table and a database in MySQL throught the command line window, so that seems good. But I'm trying to execute an INSERT function on the example table that the book had me make, using a script, and I'm getting "Error connecting to the MySQL server" which is the or die error message I used for failure to connect. In setting up MySQL, I was prompted for a password but not a username. So I'm trying to leave the username data blank in the mysqli_connect function. I wonder if this is my problem? I've looked through my.ini but to my untrained eye it's all Greek and I can't spot usernames or passwords there, or in any of the other .ini files in the MySQL folder. If I need a password, can anyone tell me how to find out what it is? Here's how I wrote the connect function (username is blank, surrounded by single quotes): $dbc = mysqli_connect('localhost', '', 'password_here', 'databasename_here') or die('Error connecting to MySQL database.');
View Replies !
How To 'Publish' Mysql Db From Local Machine To Live Web Site?
- We have just created our first simple MySQL database on a local XP Pro machine. - Just a simple database named MyDb with a single table named Contacts. - MS Access created a single .mdb file we would 'publish' or ftp to the server. - MySQL seems to create... ... a folder for the database named MyDb ... a file for the table named Contacts.FRM ... and another file named db.opt My questions: 1 - Are the two files above what we should put up on the live web site? 2 - Or stated more generally... ..... once you develop a mysql database locally ..... how do you then put it up on the live web site? ..... which files are the actual database? ..... what are the file extensions on a mysql data base?
View Replies !
Exporting From PhpMyAdmin On Server To MAMP On Local Machine
I thought that transferring the database from the server to my hard drive and working with it using MAMP would be fairly simple, but I am lost on the options and get: Error SQL query: -- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 22, 2008 at 11:02 PM -- Server version: 5.0.27 -- PHP Version: 5.2.1 -- -- Database: `trumpet` -- -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE `articles` ( ... etc. ... ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =15; MySQL said: #1046 - No database selected Could someone give me some guidance on how to get the database to my hard drive so I can develop locally rather than via the internet?
View Replies !
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..
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
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 | |----|
View Replies !
Slow Db Access
I have worked with a few mysql dbs on different servers but i have recently been asked to work with one on nicnames. It seems horribly slow. Working in phpMyAdmin (which i had to install myself) it takes ages when i want to do anything. View the table structure, view the data..etc. Any way i can test the speed so that i can compare it against another server i work with and proove there is a speed issue and take it to nicnames cus it is crazy and is going to affect the speed of the website!!
View Replies !
Allow ONLY Local Network Access
I know how to enable networking in mysql through tcp/ip. But what if I only want to allow connections only from our office in lan? I want to be able to share all the databases in the server, with all the local computers (192.168.1.xxx) without having to grant permissions to each user/host individually.
View Replies !
Access Frontend Searching Slow
I am running mysql on a gentoo linux box and I am using it to store data for my family. I am interested in migrating them from an access database to mysql while still using access as a frontend. However while doing preliminary testing I realized that searching through access was very slow, e.g. the <ctrl + f> find method takes a few minutes to procure a single match. The database has two tables, one table containing personal information, with about 500 records and 9 fields, and the second containing sales records, with about 1000 records and 5 fields, linked together by a id number relationship. Access is set up with two forms, one for entering new personal information, and another form for entering a sale. In the sale form, I link data from the personal information table while hiding the id number because its easier to recognize a name rather than an id number. What my ideal goal is for them to <ctrl + f>, enter in the last name of the person, and proceeed to enter in a new sale without the process taking 5+ minutes. Is there an alternative to the find command that we can use to speed up the data. The machine on which the server is running has VERY limited system resouces, a pentium III 550 mhz processor, 256 megs ram, and a 20 gig hdd, but somehow, I know the problem is with the way that I am trying to find data rather than the limited resources of the serving machine.
View Replies !
Why Is Text Driver Access/Excel (DAO) Is Slow?
I'm using the Access/Excel (DAO) driver to connect to (*.csv) files, but every time I change the location of the file, it takes around 30 seconds before the change is made... Any idea about this? Could it be because of the Access/Excel (DAO) driver? If i'm using (*.csv) files with this driver, is there a conversion that could take that long?
View Replies !
Local Host On Windows Allowing Remote Access
We have MySQL running on a server in the US (we are in NZ) the response times to queries can vary, so i have installed MySQL on my Windows XP PC. i can transfer data across overnight using a scheduled task, this allows me to query yesterdays data much quicker - it is used for trends so up to date in not important - the problem i have is this I want others within the company to be able to connect to my PC to run their own queries against my data. i do not know how to set up the ODBC connections on their PCs to 'talk' to mine. I can set them up to connect to the US with no problem but not to my PC.
View Replies !
Very Slow Table Update
I have two tables. One is really a subset of the other. However, they came in different data files and I would like to pull data from one and put it into the other. However, it is VERY slow! Once the tables are setup I will only read from them and perform operations. I will never update or insert. However, I can't get things setup to that point. Code:
View Replies !
Table Gets Slow At Around 60k Records
I've a table that starts getting slow with count(val) and select ... order by when it has around 60k records. Table type is innodb Strange enough, at 50k records the response time is great, but looks like it grows exponentially after that. Its something like 50k records - 0.2 seconds for count(val) 60k records - 3 seconds 100k records - 20 seconds I realize order by and count forces mysql to go through the entire table...
View Replies !
815,000+ Records, DB Table Query Too Slow
I have a database table with about 815,000 records in it, each record containing the source of individual webpages (with all the tags and multiple spacing stripped out leaving just the words). At first my match boolean queries were fine but once I got to around 100,000+ records it became too slow to use for a web-based search tool. I was able to separate the data into 10 tables and then use AJAX to run the match query on all 10 tables at the same time and that has increased performance. My question is, is it possible for me to increase the performance for the 1 table some how instead of resorting to separating the data into multiple tables? Is MySQL the right DB for this kind of setup, would MSSQL or PostgreSQL perform better for larger sets of data? I'm not sure how MySQL 5 clustering works,
View Replies !
How To Download To Local Client From A Large Table
I have been trying to download a large text file (17 MB) from my large table using all sorts of scripts etc. The best so far has been using - "SELECT * INTO OUTFILE 'tmp imes.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' FROM tbl_times"; This is fine on my test server - because it is 'local'... but what I need is the syntax to get it to work in the real environment and save the file to a client machine. Ideally to give them the choice of where it will be saved.
View Replies !
Large Table, Slow Query Question
I have a table with ~800,000 records. I need to grab random rows from the table based on certain criteria. The problem is that average lowest subset to grab the random row is around 200k. Here is what I'm trying to do: There are 4 columns: data,n1,n2, and n3. I need to get the value of the data column based on criteria using the n1-n3 columns. The most common query is SELECT data FROM table WHERE n1 = ? The problem is that n1 can be only 1 of 5 possiblities. When the table is finished being populated there will be roughly 1.5 million records and 250k for each value of n1. Of course, I have an index on each n column. Right now with just the 800k records it can take over a second, sometimes multiple seconds to run the following in order to get a random row from that subset: SELECT COUNT(1) AS total FROM table WHERE n1 = 3; index = random number from 1 to total SELECT data FROM table WHERE n1 = 3 LIMIT index,1; How can I speed this up? I need it to take less than half a second if possible. Thank you.
View Replies !
Slow SELECT Query INNODB Table
I have a couple hundred connections doing "SELECT [Char36 Field], [LongLong Field], [Long Field] FROM [Connection Specific Table] WHERE [NonIndexed VarChar36 Field]=[Value]". Notice that the table the select statement is being called on is unique to each connection. These tables have less than 10000 records, but this statement can sometimes take over an hour to execute. It is an INNODB table.
View Replies !
Slow FullText Search When Table Grows Constantly
I have a small issue with a web-search engine I'm working on. The main table is constantly growing (1 insert per second, currently 150 000 records) and it has full-text indexes on 2 fields that contain over 20 000 characters on each row. The thing is, as I could observe, that when multiple different full-text searches are made in appropiate period of time, the query doesn't take so much to respond (though i couldn't quite say it's fast), but when no search is made, let's say, for over 2-3 hours, the same query takes up to 30-40 seconds to respond. The query is simple: .....
View Replies !
Multiple Table Calls And Slow Loading Times... Joins?
just recently started using MySql and I think I've got most of the basics down - everything WORKS just not well. Essentially, I'm making an image gallery and the search/landing pages have thumbnails, pretty straightforward. The thumbnails are rollover slideshows of the images in the gallery so for each thumbnail preview there are a varying amount of actual thumbnail images that are loaded. The table structure is to this effect: gallery table: gallery_id, gallery_views, gallery_rating etc etc thumbnails table: gallery_id, thumbnail_link So i may have an entry as such: gallery_id = 21, gallery_views = 300, gallery_rating = 60 With several thumbnail entries: gallery_id = 21, thumbnail_link = url/image1.png gallery_id = 21, thumbnail_link = url/image2.png gallery_id = 21, thumbnail_link = url/image3.png What I have been doing thus far, say for the index page I grab the top 30 by views, is something like "SELECT * FROM galleries ORDER BY views DESC LIMIT 30" and then after bringing that into PHP in my while statement on each iteration I make a separate call that is like "SELECT thumbnail_link FROM thumbnails WHERE gallery_id = '$gallery_id'" and then output all the thumbnails for the rollovers. So let's say then for example that I want to show the top 30 by views, as well as the top 30 by user rating. At that point I'm making two calls to the galleries table, which arbitrarily we'll say contains 50,000 entries, but I'm also making 60 individual calls to the thumbnails table, which contains in some cases 20 or 30 thumbnail links per gallery and contains upwards of a million rows. Obviously my loading times are much higher than I would like them to be and I can't imagine this is the optimal way of making these calls. It seems like a fairly elementary concept but I can't seem to find something that works.
View Replies !
Why LAN Clients Frozes While A Slow Networked Client Downloads A Big Table
With MySQL 4.1 I think from a day to another something changed in the working of our server. When a remote agent with very slow Internet connection downloads 60.000 rows query lets say downloads the whole "products" table, all of the other fast LAN clients stop responding until the big download finishes. It is possible, that they would like to change the "products" table while the remote client downloads it... But! There is no lock to the table, just its a simple "SELECT a,b,c,d FROM table ORDER BY a" query.. Can it happen because of that the table becomes bigger and bigger, and now MySQL can't copy it to in the RAM, and let others live, and now it stops other clients instead?
View Replies !
Slow Select Using Count(distinct) In A Table Bigger Than 100000 Records
Recently I started using MYSQL in my enterprise. I made a table which has around 100000 records. The problems is that it is really slow.. Im trying to do a query in which I get the number of distinct users per day. This is my query: select date(startedDate) as mydate, count(distinct(Users)) as users from Mytable group by mydate It is really simple and it does it correctly but it takes one minute.. One minute is not too much time but i need to insert around 10 000 000 records and thats what worries me.....
View Replies !
Slow Queries When Using Views Compare To Direct Table Queries
I’ve having problems with my server load for a while now. I have two tables with different content, but I need to display them in the same results, so I created a view with a union all (named: top_news_videos). The problem that I’m seeing is that when running a select to the view it takes a lot longer (and in that way, more server intensive) than running the query directly to one of the tables. For example, I created a page where I run 7 queries similar to this one: MySQL Code: ...
View Replies !
Cant Access Table
i have managed to set up a login system using mysql with no trouble. now i want to insert data from the mySQL table to a webpage, i have made the following PHP code (passwords and so on ive left out :) but there right): <?php mysql_connect("host", "user", "pass")or die("cannot connect"); echo "Connected to MySQL<br /><hr />"; mysql_select_db("members") or die (mysql_error()); echo "Connected to Database<br /><hr />"; ?> i tested the first part and it connects to the database, however when i connect to the table it comes up with: Access denied for user 'user'@'%' to database 'members' i dont know whats wrong? the only thing ive seen is in my mySQL database it says No Privileges on the main screen could this be it? its a college created account so they could be blocking me.
View Replies !
Can't Access Table
I ran a php script to delete about 4 million rows from a table with about 10 million rows. Waited for a while (20 minutes?) and it seemed to be stuck so I killed the script. Now I can't access the table (although I can access others in the database). What can I do to unlock or free up the table again? Would restarting mysql do it? Is there a way to do it without restarting mysql? mysql version: 3.23.58
View Replies !
Transfer Access Table
I am working on a client's site that is on a server hosted in Germany. Communicating with the hosting company is not possible, but I have been given access to phpMyAdmin and can access the database for the client. I have an Access database that has one table in particular with Data that I would like to transfer over to the mySQL database. Is this possible? I am now downloading a program that will convert the databases, but what about getting table a from DB A to DB B?
View Replies !
Importing Table From Access
I've got a problem when I try and import a table into a MySQl database using MyPHP Admin and the Import CSV using LOAD DATA option. For some reason only the last record gets imported, although there are almost 700 records in the table. I regular import data into two other tables using the same method without problems, so I'm pretty sure I've got all the right parameters set up when exporting the original MS Access table as a CSV .txt file.
View Replies !
Access Denied On Individual Table
Trying to insert records into 2 tables of the same DB, using Coldfusion query. It works on the first table, but on the second table I get 'access denied', although I'm providing the same username/password. When removing the username/password from the query for the second table, it works! I'm confused, because the table should have inherited the DB privileges (no table privileges set).
View Replies !
Error Accessing MS Access Table
In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each datasource. I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked.
View Replies !
Backing Up A Table ... But Being Able To Access The Backup
I am making a database that has ordering information on it. When someone places in order it gets approved or not. When a order is placed, I want to backup the data(where it still can be accessed) and the orgainl database cleared so more orders can be placed(new ones)That way the old orders and the new orders do not get mixed up. So what I want to do is back up the orginal database and still beable to access it. Does anyone know if that is possble?
View Replies !
Upload .mdb Access Data Into MySQL Table
I'm new to mySQL, but used to SQL Server.....which I'd be using DTS for this whole process. I'm glad to have to learn to do it with mySQL though. I have an Access .mdb file, that I need to upload from my local machine to our hosted mySQL site via BlueHost. I'll be using phpMyAdmin. It looks like the only way is to import into an existing table is from a text file. Are there any other ways to take the .mdb file and copy it up, and into the mySQL table? I got a converter tool, Access2MySQLPro 5, which has 10 trial conversions. Didn't know if anyone else has better ideas? Basically, I want to take this .mdb file data and put it on the mySQL table.
View Replies !
Access > Odbc > Mysql | Locked Table?
i have a mysql db and an odbc connection setup to it under user root. i need the odbc connection so i can have connectivity in access 2000. select queries work fine. i can view the tables in access etc. however update queries won't work for me. i know last week it worked, and this evening after it not working i opened up another copy of the database and it worked on that one... but only once, i went back and it didn't work in that one either. and for the life of me i cannot figure out what would be different with the database now. the error i'm getting is just the generic: "can not update 3 records due to lock violations" however, what is locking odbc/access out of the mysql db? is it mysql? is it odbc? or is access locking the records? im sure it isn't mysql, and i think it is odbc but i don't know where. i downloded new drivers for odbc. i thought about updating the access jet engine but couldn't find updates... Code:
View Replies !
Trouble With Export Of Access Table Into Mysql
I exported some tables out of access into mysql and I cant edit and records under mysql root account through mysql's query browser. I can edit from mysql command line using same credentials while working localy on the mysql server. Wondering why Query broswers Edit button is greyed out.
View Replies !
Configure 2 Sites To Access One User Table
I have two databases on the same server with different domains. I would like both sites to access the same user database table. They have the same fields. I thought that it might just be done with an mysql command, which will point one table to the other.
View Replies !
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
View Replies !
For Low End Machine
I am developing a Java Swing application for a low end machine (256ram). I need a database which will store some tables. Most of the tables will contain only a few hundred records. There will be a postcode table containing around 1 million records which consists of three columns, postcode, house number and street name. Could I install mysql server on this type of machine and would that table be too large?
View Replies !
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.
View Replies !
|
TRACKER
