We am having constant index corruption problems since moving
from 4.0.17 to 4.1.3. All tables are InnoDB and we're using
the file-per-table setting on Solaris9.
Every couple days another few tables will show up corrupt
and queries start missing things. The database has never
gone down
Hi
Not sure if I should be posting to the DBI list really, but I will try
this one too.
I'm running suse linux enterprise server 8.2, MySQL 4.0.15-standard-log,
DBI 1.32
I get the following error message:
DBD::mysql::db rollback failed: ROLLBACK failed at dbirollbacktest.cgi
line 49
();
};
if ($@) {
print One of the SQL statements failed\n;
$dbh-rollback();
}
$dbh-disconnect;
Does anyone know why my rollback won't work?
Thanks
Mick
No idea, but you could try doing explicit commit/rollback and begin
transaction (I used it with Sybase without any problems). Maybe
I have a test.testac table created by a test script from a previous install.
It is of type MyISAM, which does not support transactions. Did you alter
or create your testac table to be of type InnoDB, which does support
transactions? You can check with
SHOW CREATE TABLE testac;
or
SHOW
Harrison wrote:
Hi, sorry about the long delay in the reply. I will be away for the next
2 weeks, but I will follow this thread if anything new comes up.
Hi,
A few more ideas you can try:
1. SET UNIQUE_CHECKS=0;
You have a unique key that is quite large (model, id name). If
you know the
any change,
but I don't expect it.
Luc
-Original Message-
From: Luc Charland [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 7:54 PM
To: [EMAIL PROTECTED]
Subject: Insert problems with InnoDB (big table)
We are evaluating the replacement of a Sybase database with MySQL
Hi Frank,
you actually got me doubting here. We don't use mysql client, but I made
sure that autocommit was turned off.
I double checked (with select count(*) from smalltest) to see the
inserts were in fact commited by chunk of 100,000 and not one by one,
and it was.
We still see exactly the
[EMAIL PROTECTED] wrote:
Estimado Luc,
Con fecha jueves 5 de agosto de 2004, 11.07.23, escribió:
Did you try disable index table? When you import millon of records
there is an overload indexing it. First import and then create your
index or:
ALTER TABLE tb_name DISABLE KEYS;
import data...
Hi,
A few more ideas you can try:
1. SET UNIQUE_CHECKS=0;
You have a unique key that is quite large (model, id name). If you
know the data is already unique (ie. importing from another data
source), then this can speed up the import *a lot*.
2. SET FOREIGN_KEY_CHECKS=0;
You didn't mention
Luc,
do you use the mysql client for the insert operations?
And is autocommit set to yes?
Then the answer is:
turn off autocommit mode and commit every high number but not too high
to grow InnoDB's transaction handling resources too big rows.
Commit every 100,000 rows for example.
The speeds up
Are you disabling autocommit before doing the inserts? And committing
after all inserts are complete?
-Original Message-
From: Luc Charland [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 7:54 PM
To: [EMAIL PROTECTED]
Subject: Insert problems with InnoDB (big table)
We
?
-Original Message-
From: Luc Charland [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 7:54 PM
To: [EMAIL PROTECTED]
Subject: Insert problems with InnoDB (big table)
We are evaluating the replacement of a Sybase database with MySQL. The
databases are 60+GB, containing more than 100
We are evaluating the replacement of a Sybase database with MySQL. The
databases are 60+GB, containing more than 100 tables.
Since we need transactions, that implies InnoDB. We were happy with the
early results, but we hit a major roadblock when trying to import the
biggest table (20+GB, with
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message.
The hostname on this box is a fqdn like blah.1.2.3.net. My command line
is
Can you check the host name again? You have a five segment address.
-Original Message-
From: Andrew Hall
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute
To: [EMAIL PROTECTED]
Sent: 7/28/04 3:55 PM
Subject: connection problems
Greetings,
I have what I hope is an easy problem. I have installed mysql 4.0.20
and when I execute mysqladmin to set the root password using the -h flag
my hostname is truncated, and I get a connection refused message
: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
Can you check the host name again? You have a five segment address.
-Original Message
Message-
From: Andrew Hall
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 7/28/04 4:35 PM
Subject: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16
Subject: RE: connection problems
Yes I have. The hostname of the box returned with 'hostname' is the
fqdn and is in the format of blah.1.2.3.net.
Drew
On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote:
Can you check the host name again? You have a five segment address
james patrick [EMAIL PROTECTED] wrote:
I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL
4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin
and MySQL 4.0.17.
I have a large database (200mb) and I'm trying to move it over.
200mb is not a large database.
I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL
4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin
and MySQL 4.0.17.
I have a large database (200mb) and I'm trying to move it over.
I made a dump using mysqldump -u USER -pPASSWORD DATABASE
filename.sql,
Jough P writes:
I upgraded from MySQL 3.23 to 4.0. I placed all the new mysql files in
/usr/local/mysql/bin, /usr/local/mysql/include and
/usr/local/mysql/lib. I compiled PHP5 and it is still using the 3.23
client API. So I removed all the old mysql files from /usr/bin,
/usr/include and
Greetings all,
I tried the PHP list with this one and can't seem to get an answer so I
thought I'd try here.
I upgraded from MySQL 3.23 to 4.0. I placed all the new mysql files in
/usr/local/mysql/bin, /usr/local/mysql/include and
/usr/local/mysql/lib. I compiled PHP5 and it is still using
Victor Pendleton wrote:
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running solaris 7
and mysql 3.23.48-max.
I also transferred the database to the new server and tried to connect
the database with mysql front. Everything worked fine.
Then
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The old server is running
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote:
Can anyone point me out what is going on wrong in this scenario?
The .err file in the datadir can give you a clue. Take a look at the end of it.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hello all,
I would like to create InnoDB databases within MySQL. I have installed
MySQL 4.0.20 and I have tried to uncomment the following on my
/etc/my.cnf. MySQL is run on top of Fedora Core 2 Linux.
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir =
to query with no problems. Crashes upon
mysql_num_res or mysql_fetch_rows.
gdb gives:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 3076 (LWP 23491)]
0x400519e3 in mysql_fetch_row () from /usr/lib/libmysqlclient_r.so.10
(gdb) bt
#0 0x400519e3 in mysql_fetch_row () from
Hi all,
I am writing a multi-threaded client that requires shared access to a single MySQL
connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm
installed and compiled with -l libmysqlclient_r.
The connection is made from the main thread and a MYSQL_RES* myres
If you have multiple threads accessing the same connection remember to
make sure that only one thread enters mysql_query() mysql_connect() or
mysql_store_result() after you store the result another thread will be
able to use that connection without problems.
-Eric
On Wed, 30 Jun 2004 11:01:35
Hi,
yesterday I installed the 4.0.20 binaries, compiled with Intel C++ Compiler from
mysql.com.
I tried to transfer one of our (small) databases from the production-system (4.0.20
gcc binaries installed) to the test-system and came across the following problem:
I did a mysqldump --opt ... |
don't do that, I have
problems with the data integriy because of the import
scripts.
--
mysql SELECT * FROM keywords LIMIT 5;
++-++
| id | word| amount |
++-++
| 1 | Firence | 49 |
| 2 | Italien | 49 |
| 3 | Toscana | 49 |
| 4
: Andreas Ahlenstorf [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 11:40 AM
Subject: Problems with boolean keyword search
Hello,
I have to build a keyword search with support for the boolean
operators +, -, * and .
Basically it's quite easy: Connect the three tables
Hello,
Eamon Daly schrieb am Donnerstag, 17. Juni 2004 um 19:04:
FYI, MySQL allows boolean searching as of 4.0.1. See:
http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html
I normally use that. But: Very bad result quality because there
are only sigle keywords. I tried it with a text column
To start with I have tried to use mysqlbug but it doesn't work, when I
go to the scripts directory in the command prompt window
(c:\mysql\scripts) and type mysqlbug and hit enter it just says it is
not recognized as anything.
I have as a reference Welling and Thomsons book MYSQL Tutorial and
hello-
i am running into trouble compiling on redhat 7.2 (2.4.7-10)
configure and make run without dying - make test however produces the
following output:
02:17:35([EMAIL PROTECTED])/tmp/source/mysql-4.1.2-alphamake test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale
of the appropriate
fields I get the error Lost connection to MySQL server during query
The error shows up immediately.
The only change I made was to change the port to 22.
I use port 22 when I try to make a putty connection or WinSCP.
I have no problems connecting to the server when using
to:
06/08/2004 02:16 Subject: myODBC connect problems
PM
be OPTIMIZING every
day?), suggestions appreciated.
PS I do not have any problems with the query performance.
I would recommend setting up a crontab that runs every N minutes executing
a query similar to this:
sql DELETE FROM table WHERE where clause LIMIT limit;
You say you have 3 million
encountering some
problems scaling.
1. The timeout is set to 5 min, because of the number of queries, there are a lot of
unused http processes that linger with connections, and the only way to seeminly keep
MySQL connections available is to keep timeouts short.
However, I have updates that take over
solve most of your problems (in theory...)
However, I have updates that take over an hour at a time, and the 5 min
timeout will kill the update process. If I change the timeout to 2
hours, Apache will eat up all the connections. Im a little confused at
the behaviour.
Probably annoying
Thank you very much for your bug report!
And sorry if I doubted your report at the beginning; I hadn't thought
of the rpm script.
No problem. I sometimes get bug reports that I know are impossible! Yet they
weren't. This one I would have barely noticed if it had not knocked the
slaves all
.
It should solve most of your problems (in theory...)
Why not just use a master-slave system and then you wouldn't have to worry
about it. All inserts go off the master, and all selects on the slave.
However, I have updates that take over an hour at a time, and the 5 min
timeout will kill
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to ID. When I clicked
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to ID. When I clicked
David Blomstrom wrote:
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to
Hi!
On May 25, Steven Roussey wrote:
We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had
several problems thereafter:
1. Tables with FTS indices became corrupted, with queries on them causing
segfaults on the servers.
Hmm, I don't see any changes in ft-related files
From: Sergei Golubchik [EMAIL PROTECTED]
4. Thread stack warnings:
Warning: Asked for 196608 thread stack, but got 126976
Same here.
OK, we can disable the warnings in the log file, but what's really behind
this warning?
A brand new, plain vanilla Fedora Core2 (aka RedHat FC2)
We start mysql with 'service mysql start' (we install from the RPM for
linux).
I've never seen mysql create binlog files under the name root before, and
after reverting to an old version, it doesn't again. It created a big mess
with all the slaves stuck at the end of an older binlog and not
the most problems with had FTS
indicies. I can't say that it is more than coincidental just yet. I am not
conclusive that it is a cause and effect relationship at this time.
Even returning to the older versions of mysql is not getting rid of all our
problems (we are seeing extremely high loads
We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had
several problems thereafter:
1. Tables with FTS indices became corrupted, with queries on them causing
segfaults on the servers.
2. BinLog files were getting created with ownership of root, not mysql. Then
Mysql complains
hi,
I'm running a mysql-server (4.0.18) on windows XP. Connected to this server were max.
100 clients ( Also XP).
After a while ( maybe 8 hours ) I get error messages on the client and also in the
server log:
Error5: out of memory (needed bytes )
Does anyone has an idea what could
Daniel Cummings wrote:
We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
On some platforms, the thread library has a limitation/bug that does not permit
thread pre-emption, which means that if a thread
We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
Are there some settings that aid with this kind of problem?
TIA
Dan
Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table not getting
Sonj McCoy wrote:
Hello Everyone,
I am having problems with foreign keys in MySQL InnoDB type databases.
For some reason, when adding a new record within an MS Access subform
(based on a query of two tables (parent table and child table), the
corresponding foreign key column in the child table
DESCRIPTION:
Mysqld appears to crash every few days or so. The .err file shows
that it may be an innodb problem. (See below for detail)
How-To-Repeat
I am not able to repeat the problem. The query that runs when the
mysqld server dies, is automatically re-run when the server comes back
]
Cc: [EMAIL PROTECTED]
Betreff: Re: Problems compiling NDB-Cluster mysql-4.1.2
You have to have zlib installed. This seems to be a bug, which I have
just reported. The fix is
simple: install zlib.
You can check with a simple C-program like this:
#include zlib.h
#include stdio.h
int main(int argc
: Two problems with prepared statements in ver 5.0.0
Hello,
I have been working with the C API in version 4.1.1. I encountered a
problem which I thought might be resolved in version 5.0.0, so I have loaded
the RPMs for version 5.0.0 onto my development RedHat Linux system
The startup script provided with Fedora linux uses the mysqladmin ping command to
verify that the server is up after the safe_mysqld command has been issued; however,
once I changed the password for the root account, this no longer works: it sits there
and tries this command 10 times on one
TK Banks wrote:
The startup script provided with Fedora linux uses the mysqladmin ping command to verify that the server is up after the safe_mysqld command has been issued; however, once I changed the password for the root account, this no longer works: it sits there and tries this command 10
Why use root?
How about creating a dummy database (CREATE DATABASE dummy) and a dummy
user that only has rights to access that database and have your init.d
script connect as the user dummy to db dummy?
Much better than leaving MySQL root passwords around in easy to find
places. (I know, I
I'm not sure what's going on with our replication. Everything was
working fine, then all of a sudden it stopped. I did STOP SLAVE; RESET
SLAVE; LOAD DATA FROM MASTER and it completed after a few minutes, but
when I checked SHOW SLAVE STATUS it no longer had any information about
the master. I
for those errors.
Gabriel:
Check the master error log to see what binary log it is trying to read, and why
the read is not successful, eg. ownership/permission problems.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http
(direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: Ken Paradox [mailto:[EMAIL PROTECTED]
Sent: 07 May 2004 18:13
To: [EMAIL PROTECTED]
Subject: Two problems with prepared statements in ver 5.0.0
Hello,
I have been working with the C API
You have to have zlib installed. This seems to be a bug, which I have
just reported. The fix is
simple: install zlib.
You can check with a simple C-program like this:
#include zlib.h
#include stdio.h
int main(int argc, char *argv[])
{
printf(Hello, World\n);
return 0;
}
If this refuses
PROTECTED]
Sent: 5/7/04 2:17 AM
Subject: problems with foreign keys revisited
Hi there, I am having some issues between two tables and foreign keys.
Here is the two tables I have setup.
| complaints |CREATE TABLE `complaints` (
`complaintID` int(11) NOT NULL auto_increment,
`ticket_number
Hi there, I am having some issues between two tables and foreign keys.
Here is the two tables I have setup.
| complaints |CREATE TABLE `complaints` (
`complaintID` int(11) NOT NULL auto_increment,
`ticket_number` varchar(20) NOT NULL default '',
`complainant_name` varchar(100) NOT NULL
Hello,
I have been working with the C API in version 4.1.1. I encountered a
problem which I thought might be resolved in version 5.0.0, so I have loaded
the RPMs for version 5.0.0 onto my development RedHat Linux system.
-
Problem 1 - can't
4.3.4 (cli) (built: Jan 24 2004 22:34:14) on s007), but the more
exotic ones (~ and ^ signs on and under Z, S .. and stuff like that) still
cause problems on the s006. Same script, requesting data from the same rows
of the same database on the s007 works as it is supposed to.
MySQL version of both
4.3.4 (cli) (built: Jan 24 2004 22:34:14) on s007), but the more
exotic ones (~ and ^ signs on and under Z, S .. and stuff like that) still
cause problems on the s006. Same script, requesting data from the same rows
of the same database on the s007 works as it is supposed to.
MySQL version of both
Hello all,
i want to compile the development tree source from
bk://mysql.bkbits.net/mysql-4.1 on SuSE 8.2 Linux. The compiling of the
mysql-4.1 without the ndb-cluster works fine.
When set the configuration-option --with-ndbcluster, the compilation
fails with the error:
Hallo !
Strange problem with maxdb odbc connections.
I installed maxdb, databasemanager and sqlstudio on my local windows xp
pc and did some testing.
My application connects via system-dsn MAXDBLOKAL
STORE
SQLSTRINGCONNECT('dsn=maxdblokal;port=7210;uid=DBA;pwd=DBA;DATABASE=BWNE
U') TO
Hi there,
I'm trying to compile the MySQL 3.23.52 source distribution on
Slackware 9.1. I'm using g++ (GCC) 3.2.3 and, I think, I've got all
the required shared libraries installed. `./configure' exits OK, but
`make' exits with an error while building the mysql client:
|mysql.o(.text+0x1b29): In
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;
Excuted in a MySQL console returns the following SQL error
ERROR 1064:you have an error in your SQL syntax.
check the manual that corresponds to you MYSQL server version for the right syntax to
use
problems creating a new super user on version 4 under
WinXP
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
IDENTIFIED BY 'password' WITH GRANT OPTION;
Excuted in a MySQL console returns the following SQL error
ERROR 1064:you have an error in your SQL syntax.
check the manual that corresponds
Hello!
I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same
query NOT using SQL_CALC_FOUND_ROWS
select SQL_CALC_FOUND_ROWS * from table by date desc
- this query takes about 1.2 s
select * from
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 8:09 PM
To: [EMAIL PROTECTED]
Subject: mySQL: Table locking problems when non-index keys used
Friends,
Sorry to post this question again. I got a message saying that the
server couldn't transfer this message to some groups
Hello!
I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same
query NOT using SQL_CALC_FOUND_ROWS
select SQL_CALC_FOUND_ROWS * from table by date desc
- this query takes about 1.2 s
select * from
Friends,
Sorry to post this question again. I got a message saying that the server couldn't
transfer this message to some groups. Also I didn't get any response to this
question.
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed
Hi Friends,
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed columns, it locks the entire table instead of row lock. Is
there any solution apart from building index on each query key ? Is there a solution
in any of the later versions ?
|
| tblregfromaccess |
| tblsponsors |
+---+
17 rows in set (0.00 sec)
Similar problems are showing up with things as simple as a select query:
mysql select * from tblcourses;
ERROR 1096 (HY000): No tables used
BUT I JUST
...
- Original Message -
From: Valère Palhoriès [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 6:50 PM
Subject: Re: Problems adding table to Crystal Reports using ODBC Connection
Patrick,
Yes I am. If I create a Linked Table from Access 2003 I can see the table
|
| tbllocations |
| tblregfromaccess |
| tblsponsors |
+---+
17 rows in set (0.00 sec)
Similar problems are showing up with things as simple as a select query:
mysql select * from tblcourses;
ERROR 1096 (HY000
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary NOT NULL default '',
Name
At 19:09 -0400 4/19/04, Andy B wrote:
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary
Help!
We're running MySQl on Win2000 server.
The other day our INNODB database filled up, so we
stopped the server, backed up the data, and adjusted
the innodb_data_file_path from
ibdata1:500M;ibdata2:500M;ibdata3:500M;
to
ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M;
Late
Hi,
So what threading library should I use with mysql?
Can somebody recommend me which to use? Because I'm bit confused.
I used to use linuxthreads and it was pretty good. Now there appears some
other threading libraries:)
Which one is reliable and has good performance?
Ganbold
At 07:41 PM
Hi,
Can you give me some hints and tricks to compile mysql with libpthread?
What compiler options should I use?
thanks,
Ganbold
At 08:31 PM 14.04.2004, you wrote:
On Wed, 14 Apr 2004 19:59:33 +0900
Ganbold [EMAIL PROTECTED] wrote:
So what threading library should I use with mysql?
Can
Does this happen with a mysqladmin shutdown command as well?
-Original Message-
From: TO
To: [EMAIL PROTECTED]
Sent: 4/14/04 5:23 AM
Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding
INNODB space
Help!
We're running MySQl on Win2000 server.
The other day our
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option.
However ps ax shows only 2 processes:
61652 p0 S 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/ta
61671 p0 S 0:00.82
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option with libpthread.
After installation everything seemed OK. However after few minutes it hang
again.
It seems mysql with libpthread is even more unstable than using linuxthreads.
Ganbold
At 09:30 PM
I've been trying to compile a mysql server optimized for a zeon
processor and a specific application- I'm compiling with icc.
the problem is with the sql benchmarks- the perl regexp for making the
detailed report of the benchmark doesn't match the output from the
benchmarks so it doesn't
Yonah Russ writes:
here is a sample output line:
Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr 0.00 sys +
0.00 cusr 0.00 csys = 0.02 CPU)
here is the regexp:
/^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+)
.*secs \(\s*([^\s]*)
Hi-
I have not been able to build readline on Solaris 7. No matter
what I change in the configuration, it still gives me the same error.
Any ideas would be greatly appreciated.
Thank you all in advance for the help.
Regards,
Erek
System Configuration:
gcc:
: Problems building readline on Solaris 7
Hi-
I have not been able to build readline on Solaris 7. No matter
what I change in the configuration, it still gives me the same
error.
Any ideas would be greatly appreciated.
Thank you all in advance for the help.
Regards,
Erek
System Configuration
this helps,
Ken
- Original Message -
From: Ganbold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 11, 2004 11:35 PM
Subject: FBSD 5.2.CURRENT-p4 and mysqld problems
Hi,
I found some problematic queries which locks mysql server any
further
processing. I'm using mysql-4.0.18
without any problem. I have 17 FreeBSD
machines
and 13 of them is FreeBSD 5.2-CURRENT.
Also today I received one email saying some problems with linux kernel. I
know this
problem is related to Linux kernel, but there is also mentioned mysql and
linuxthreads.
Please read following
webserver
that wasn't loading the sql server all that much. now
it is, and we started developing problems. :).
as you can tell with this link:
http://sql.tribalwar.com/before-ps.txt the mysqld proc
wen't above 512M.
check your sql.err log, if you're getting a malloc
error, then this is more
801 - 900 of 2763 matches
Mail list logo