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
See Related Forum Messages: Follow the Links Below to View Complete Thread
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:
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.
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?
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.)
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.
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?
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?
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
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....................
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?
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
Basically I am setting up php,mysql and apache to run an application. While trying to connect I get the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:sudhirapachehtdocssvgmap est4.php on line 14 Cannot connect to the database. Client does not support authentication protocol requested by server; consider upgrading MySQL client I have tried the following message posted earlier by many of you guys i.e "SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something') flush privileges I am trying this from a long time and do not find a way to fix this problem I request you guys to help me in soughting this out and I appreciate your patience in reading my post.
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?
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:
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.
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.
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:
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.....
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) ?
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.
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.
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? Code:
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.
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? Code:
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.
"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.
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...)
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?
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.
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?
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?
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.
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?
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 ?
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?
List All Clients Not Assigned To Current User (was "Query Help Please")
I have two tables like this: *clients -- client_id -- client_name *manage -- user_id (multiple entries possible) -- client_id To assign clients to users there is a entry in the manage table of the user_id and client id. I want to list all the client_ids and client_names that are not assigned to the current user_id say 1.
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.
Client API
I'm using a password with a user of mysql! when i try to load my web application its now telling me to update my mysql client program! I have the latest server..ie v5.0.0 and when i run phpinfo() its statesw that the current mysql client api is 3.23.56! How and from where can i update this api?
Client API
How do I upgrade MySQL client API from 3.23 to 4.x for PHP? I've got the following: MySQL 4.11standard Centos 4.1 PHP 4.3.11 MySQL API Client 3.23 (this is what I need to up to 4.0) Cpanel 10.x Methods tried: WHM (cPanel's web host manager) Update Apache /scripts/easyapache /scripts/mysqlup --force
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?
Slow
What generally would be the reason why all my db driven sites are running slowly or even hanging. I am on braodband speed but just changed hosts.
Client Drivers
I have noticed that MySQL 5.0 and 5.1 beta are now released. I have a network with over 300 stations accessing a MySQL server but I think it's MySQL 4.1 and I think we are using the 3.51.12 MyODBC connector drivers on them. Now my question is if we upgrade to MySQL 5.0 will we need to update the driver or will this work with 5.0 and 5.1?
Server-Client
------=_NextPart_000_004C_01C3507A.4005F3F0 Content-Type: text/plain; charset="windows-1254" Content-Transfer-Encoding: quoted-printable Hello, 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. H=FCseyin DEM=DDRA=D0 =DDstikbal Furniture =DDnt. ------=_NextPart_000_004C_01C3507A.4005F3F0--
Client Does Not Suport
Whenever i try to connect to my database through php, it keep saying: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:... on line 6 I'm using Apache 2.0.52, Mysql 4.1.8 and Php 4.3.10... and win 98.
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?
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.
|
TRACKER
