MAX OPEN CONNECTIONS
My site has available by default 15 connections to MYSQL. Many connections remain open for much time, so when a new user enter the page it shows a message UNABLE TO CONNECT TO DB. How do I avoid this, without need change the number of connections of the server?
View Complete Forum Thread with Replies
Related Forum Messages:
How Many Connections Are Open?
We have a large database that has suddenly become extremely slow. It is running on Fedora core 4. How can I find ou thow many connection are open? When I look at CPU usage thru CPanel this appears to use a lot of CPU, sometimes over 90% /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mail.realivent.com.pid --skip-external-locking
View Replies !
Number Of Open Connections
our J2EE application opens connections to a mysql server. I would like to know how can I use the mysqladmin (or any other tool) to get (at a given time) the number of open connections.
View Replies !
How Do You Open Mysql To Outside Connections?
I have a DB server and an APP server. I am trying to open MySQL on the DB server so the APP server can connect to it. I did the command: GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PW' WITH GRANT OPTION; However, it still won't connect.
View Replies !
Open Db
When I open Mysql, I see the command line, although I see no commands for opening a db. Likewise, I cannot find anything in the help file..... Double clicking on the file does nothing...
View Replies !
How To Open My.cnf?
!I would have some configuration need to be done in the file of my.cnf in xampp.However it showed as a SpeedDial in Windows,how can I open it?
View Replies !
Connection Take 30 Sec. To Open
I am using the ADO.Net Provider from mysql and the connection takes *forever* to open. Well maybe not forever,but it takes 30 seconds.And each time I modify my *.aspx page I have to wait another 30 seconds to see the result.
View Replies !
Open Second Database
i have a db opened and run sql with mysql_query($query) now what I want to do is open a second database -- run one sql insert statement and close the db.
View Replies !
Open MySQL Files
Is there a danger limit to how many often used files (tables) mysql can have open. I currently run mysql and it has about 3000 tables total, thats 9000 open files in total if you cound 3 files for each table.
View Replies !
Can't Open File (errno :1)
I'm doing a project with Visual Studio.net with database(there's 4 tables inside it)on MySql.But I'm having problem connecting them both..I've done the programming codes but when I try to open my database in QueryBrowser.it says "can't open file (errno :1)" n below it would be "A MySql error was encountered. The message is : cannot fetch table information. The following error occured. Can't open file". It's the same with Visual Studio.net whenever I execute it..it says "type mysqlconnection/mysqldatareader is not defined"
View Replies !
List Open Tables
I have been having trouble with the number of open tables in my mysql database. I have mysql 4.1.18 running on Windows Server 2003. Basically, I have a few instances of PHP-Nuke running, and a version of Xaraya, and some other handwritten apps. Lately I have been having trouble with the number of open tables. Sometimes it reaches close to 500 and they don't go away or close themselves. Is there anyway using MySQL Administrator to view a list of currently open tables so I can see what is in use?
View Replies !
Can't Open Priviledge Tables
Trying to get mysqld running on my Slackware 10 machine and seeing the following error: Fatal error: Can't open priviledge tables: Table 'mysql.host' doesn't exist Any ideas?
View Replies !
Open Additional Port
I need to access an external MySQL db through a firewall. I'd like to open up an additional port (leaving 3306 as is) to the same MySQL instance. For example, I have my mail server running on both ports 25 and 26 (ISP blocks outbound 25).
View Replies !
Mysql On Open SUSE 10.2
I installed open SUSE 10.2 and it works fine. I tried to look at Mysql. No it didn't work. --------------------------------------------------- niss@linux-flei:~> mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) niss@linux-flei:~> show databases; bash: show: command not found niss@linux-flei:~>
View Replies !
Open Session From Client
I have Mysql running fine on a Linux box. From host I can run mysql and mysqladmin without problems (MySql root user hasn't password yet). Now I would like to execute some sql commands from MySql administrator running on a windows PC. but when I tried to open the connection the error 1130 appears. What can I do to do SQL queries from Windows (or any other supported OS) to MySql server? Host server has firewall disables (to avoid any problem).
View Replies !
Database Won't Open Anymore
Then I downloaded Xampplite and am running Apache and MySql (same version as previous)so I can see the php stuff I am adding without having to publish remotely every time. I moved my database to the new MySqlData directory. I can see the database/table, but can't open it. the previous MySql has a password to access, now it goes straight in. Is this the issue?
View Replies !
FD Still Open But Files Are Deleted
on 2 of my servers running mysql 5.0.67 . File descriptor remain open while the files are deleted. After a while it fulls my /tmp . Filesystem Size Used Avail Use% Mounted on /tmp 9.9G 1.1G 8.3G 12% /tmp [root@maestro tmp]# du -sh . 14M . [root@maestro fd]# /usr/sbin/lsof -s +L1 /tmp/ COMMAND PID USER FD TYPE DEVICE SIZE NLINK NODE NAME cmasm2d 4464 root 3r DIR 253,5 0 0 145363 /var/spool/compaq/hpasm/registry/crib (deleted) cmasm2d 4469 root 3r DIR 253,5 0 0 145363 /var/spool/compaq/hpasm/registry/crib (deleted) mysqld 5648 mysql 6u REG 253,3 10599 0 20 /tmp/ibF3ScMx (deleted) mysqld 5648 mysql 7u REG 253,3 0 0 21 /tmp/ibIOB0yu (deleted) mysqld 5648 mysql 8u REG 253,3 0 0 22 /tmp/ibt1wOlr (deleted) mysqld 5648 mysql 9u REG 253,3 6646 0 24 /tmp/iblKFAsp (deleted) mysqld 5648 mysql 18u REG 253,3 0 0 25 /tmp/ibSG0pXV (deleted) mysqld 5648 mysql 32u REG 253,3 18974469 0 31 /tmp/MLG5sFxo (deleted) mysqld 5648 mysql 36u REG 253,3 17973782 0 32 /tmp/MLgMLlfs (deleted)...
View Replies !
Open A File In The Database
i would like to load data in my database from a file and i do: mysql> SOURCE "C:Documents and SettingsuserDesktopcreate_sql.txt"; ERROR: Failed to open file '"C:Documents and SettingsuserDesktopcreate_s ql.txt"', error: 22 mysql> It's just that i would like to create a table using a file.The file already consists of statements like : create table Store(sid integer, address varchar(20), eid integer, name varchar(20), primary key (sid)); What am i supposed to do in order to create tables using a file?
View Replies !
Open Local Database
I have a file called local.db. I suspect that this is a MySQL database. How do I verify this and how do I open it? I have installed the Administration tool and the MySQL server database on my local machine.
View Replies !
Failed To Open File
I get the error failed to open file and then the filename.. wondering how do I get the file to open / where do I stick files to open them. trying to create the database from script file. I used: source create_dd_database.sql; also tried: source . mysqlcreate_dd_database.sql; the file is currently in c:mysql I don't get how to specify for it to look in the c:mysql directory for the create_dd_database.sql file.
View Replies !
Can't Open Mysql Table
I can no longer open one of my tables. I get this error: Can't open file: 'top_horses.MYD'. (errno: 144) When I view all my tables, this particular tables says "in use". I think I inadvertently clicked on "repair" table.
View Replies !
Connection Must Be Valid And Open
I am getting an "Connection must be valid and open" error. After some research I have found two possible reasons for this: malformed sql or bad connection string. Since the error is being thrown on a second .executescalar statement I will assume the connection string is working. I have two questions. First - if I can cut and paste the sql statement into mySql's query browser and it returns the information, is the sql malformed? (e.g. select user_id from cms.accounts where user_id='scott@scottrider.com') Next - are there other reasons for the error message.
View Replies !
#1016 - Can't Open File
one of our client was working on a stsyem when suddenly they cant insert any record. they gave us a copy of their livedatabase and when i studied the database, the table concerned was "in use". when i try to repair it, optimize or whatever, it returns an error #1016 - Can't open file: 'license.ibd' (errno: 1) i research a bit but i cant see a proper tutorial in repairing this error. the database is in myisam, so i dont have any *.ibd file in my database directory. other tutorials on how to solve this covers recovering the table, but i cant see how their solutions can recopver the data itself.
View Replies !
Mysql.exe Will Not Stay Open
I'm trying to install MySQL and PHP on my Windows XP computer. I have followed Kevin Yank's book, followed another tutorial, reinstalled Windows XP twice on this machine, installed MySQL and PHP many times (after uninstalling). I've tried installing on an other machine. "Dr. John" and "Mainlink" suggested that I "use xampplite to install apache, mysql, php etc" - I tried this, after a reinstalling Windows XP. All works well, including the PHP test ("today.php"), till I try to open "mysql.exe". The "command prompt/dos" window flashes up, then disappears immediately. Can anyone please point me in the right direction?
View Replies !
Open Source Question
We are in the process of designing and building an application to collect a relatively small amount of discrete data (less than 100 data elements) from a potentially large group of industrial facilities. This system needs to be Open Source so other organizations can use the application by simply "plugging" in the app to do authentication/authorization (Open LDAP?) with a home-grown security design, access a web app (J2EE & probably Linux O/S), and MySQL as the backend. Certainly it's more complicated than what I describe, but I have my doubts of the capabilities of MySQL to be "robust" (yuk, I hate that word) enough to handle the potentially large number of simultaneous connections, among other issue including remote connection to Oracle DBs. I'm new to the organization and my boss's boss is the driving force behind the development. He's gung ho to get it built, but (beyond the political nightmare) I would like to "caution" him that the chosen platform is suspiscious at best.
View Replies !
Merge Table: Too Many Open Files
my problem: I merged about 1.000 Tables with Create table name (variables) type=merge union=(table1,table2,...,table1000); MySQL now creates a tables, but I can't open it. Everytime I get the message: Error 24. Which means: 'Too many open files'. I tried to tune the server by setting the variable for open_files_limit to 10.000. But still the same problem.
View Replies !
Window With The Mysql> Stay Open
I have installed PHP MySQL and Apache on my system with the intention of using it to run my website with a database. I have managed to get PHP and Apache working fine but to date have not been able to get MySQL to work. When entering a command in the Windows XP prompt I get a window flash on the screen for a second and then it is lost. How do I get this window with the mysql> prompt to stay open on the screen. Look forward to help with this as I am now contemplating abandoning the whole setup and reverting to using the Windows IIS instead.
View Replies !
Can't Open And Lock Privilege Tables
I have just installed MySQL 5.0 for the first time. When I try to start the server under my user name I get the following error message: 060818 10:45:45 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist What does this mean and what can I do about it? I have given mysqlf access to /var/lib/mysql.
View Replies !
Can't Open Pdf Link Created In PHP/MySQL
I created a MySQL database with all the pdf papers on my HD. The path to a pdf file is stored e.g. D:DocsPapersBerg2003a.pdf In php I do the query and output the link: echo "<a href='file://" $row->pdf ."'>pdf</a>"; But when the page is generated and I click on it nothing happens. If I do right click, copy link and paste it in the browser field, the pdf file opens though! Looking at the html code, it reads in Firefox: <a href="file://D:%5CDocs%5CPapers%5Cwind03%5Cpdfs%5Berg2003a.pdf">pdf</a> and in IE6 <a href='file://D:DocsPaperswind03pdfsBerg2003a.pdf'>pdf</a> I have also tried .str_replace('','/',$row->pdf) but with the same result.
View Replies !
Unspecified Error In PRecordSet->Open
I am getting an "Unspecified Error" for pRecordSet->open(). The error code is null. How do I go about solving this problem. Here is the code snippet if(pRS) { pRS->Close() pRS = NULL; } HRESULT hr = pRS.CreateInstance (__uuidof (Recordset)); pCmd->CommandText = strSQL; hr = pRS->Open ((IDispatch *) pCmd, vtMissing, adOpenForwardOnly, adLockOptimistic, adCmdUnknown); //This line causes Error
View Replies !
Cannot Open File Provider=MSDASQL.1;
I'm using Navicat to import some tables into my MySQL Database but I get a weird error and was wondering if anyone around here knew how to resolve it. I feel like it's because I'm trying to make a SQL Server Database and MySQL Database, maybe I need some drivers. The error is: Cannot open file Provider=MSDASQL.1; Persist Security Info=False;....
View Replies !
How To Open Exisiting Files In Mysql
I am learning mysql. I have installed and try to practice some of the commands in the manual. I have many files (very big in size) which I am trying to open as tables in mysql and manipulate the data (for example, I want to open multiple files and merge then based on dates (as a primary key) (bring all fields which have the same time stamp ... for example. We have thousands of files for which I want to create database.
View Replies !
Installation :: Unable To Open Manual
I'm really new on MySQL; I installed it on Win XP.The first problem is that I can't open the manual, the system gives me this error"unable to open file mk:@MSITStore:<MySQLdir>manual.chm".How to fix it? Trying to test the installation I typed in the shell "mysqlshow" and it gives me the error "Access denied for user 'ODBC'@'localhost'(using password NO)". In the reference manual I found that I "should create a file named windowshosts containing the following information: 127.0.0.1 localhost".Which extension? The name of the file is "windowshosts"?Where have I to put it?
View Replies !
#1016 - Can't Open File: (errno: 144)
I've got an invision board forum, and today when I tried accessing parts of it I get errors saying "mySQL error: Can't open file: 'strabo_topics.MYI'. (errno: 144)" so I went into phpMyAdmin and tried to repair the table and found there were 2 othjers with the same problem and when I try to repair them I get the following: Code:
View Replies !
Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
View Replies !
Can't Open And Lock Privilege Tables ...
My server was running fine then all of a sudden it stopped working. The error log shows the below. I've tried everything listed in the other parts of the forum regarding how to correct this but it is not corrected. I can't get the MySQL deamon to even start to do half the recomendations. I'm quite frustrated. Could someone please guide me on how to resolve this issue and why it happened in the first place: 060616 21:58:20 [Warning] No argument was provided to --log-bin, and --log-bin-i ndex was not used; so replication may break when this MySQL server acts as a mas ter and has his hostname changed!! Please use '--log-bin=enssbos-bin' to avoid t his problem. 060616 21:58:21 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060616 21:58:21 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 1 385924437. InnoDB: Doing recovery: scanned up to log sequence number 1 385924437 InnoDB: Last MySQL binlog file position 0 818470773, file name ./enssbos-bin.000 038 060616 21:58:21 InnoDB: Started; log sequence number 1 385924437 060616 21:58:21 [Note] Recovering after a crash using enssbos-bin 060616 21:58:21 [Note] Starting crash recovery... 060616 21:58:21 [Note] Crash recovery finished. 060616 21:58:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 060616 21:58:21 mysqld ended
View Replies !
SELECT Min, Max, Open, Close (trades)
I have a table (trades) with some stock-trades It has the following fields id (autogenerate, key) stock (int) tradetime (datetime) price (decimal (10,4)) stockcount (int) Now it would like to make an SELECT from 'trades' that will give me min (the smallest price value) max (the largest price value) open (the first price value, - i.e. the price for the trade with smallest tradetime and should there be more smallest id) close (the last, - like open but opposite) GROUP BY stock, LEFT(tradetime,10) WHERE "some where clause that will select fewer dates and/or stocks, - I'll will vary (but generally include a stock = N and I don't think I'll get into troubles with this part) MIN and MAX is quite simple But how do I do open and close?
View Replies !
Allow Outside Connections
i need to be able to connect from one server to another... i need to know how to allow outside connections. so i can use blah.com as the host instead of localhost or is this turned on by defult in MySQL??
View Replies !
20 Connections
Is it normal for mysql's performance to plummet when it hits about 20 connections? These connections are all from scripts running as cron jobs. I have max_connections set to 500 and max_user_connections set to 35.
View Replies !
|
TRACKER
