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 Complete Forum Thread with Replies
Related Forum Messages:
Mysqlcheck: Clients Are Using Or Haven't Closed The Table Properly
I'm using the command mysqlcheck --all-databases --auto-repair --silent and I see these warnings (listed below) on a daily occurrence. Is mysqlcheck causing these warnings? I can't see how a table can close inappropriately. How can I prevent this. Hoping to here from MySQL users who have came across this. I'm using MySQL 4.1.11 on RHEL. Code:
View Replies !
Multiple Clients, One Table Or Each A Table
I have been using SQL for a few years for small projects, but recently I have a client who wants a contact system for about 1000 users to use and each user will have about 1000 contacts. My question is should I make a table for each user for their contacts or store all 1,000,000 contacts in one table and then have the system sort through them to display each user's specific contacts. I am trying to find the quickest way for my system to display the contacts. I have read many things on multiple databases or one but I was wondering if I should have a unique table for each user to store their contacts in or have one massive table with everyones contacts?
View Replies !
Non Networked = Non Secure
mySQL looks good for a Network. BUT as a standalone it is not secure.Open anytable.MYD in a hex editor and you can see the data.So we can't sell our software to clients on wind98. Believe it or not we have had a lot of success selling software with a proprietary database where the data is in 'unusual' format. Clients are happy because casual snoopers can't see personal data,and we dont promise "strong" security. Security through obscurity works!I wish mySQL had even a touch of obscurity in its MYD files.
View Replies !
Representing Networked
I'm trying to design a system for my work where different admins can add people connected to them. At the bare bones, this is just like a social networking site like Friendster. From a database perspective, how do you implement a representation of people being linked to a variable number of other people. I was originally thinking to use some kind of variable array attribute in the person table. The only option is SET but that only allows for 64 items. Are there any efficient and flexible ways to implement this "social networking" structure?
View Replies !
MySql Local / Networked
I have been asked to set up a local offline website to update and manage our current office inventory list. The 3 computers this needs to be accessible to, all share a networked drive. Is it feasible, that I could locally install a WAMP configuration (Windows, Apache, MySql, PHP) to make this all come together? Would I be able to configure the MySql database to be accessible to all computers from the networked drive? Are there any other factors I should know before I begin with this project, or is there a simple better way to do this (other than fully hosting the page online.)
View Replies !
How To Setup Symbolic Links To Networked Drives In XP
I want to setup a database symbolic link within Windows XP to a network drive which has significanlty more space available and can't seem to get it working. Here is my setup.... - I am running MySQL 4.1.7 - I have tried this with both the 'mysqld-max' and 'mysqld-max-nt' servers - Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in the C:MySQLdata directory which references the "linked" database direcotry. - If I setup the .sym file to reference another disk local to the machine (e.g. D: running the server it works fine. - If I setup the .sym file to reference to a networked drive it does not work. I have tried referencing the networked drive by the mapped drive designator ("Z:"), by remote machine name (" emote_host"), and by IP address. Has anyone set this up? Is there something I am missing?
View Replies !
Mysql Downloads
am working on linux 2.4 kernel, fedora core 1.1 version. can anyone suggest which version of mysql is supported for the above configuration. also, plz send me the websites from which i can download & what are the mirrors i need to download for working with mysql and conecting mysql to perl
View Replies !
Which Set Of Downloads Do I Select
I'd like to download MYSQL. I have Mandrake Linux 10.0 on a Pentium 4 box. When I go to the MYSQL site to download the application for Linux I find a miriad of what appears to be different versions. Can anyone tell me which downloads I need for my machine?
View Replies !
Corrupt Downloads
I'm trying to download MySQL but no matter which mirror I download the zip file from the file I get doens't work. My computer keeps saying it is "no zip file, bad zip file or part of a split/spanned zip file" What am I doing wrong? And can anyone point me in the direction of a good tutorial on running it locally when I finally get it installed?
View Replies !
Limiting Downloads
I have the task at hand of limiting the number of downloads that a registered user has access to on a site I am helping out with. I have a way to count the downloads by a user, but cannot seem to find the way to limit them. Does anyone know a tip for this or perhaps a link to some kind of tutorial? I am fairly novice with MySQL.
View Replies !
Counting Records For Downloads
I have a downloads system on my website, and for each download I make an entry into a log database, which contains the userid of the person who downloaded it, the fileid, and the date it was downloaded (stored in unix timestamp). Now, I want to make a stats page, that shows how many file are downloaded each day. How do I group this query? I can't just do it normally via the date field because the value in each record will be different even if they are on the same day. So, basically I want to count all records grouped by each day, although the date field on each record will be different. How do I do this?
View Replies !
10000+ Ebooks Downloads
DOWNLOAD ANY EBOOK WHICH YOU WANT download the link opposite to the name of the book .It contains the description of books and their direct download links. S.NO NAME OF THE BOOK - DOWNLOAD LINK 1 2 GB of Chemistry Books Part-1 to part-6(total 6parts) - http://depositfiles.com/files/56920 2 3d modelling ebooks(9 books) - http://depositfiles.com/files/569714 3 7-aircraft design books and 20 books about defense systems - http://depositfiles.com/files/569275 4....................
View Replies !
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error. Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?
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 !
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 !
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 !
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 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 !
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 !
Max Clients
Can mysql handle 5000 concurrent webusers sending queries to the db through a web search engine. Is it possible (with a very big server/hw) ?
View Replies !
Two Clients On The Same DB
I have a simple database that contains only Berkeley tables. MySQL v. 3.23.47 on Linux Mandrake 8.2. Now I try to explain what happens when I'm connecting with two clients: 1) Establish one connection with Client 1 2) "Set Autocommit=0" for Client 1 3) Connect to a DB (for example DB Y) 4) Perform a simple SELECT to a Berkeley table (for example X) and read the result of query 5) Establish a second connection with Client 2 6) "Set Autocommit=0" for Client 2 7) Connect to a DB Y (the same of Client 1) 8) Attempt to perform an INSERT of one record to table X At this point the Client 2 waits until the Client 1 issues "commit;" (or rollback;"). In the other words you cannot perform an INSERT in the tables even if the Client 1 has done a simple SELECT. It seems that there is a transaction still active in the connection of Client 1. I have done the same test also with MySQL 4.0.11-Max on Linux Mandrake 9.1 and I have obtained the same result.
View Replies !
About Clients
Althought I 've install the packet of mysql4.1 (which mean It should include an update client),what I got (from phpMyAdmin) are these: Error: 1251 SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE) Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
View Replies !
Aborted Clients
We came in this morning and were greeted by our DB server rejecting connections to the db from our application. There seems to be a high number of Aborted_clients. How can we tell what clients/connections are causing this?
View Replies !
Top 5 Clients Per Vendor
I need to select the top 10 clients for each of my Vendors (about 3,000 vendors) in a single list. How would I approach this? I have a Vendors table (vendor_id), a Sales table (client_id, product, date, sale) and a table connecting both (client_id, vendor_id) and I need just a list like (vendor_id, client_id) with the 10 best clients for each vendor. Any Idea? (stupid question I know you do have ideas...)
View Replies !
"2 Clients Are Using
I was in phpMyAdmin and ran a check against my tables, and received this message on several of my tables: "2 clients are using or haven't closed the table properly" I was curious as to what might cause this, I think I know what it means, but don't know how to stop this from happening.
View Replies !
MySQL & Clients
Our current Access databases are becoming a bit overworked as there are hundreds of records being added daily and "database locked; could not update" is a rather regular error. My boss wants us to use OpenOffice and a free database program on Windows XP Pro. To explain what we do: For every item that we test we enter the details into the database and then print out a form as a spec sheet to attach to the item before it goes into stock. Theres also an ActiveX control which we use to generate a barcode for the serial number on the spec sheet. Now I've had a quick look at MySQL and appartenly MS Access databases can be migrated fairly easily to MySQL however I have absolutely no knowledge of MySQL and having looked briefly at it, it looks scary! My question is: Is theres a client thats easy to use on which I could replicate my spec sheet form (and data entry) which will access the MySQL database? Ideally I'd like to use a web-based client so that anyone in the company could access a MySQL database via a browser to get the details on the tested items and be able to modify the data if they have permissions to do so.
View Replies !
Different Behavior Of Clients
There is problem. diffent MySQL clients have different behavior. I used simple sample from mysql manual (for example) : SET @t1=0, @t2=0, @t3=0; SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3; If I paste it in command line, it works good. But, then I tring to execute it Query Browser, I got error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3' at line 1 If I use .Net client library mysql-connector-net-1.0.7, I got same error message.
View Replies !
Benchmarking W/ Multiple Clients
I'm looking for information on good benchmarking implementations with which to test MySQL using multiple clients. The benchmark utilities included with MySQL are, as far as I understand, an implementation of the old Wisconsin Benchmark, and as such are designed to test only a single client sending queries to the database. Are there any implementations of multiple client benchmarks (ie TPC-C) that are freely available? There is one of TPC-W, but I'd rather not use that. Or would I be better off simply modifying the MySQL provided benchmark to incorporate the multiple client concept. Changing the scripts so that they don't conflict when multiple clients run is easy enough, but are there any large changes in general methodology between the two types of test?
View Replies !
Protocol Used Between The MySQL Clients
I'm looking for documentation on the wire protocol used between the MySQL clients (odbc, jdbc, etc)and MySQL server. Pointers to files in the source code would be great too. I've been browsing the source but haven't come across any key headers or source that documents/implements it.
View Replies !
Safe-updates From All Clients
This is version 5.0.24a on a Windows based machine. If safe-updates is specified in the [mysql] section, if using the MySQL command line client, safe-updates does work! However, if using another client, or a web page for example to access the database, safe-updates does not work. Is it possible to have safe-updates work in all clients, such as through connector/ODBC? safe-updates in the [mysqld] section does not work (the server will not even start with it there). So the question is: Is it possible to specify safe-updates somewhere so that it is global to every connection that accesses the database no matter what the source is for that connection?
View Replies !
Automatic Update On Clients?
I'm developing an application wich saves data on an SQL Server Express database, but I'm planning to upgrade to MySql. Only at the server is the program wich add registries, occasionally the clients could add information. Here is the problem: Is there a way on MySql where the information on the clients is updated automatically? something like if a register is added to tell all the clients immediatly, because is crucial for the clients to have the latest data in real-time.
View Replies !
Power Mysql Clients?
I'm reviewing mysql clients for power users and haven't been impressed. What good clients can someone recommend? The default client from mysql, QueryBrowser,is weak and won't suit our needs. We have very complex multiple queries and need to see where they crash, when they crash. Querybrowser won't show the return message history. We use to use Sci Bit's mascon, but it got outdated when 5.0 was released. Their replacement product is shoddy compared to their old one. I kind of like AquaFold's client, Aqua Data Studio. Its what I'm looking for. But I was hoping for something open source. We moved our servers from Win2k to Ubuntu, I still have employees on WIndows boxes and they need a good client to work with. I own a small datawarehousing company for oil and gas data. Our workload is kind of heavy, we have something over 20,000,000 records that we screw with and have high standards from a client.
View Replies !
Access Tables From 2 Clients At The Same Time
if I want to use MyISAM tables in a DB from 2 different clients (from an application) which can manipulate data at the same time. This works good for about a month but now I have an error that a fieldvalue of a record was suddenly changed but there is no way to do that by the application. The field has got the data of an other record (so I have this twice), but this value can only exists once. The rest of the data of that record is still correct. Does anyone know what the problem is?
View Replies !
Multi Clients , No Refresh Data
I'm using C# and Mysql 5.1.0.... I ran two, the same applications, just like someone would run it on two different mashines .... to simulate multi clients connected to the same DB lets presume i can have max 6 records in the table (some constraints ...) If I would insert 3 records from client C1 into table A and Commit, and then from client C2 also 3 record into the same table A and commit .... everything is ok ... but if I go end delete 1 record from client C1 .... and try to insert 1 record from client C2 ... client C2 doesn't knows that there was one record deleted from client C1 and still holds 6 records in his storage ... .... Why ?? I'm using DBAdapter.Fill for read .... If I reconnect to the DB then the changes are seen, otherwise there are not ... Any clues ??? So what I'm saying is that client C2 still carries the all 6 records instead of 5 ... Do I need to set something into connection string ?
View Replies !
Custom Columns Created For Clients
I have an odd problem that I need a solution for. I have a table that has perhaps 10 default columns. My clients need to be able to add their own columns to this table independently of eachother. I would also like the solution to work with link. I prefer to not create a unique database for each client.
View Replies !
Embedded MySQL Server Within My Clients Program
I've installed the last stable MySQL version (4.0.14-standard) under Linux, (Suse-8.0) kernel 2.4.28-64GB SMP, form the binary distribution that i downloaded from www.mysql.com. I'm interested on implementing the embedded server within my clients programs but the distribution do not have included the libmysqld.a library. There is a possible solution to this without having to get the source and compile it.
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
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 !
CLIENT
I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but that's the stuff I have to work with). Yesterday, a script that ran without problems for months suddenly stopped working on my server. I identified the problem: Suddenly, MySQL has decided that CLIENT is a reserved word. The same script is still working fine on my local machine (also IIS on a Wín 2000 Server). Anyone have any idea what could be wrong - and how to fix it?
View Replies !
SQL Client
I've got an SQL script (fred.sql) saved which I want to run from the sql client command line - how do I load the script into memory - basically I want to see what errors I get from the "load data" statement and I don't want to have to keep typing long statements in.
View Replies !
Client Only For Win98
I have a small LAN with my workstation (Win98SE), a Win/2000 system and a Linux system. I have MySQL servers running on the last two systems and I want to put the client software on the workstation. Is there a separate package for just client or do I need to install the whole client/server setup?
View Replies !
Server-Client
I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center.
View Replies !
|
TRACKER
