During a recent system software upgrade (CentOS) on the front-end of our
computing cluster, the mysql area was upgraded without our realizing that it
was going to be. Now, php and mysql do not communicate well with one another.
The version of mysql on the system after the upgrade is 5.1.61.
Hi,
We're chaning it to INT(9). Apparently someone remembered to change the type
of data in this field from an alphanumeric value to an INT(9).
I'm going to change this asap.
Thanks
BR
AJ
On Mon, Sep 6, 2010 at 5:17 AM, mos mo...@fastmail.fm wrote:
At 04:44 AM 9/3/2010, Alexandre Vieira
Hi List,
In a 20m interval in our max load I have:
OS WAIT ARRAY INFO: reservation count 637, signal count 625
Mutex spin waits 0, rounds 19457, OS waits 428
RW-shared spins 238, OS waits 119; RW-excl spins 13, OS waits 8
(The values are the difference between the start and end of this 20m
On 9/3/2010 3:15 PM, Johnny Withers wrote:
It seems that when your index is PRIMARY on InnoDB tables, it's magic and is
part of the data thereby it is not included in the index_length field.
I have never noticed this. I don't think adding a new index will make a
difference.
You could try
At 04:44 AM 9/3/2010, Alexandre Vieira wrote:
Hi Johnny,
mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
++-++---+---+-+-+---+--+---+
| id | select_type | table | type | possible_keys | key |
Hi Johnny,
mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
++-++---+---+-+-+---+--+---+
| id | select_type | table | type | possible_keys | key | key_len
| ref | rows | Extra |
On 02/09/2010 6:05 p, Alexandre Vieira wrote:
Hi Jangita,
I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's
246MB of 350MB free.
| Innodb_buffer_pool_pages_data | 6020 |
| Innodb_buffer_pool_pages_dirty| 1837 |
| Innodb_buffer_pool_pages_flushed |
Ok, so I'm stumped?
What kind of hardware is behind this thing?
-JW
On Fri, Sep 3, 2010 at 4:44 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi Johnny,
mysql EXPLAIN SELECT * FROM clientinfo WHERE userid='911930694';
Hi,
I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK and it
makes a little difference but not enough for the application to run in real
time processing.
It's a Sun Fire V240 2x 1.5ghz UltraSparc IIIi with 2GB of RAM.
MySQL is eating 179MB of RAM and 5,4% of CPU.
PID
What does
SHOW TABLE STATUS LIKE 'table_name'
Say about this table?
-JW
On Fri, Sep 3, 2010 at 8:59 AM, Alexandre Vieira nul...@gmail.com wrote:
Hi,
I've done some tests with INT(8) vs the VARCHAR(23) on the userid PK and it
makes a little difference but not enough for the application to
Hi,
mysql SHOW TABLE STATUS LIKE 'clientinfo';
Very confusing...
Why is index_length zero ?
On top of that, there's only 500K rows in the table with a data size of
41MB. Maybe InnoDB is flushing to disk too often?
What's the output of iostat -dxk 60 ? (run for a minute+ to get 2 output
girds)
--
*Johnny
Hi,
The DB is working on /var, which is md2 / md12 / md22.
extended device statistics
device r/sw/s kr/s kw/s wait actv svc_t %w %b
md2 0.1 80.00.4 471.4 0.0 1.0 12.2 0 94
md10 0.05.70.0 78.8 0.0 0.1 19.7 0 9
I think your MySQL instance is disk bound.
If you look at your iostats, md2, 12 and 22 have a ~10ms wait time before a
request can be processed. iostat is also reporting those disks are 75%+
utilized which means they are doing about all they can do.
Anyway you can add more disks? Add faster
Hi,
When creating a table in MySQL with a PK it automatically creates an INDEX,
correct?
The Index_Length: 0 is rather strange..I've created a new INDEX on top of my
PK column on my test system and Index_Length shows a big value different
from 0. Do you think this might have any impact?
mysql
It seems that when your index is PRIMARY on InnoDB tables, it's magic and is
part of the data thereby it is not included in the index_length field.
I have never noticed this. I don't think adding a new index will make a
difference.
You could try moving your log files to a different disk array
Hi list,
I'm having some performance problems on my 5.0.45-log DB running on Solaris
8 (V240).
We only have one table and two apps selecting, updating, inserting and
deleting massively and randomly from this table.
The table is very simple. All SELECTs,INSERTs,UPDATEs and DELETEs have only
one
Can you show us the table structure and sample queries?
On Thursday, September 2, 2010, Alexandre Vieira nul...@gmail.com wrote:
Hi list,
I'm having some performance problems on my 5.0.45-log DB running on Solaris
8 (V240).
We only have one table and two apps selecting, updating, inserting
What is the hardware spec? Anything else running on the box?
Why are you replicating but not making use of the slave?
Can you post the output of SHOW CREATE TABLE?
Regards
John
On 2 September 2010 12:50, Alexandre Vieira nul...@gmail.com wrote:
Hi list,
I'm having some performance problems
John, Johnny,
Thanks for the prompt answer.
mysql SHOW CREATE TABLE clientinfo;
On 02/09/2010 4:46 p, Alexandre Vieira wrote:
John, Johnny,
Thanks for the prompt answer.
...
We also run some other applications in the server, but nothing that consumes
all the CPU/Memory. The machine has almost 1GB of free memory and 50% of
idle CPU time at any time.
TIA
BR
Alex
Hi Jangita,
I'm 15779 innodb_buffer_pool_pages_free from a total of 22400. That's 246MB
of 350MB free.
| Innodb_buffer_pool_pages_data | 6020 |
| Innodb_buffer_pool_pages_dirty| 1837 |
| Innodb_buffer_pool_pages_flushed | 673837 |
| Innodb_buffer_pool_pages_free |
Cc: mysql@lists.mysql.com
Subject: Performance problems on MySQL
John, Johnny,
Thanks for the prompt answer.
mysql SHOW CREATE TABLE clientinfo
for your
delete queries?
DELETE FROM clientinfo WHERE units='155618918';
-Original Message-
From: Alexandre Vieira [mailto:nul...@gmail.com]
Sent: Thursday, September 02, 2010 8:46 AM
To: John Daisley; joh...@pixelated.net
Cc: mysql@lists.mysql.com
Subject: Performance problems on MySQL
Subject: RE: Problems After MySql 5.1.34
Gary wrote:
Welcome to the hell that is php + apache + mysql. If you upgrade your
MySql (especially major versions 5.0 = 5.1) you will also need to
recompile php against the new MySql client libs. We've had very
limited success trying to get it to work
as it would make my compiling life easier every time I update MySql on all of
my boxes.
Gary
From: Johnny Stork [li...@openenterprise.ca]
Sent: Wednesday, May 06, 2009 1:03 PM
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Typo
Hi Johnny, all!
Johnny Stork wrote:
Typo, moved from 5.0.67 to 5.1.34
Ok, that helps - I checked the contents.
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even
the Trixbox/FreePBX
Hi Gary, all,
Gary Smith wrote:
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major versions 5.0 = 5.1) you will also need to recompile php
against the new MySql client libs. We've had very limited success trying to
get it to work
Gary wrote:
Welcome to the hell that is php + apache + mysql. If you upgrade your
MySql (especially major versions 5.0 = 5.1) you will also need to
recompile php against the new MySql client libs. We've had very
limited success trying to get it to work otherwise.
Well, you don't actually
: donderdag 7 mei 2009 15:15
To: ad...@asarian-host.net; mysql@lists.mysql.com
Subject: RE: Problems After MySql 5.1.34
Gary
this isnt mysql's fault that php has such abysmal build tools..try
requesting a web developer to simply download php and run the proprietary
binary tools
after a week of sleepless
: joerg.bru...@sun.com [joerg.bru...@sun.com]
Sent: Thursday, May 07, 2009 2:40 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Hi Gary, all,
Gary Smith wrote:
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major
You are right. I misspoke regarding mysql - php - apache hell. It happens
anytime an interface changes.
From: Mark [ad...@asarian-host.net]
Sent: Thursday, May 07, 2009 5:57 AM
To: mysql@lists.mysql.com
Subject: RE: Problems After MySql 5.1.34
Gary
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even the
Trixbox/FreePBX tool, but trying to apply Trixbox changes, or running a
pear update produces the errors below. I created a couple of sl but
this did not
Typo, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64. Access to the db seesm fine from the shell, phpmyadmin or even
the Trixbox/FreePBX tool, but trying to apply Trixbox changes, or
running a pear update produces the
From: Johnny Stork [li...@openenterprise.ca]
Sent: Wednesday, May 06, 2009 1:03 PM
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Typo, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64
glenn
Union is 4.0 feature.
david
Notwithstanding end-of-life status, is there an issue in MySQL
v3.23 r.e. the union operator?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the documentation:
mysql SELECT REPEAT('a',1) UNION SELECT
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the
Jim Winstead wrote, On 1/11/2008 12:54 PM:
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - 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 ''
at line 1.
when i treat to create a new data base, appears this message.
mario henriquez wrote:
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - 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 ''
at line 1.
when i treat to create a new data
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives:
Hi,
You're running MySQL with a mysql linux user, verify that he have
write access on mysql datadir. You should specify it with --datadir=
at command line invoking mysql_install_db too.
2007/6/16, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi everybody,
I am trying to compile/configure MySQl
Hi everybody,
I am trying to compile/configure MySQl 5.0.41 on a Mandrake 10 linux box.
In doing so, I am getting some errors with mysql_install_db (ERROR: 1049
Unknown database 'mysql', Installation of system tables failed!)
Please let me know how to solve the problem.
Thanks in advance for
error: Found option without preceding group in config file:
/u07/mysql/data/upgrade_defaults at line: 2
Fatal error in defaults handling. Program aborted
This is your problem.
What's in that file (/u07/mysql/data/upgrade_defaults) ?
--
MySQL General Mailing List
For list archives:
Hi,
could it be this bug :
http://bugs.mysql.com/bug.php?id=21011
2006/8/31, Whisler, David [EMAIL PROTECTED]:
I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the
Solaris package utility (which means I de-installed 5.0.22 then
installed 5.0.24 in the same location,
?
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 2:02 AM
To: Whisler, David
Cc: mysql@lists.mysql.com
Subject: Re: mysql_upgrade script problems on MySQL 5.0.24
error: Found option without preceding group in config file:
/u07/mysql/data
I've upgraded from 5.0.22 to 5.0.24 MySQL Server on Solaris 9 using the
Solaris package utility (which means I de-installed 5.0.22 then
installed 5.0.24 in the same location, environment, configuration).
I'm having the following error when trying to execute the mysql_upgrade
executable according
Spoken too soon...
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause...
Hi Gabriel,
Yesterday MySQL died again... there is nothing in the log files... (be
it mysqld.log, .err, or /var/log/messages).
The hosting provider is running an application called 'big-brother'
and a lot of sef-faults appear in the logs from this. I don't know if
thins is the cause... if this
Yup... For now the problem stopped...
These humongos values were because they were initialized at MAX_INT on
that 64bit machine...
In the my.cnf file they were not mentioned at all !
2^64 - 1 == 18446744073709551615
Now look at the values below !
--
Gabriel PREDA
Senior Web Developer
On
Hi list,
Since we bought a better hardware for our dedicated MySQL Server we
have been running into some problems.
We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21-standard - for 64bit
- RAM: 4 GB
- RAID 5 matrix with 3 SCSI disks at 15k rotations
Hi,
Please let us know what all variables you have configured in your my.cnf
files.
what is your total size of memory in box.
eg : max_connections
key_buffer_size
sort_buffer_size.
Gabriel PREDA wrote:
Hi list,
Since we bought a better hardware for our dedicated MySQL Server
Gabriel, in your SHOW VARIABLES, I see a handful of settings that are
much, much larger than normal:
| max_binlog_cache_size | 18446744073709551615
| max_join_size | 18446744073709551615
| max_seeks_for_key | 18446744073709551615
|
I migrated to mysql 5 but the applications with Visual Basic 5 return
error in data.
We have installed ODBC 3.51
--
Saludos cordiales.
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
I think you will need to give the list some more information!
What error message do you get? Is it an error when running SQL queries, or a
problem connecting to the database?
James Harvard
At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote:
I migrated to mysql 5 but the applications with Visual
I have downloaded sucesfully the MySQL Migration Toolkit tool. After start the
error with Java appears. I have Java installed on my PC because I work with
Eclipse 3.1.1 + PHPEclipse Plugin. The JDK installed is 1.5. So if any can help
me ...
Regards,
--
ReynierPM
4to. Ing. Informática
Linux
running into the same problems. The MySQL
server itself is running at the moment and has a number of live
databases on it.
060209 18:40:43 mysqld started
060209 18:40:43 [Warning] Can't create test
file /var/lib/mysql/thirdeye.lower-test
/usr/libexec/mysqld: Can't change dir
Wondering if anyone can shed some light on a problem I am experiencing.
I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have been trying to get the default /etc/init.d/mysqld script to restart the
server but I keep running into the same problems
been trying to get the default /etc/init.d/mysqld script to restart the
server but I keep running into the same problems. The MySQL server itself is
running at the moment and has a number of live databases on it.
060209 18:40:43 mysqld started
060209 18:40:43 [Warning] Can't create test
file
4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant
Update 2) machine.
I have been trying to get the default /etc/init.d/mysqld script to
restart the server but I keep running into the same problems. The MySQL
server itself is running at the moment and has a number of live databases
Hello.
1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld
1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld
Hi.
Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9),
I'm suffering several memory problems ('Out Of Memory'
problem) on my server.
Playing around with my server:
SHOW PROCESSLIST
Id | User | Host | db | Command | Time | State | Info
20138 | user1 | localhost | user1_db |
John Trammell wrote:
#!perl
use strict;
use warnings;
sub foo {
warn wantarray() in foo() is: , wantarray(), \n;
my @r = 3 .. 8;
return @r;
}
my @x = foo() or warn in ... or warn() #1\n;
warn [EMAIL PROTECTED]: @x\n;
my $x = foo() or warn in ... or warn() #2\n;
warn \$x: $x\n;
We have an application that has just upgraded to Debian sarge with mysql
upgrading from 3.23.49 to 4.0.24. As far as I know I have followed all
the procedures for upgrading the database.
Some queries always fail in DBD::mysql (in DBI) although they work OK
with the mysql client.
For example,
Oliver Elphick wrote:
which returns 0 rows, works correctly in mysql. But when it is passed
through this statement in Perl:
my @row = $dbh-selectrow_array($sql) or
failed(__FILE__, __LINE__,
Failed to run the sql statement with error
Hi All,
I'm trying to take scheduled backup from mysql administrator and it always
gives me a popup with this message.
Enter user name and password for the account under which the task will be
executed.
it shows me username and password for my windows account and when I click
ok on the pop
Oliver Elphick wrote:
We have an application that has just upgraded to Debian sarge with mysql
upgrading from 3.23.49 to 4.0.24. As far as I know I have followed all
the procedures for upgrading the database.
Some queries always fail in DBD::mysql (in DBI) although they work OK
with the mysql
-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 21, 2005 12:48 PM
To: olly@lfix.co.uk
Cc: debian-user@lists.debian.org; mysql@lists.mysql.com
Subject: Re: Sarge problems with MySQL and DBI / DBD::mysql
Oliver Elphick wrote:
We have an application that has just
Hello.
These are some active bugs with different versions of MySQL
Administrator. Check if your problem remains with the latest one.
Hi All,
I'm trying to take scheduled backup from mysql administrator and it
always
gives me a popup with this message.
Enter user name and
In the process I noticed somehow someone had managed to install a
slightly different version of mysql vs. mysql-max, so I uninstalled
everything msyql related and started over, came right up with InnoDB
support!
-
Kevin Korngut
Mr. Magoo
JANIMATION INC.
www.janimation.com
I'm attempting to configure mysql with InnoDB tables and I'm running
into problems. And am using the following version of mysqld-max, Ver
4.0.18-Max for suse-linux on i686 (Source distribution)
First I uncommented the following lines in /etc/my.cnf:
# Uncomment the following if you are using
I have a Pentium III with Fedora Core 3 notebook and I need to install
MySQL 4.1 on it.
There was no mysql installed before so I've downloaded the packages and
did what I usually do to install
the packages. They install great. But when I try to run MySQL I have
problems as it does not run
It only shows this:
050413 23:53:35 mysqld started
050413 23:53:35 mysqld ended
Nothing conclusive.
prasanna a wrote:
Hi
please cat the below error file and see
/var/lib/mysql/presario2700.err
__
Do you Yahoo!?
Yahoo! Mail - Find what you need with new
I have a Pentium III with Fedora Core 3 notebook and I need to install
MySQL 4.1 on it.
There was no mysql installed before so I've downloaded the packages and
did what I usually do to install
the packages. They install great. But when I try to run MySQL I have
problems as it does not run
I don't
have the link handy. Basically you can realx the policy via the targetted
settings.
Good luck
//jjs
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Wed 4/13/2005 10:56 PM
To: mysql@lists.mysql.com
Subject: Problems installing MySQL 4.1 under
Hello all,
I now have disabled my SELinux and so it should work.
However it still does not work.
I have a bunch of errors now on my .err file that I am copying bellow.
I've tried to create the tables again by issuing mysql_install_db and then
tried to run the daemon.
Is there any ideias on how to
I am running MySQL-server-4.1.8-0 without problem on FC3.
This could also be hardware related.
Joey
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:24 PM
To: Mysql List
Subject: Still having problems with MySQL 4.1
C.F. Scheidecker Antunes wrote:
Hello all,
I now have disabled my SELinux and so it should work.
However it still does not work.
I have a bunch of errors now on my .err file that I am copying bellow.
I've tried to create the tables again by issuing mysql_install_db and
then
tried to run the
Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Jeff,
I am in SLC Utah.
Do you have your /var/log/mysqld.log file? I've put mine on the list
so that anyone can see it.
thanks,
C.F.
Jeff Steinkamp wrote:
I've had the same problem and for the last
Hello.
under /var/lib/mysql saying mysqld started and mysqld ended.
It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
The tables are not created not even if I run mysql_install_db.
According to the manual they should
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
It is weird. I've done so many
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
Hi Bob,
Yes the ownership is correct. In fact I did a chmod -R mysql:mysql
/var/lib/mysql and I still have the same problem.
I wonder if it is because I am running a dual processor machine.
Robert A. Rawlinson wrote:
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with
Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Jeff,
I am in SLC Utah.
Do you have your /var/log/mysqld.log file? I've put mine on the list
so that anyone can see it.
thanks,
C.F.
Jeff Steinkamp wrote:
I've had the same problem and for the last month I've not been able
Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not install it.
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
reconstituted from a munged response
(original post)
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that
Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 03:43:22 PM:
I downloaded the MySql Administrator and simply run that. and
dragged the icon to the startup menu so it loads MySql on startup.
Not entirely sure how to load MySql as a 'service' on Win2003 Server.
The only message I get, and
I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for
Hello
I have two problems with latest MySQL (4.1.7) under Solaris 9. I am using
SUN provided C compiler (cc: Sun C 5.6 2004/07/15) to compile packages. I
need urgently to use MySQL, so any fast response will be highly appreciated.
First problem is, that when I try to compile MySQL 4.1.7 from
Greetings All,
A seemingly strange problem.
If I go to the mysql prompt on a linux server - mysql version 3.23.14-alpha.
I can issue the command create database .
I can then issue the command use .
No problem.
However, if I type use mysql for the mysql database.
If I do a
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a free
floating database that nobody (except root) has permission to access
until you issue the grant statements to make someone own it. But
nobody actually owns
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
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
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
Hmm, I don't see any changes in ft-related files since 4.0.18 that could
cause it (there were bugfixes, but they affect only *searching* - that
is MATCH - and not *updating*).
Can you create a test case ?
Well, I put up a file in the secret folder a few days ago as referenced in a
bug
1 - 100 of 247 matches
Mail list logo