- Original Message -
From: Hiu Yen Onn [EMAIL PROTECTED]
if i uncomment it, then mysql server wont start at all. if i comment it,
then, that's ok. please advise. thanks again
If the mysql server does not start it will probably leave a lot of messages
in the error log. If you send the
Hi,
Is mysql_ping () suppose to restore a db connection even after a db restart?
Thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Please, send the output of the following statements:
SHOW CREATE TABLE country;
SHOW CREATE TABLE lang;
Include the CREATE statement for countrylang table and exact error number.
Guy Brom wrote:
I have the following innoDb tables:
country has `id` as PK
lang has `id` as
Hello.
Enable a General log and find out what is MySQL thinking about the host
from you're connecting to it.
Ben Clewett wrote:
Dear MySQL,
A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign server 'pho.com' with IP of
Hello.
It looks very weird for me. I don't have an access to AIX machine, so I
suggest you to use gdb and research where MySQL is getting such an
interesting result. See sql/hostname.cc file from the source
distribution and:
http://dev.mysql.com/doc/refman/4.1/en/debugging-server.html
Hello.
Unfortunately, you can bind only to a single specific address.
Daniel Schaerli wrote:
Hi,
How is the sintax to in my.cnf listen only to specified ip-addresses or
ip-ranges? I tried:
bind_address 127.0.0.1 192.168.0.10 192.168.0.20
and
bind_address 127.0.0.1,
Hello.
There is no builtin possibility for this, but you may write your
own tool which will be parsing the output of 'mysqladmin processlist'
and invoke 'mysqladmin kill' for long threads.
John Ricci wrote:
Hi
Is there a way to setup a maximum query execution time per user. I
Hello.
i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replacethe
existing one (/etc/my.cnf). but, it failed to start the mysql server.
please advise. thanks?
What is in the error log? See:
http://dev.mysql.com/doc/refman/4.1/en/error-log.html
Hello.
If you want to enable large pages in the Linux kernel, run a quick
search in Google. I've found these links (ignore the 'DB2'
and 'oracle' in the URL:)
http://www.linux.com/howtos/DB2-HOWTO/kernels.shtml
http://linux.inet.hr/oracle10g_on_debian.html
Íõ Ðñ wrote:
I learn
Hello.
I get 142k rows back in just over 4 seconds.
It means that on the server side query works, so the problem
probably is in PHP.
However, when I run this query using PHP through the browser, I get
nothing at all. Occasionally, I get get an error about not being able
to store
Hello.
The fact is that I cant start mysql with ssl support using the
/etc/ec/d/init.d/mysql script. But the interesting thing is that if I copy
First of all, you should find the error log. See:
http://dev.mysql.com/doc/refman/4.1/en/error-log.html
Israel Fern$ndez Cabrera [EMAIL
Am Samstag 15 Oktober 2005 13:11 schrieb [EMAIL PROTECTED]:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/4350e3d50d20d7fc/tommi=tntnet.org
This confirmation serves two purposes.
Hi,
I have a problem with the statement-api. I try to select a value of type
decimal(12,2) from a mysql-database. To get information about this column, I
use mysql_stmt_result_metadata. The problem here is, that the type of the
column is 0. When I try to use it in a MYSQL_BIND-structure and
hi all..
I started a select count(1) command on a table in mysql, assuming it will
end soon within the off peak time..
But now the peak load time is about to start, so i tried to kill that
query..
logged into mysql as root.
show processlist for getting the thread id.
kill 85300 (thrad_id)
I am able to run DBDesigner4 under Windows but now good under Linux.
Try .rpm, .tar.gz, home install, all users install, still the same error:
Unable to load libmysqlclient.so
Put this in ld.so.conf, run ldconfig, nothing...
Changed startdbd script to force dirs path and nothing.
Need help on
Hi,
and you have a libmysqlclient.so ?
sometimes the lib is installed only with a libmysqlclient.so.xxx, and
the
packages don't install the libmysqlclient.so file, so all you have to do is
ln -s the lib to libmysqlclient.so
Verify this,
mpneves
On Saturday 15
Hello.
Do you have other queries which are running at this moment
on the server? The show-processlist.html says that thread
could be in Killed state if it is locked by another thread.
What version of MySQL do you use? What storage engine does your
table have?
Sujay Koduri [EMAIL
Hello.
In my opinion it depends on the value of reconnect flag (the part of
MYSQL structure). I've written a simple program which connects to MySQL
server,
waits a bit and executes mysql_ping. While it is waiting, MySQL server
is being restarted. If mysql.reconnect = 1, mysql_ping() returns
For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Hi,
I have just tried your routine, I use something very similar, (I have changed
the localhost to 127.0.0.1 so it will not use the pipeline) but I am still
expiriencing the same exact problem, weather reconnect is set or not, the
error remains the same. That is what got me wondering in the
Jigal van Hemert wrote:
- Original Message -
From: Hiu Yen Onn [EMAIL PROTECTED]
if i uncomment it, then mysql server wont start at all. if i comment it,
then, that's ok. please advise. thanks again
If the mysql server does not start it will probably leave a lot of
21 matches
Mail list logo