Yup, I'm doing clean tests,lshutdown, and reload mysql each test.
The raid setup is similar, Faster is raid1 with 10k harddisk, slower is raid
10 with 15k.
Metrics show
Old raid
Secuecial writting 1G: 533 mb/s (using dd if=/dev/zero of=1G bs=1024
count=102400)
Secuencial reading 1G: 500 mb/s
New
On Sun, Feb 13, 2011 at 11:40 PM, Andrés Tello wrote:
> I have a test process, which runs in the "old server" in 35 seconds, the new
> server runs the same process in 110.
>
> There is a change of version from mysql 4.1.22 to 5.1.22.
> We were stuck at 5.1.22 because higher version give us anothe
I have a test process, which runs in the "old server" in 35 seconds, the new
server runs the same process in 110.
There is a change of version from mysql 4.1.22 to 5.1.22.
We were stuck at 5.1.22 because higher version give us another issules like
encoding, case sensitivity...
I really belive th
Use indexes before thinking about partitions.
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Thursday, July 15, 2010 8:44 AM
To: mysql
Subject: Mysql 4 and or Partitions.
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory
Ok... I solved my mistery of the slow 22G table rebuild the kernel to
support memory and now things are working.
But still quite slow.
I do sum() operations over the 22G table. I'm using the latest version of
mysql 4... (I WILL migrate soon, I promise), one thing I have notice, is
Michael Dykman wrote:
> One problem you might be having is the column named 'call'.. It's a
> keyword, so perhaps you might get away with backticking it?ie.
> `call`
>
> Also, you shouldn't need that final semi-colon inside your statement
> string.. I have had preparedstatement interfaces gi
Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspect
> its a version syntax thing.
>
> Here is what I see:
>
> Couldn't exec
- Original Message -
From: "Grant Peel"
To: "Michael Dykman"
Cc:
Sent: Sunday, July 11, 2010 9:25 PM
Subject: Re: Mysql 4 to 5
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
- Original Message -
From: "Michael Dykman"
To: "Grant Peel"
Cc:
Sent: Sunday, July 11, 2010 9:20 PM
Subject: Re: Mysql 4 to 5
One problem you might be having is the column named 'call'.. It's a
keyword, so perhaps you might get away with backt
uot;;
$sth->execute($trackedcall) or die print "Couldn't execute
statement: $DBI::errstr; stopped";
- md
On Sun, Jul 11, 2010 at 7:50 PM, Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the s
Hi all,
I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect its
a version syntax thing.
Here is what I see:
Couldn't execute statement: You have an error in your SQL syntax; check the
manual
At 4:12 PM -0800 3/5/08, Garris, Nicole wrote:
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
% needs quotes around it.
I recommend always quoting the username and hos
OK, what is wrong with the following statement? MySQL 4.1 doesn't like
my syntax ...
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'myownpassword';
I might have misread the original message, but it sounded to me like the person was
looking for earlier software than available via the official download links. I
personally don't have any need for old versions, but I use Giuseppe Maxia's
mysql_sandbox tool to run many different versions so I c
I'm haing a hard time figuring out why you want
an old 4.0 server, when newer better versions
are available.
MySQL 4.0.27 can be downloaded from Softpedia:
http://linux.softpedia.com/progDownload/MySQL-Download-3074.html
On Mon, June 4, 2007 00:44, Baron Schwartz wrote:
> Only back to 4.1.x -- b
In the last episode (Jun 03), Subasta.pl - Darmowe Aukcje Internetowe said:
> Where I can find the best stable version 4.xx?
http://dev.mysql.com/downloads/mysql/4.1.html
You should really consider using MySQL 5.0, though.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mai
Hi,
Subasta.pl - Darmowe Aukcje Internetowe wrote:
Hello,
Where I can find the best stable version 4.xx?
Some of the mirrors still have older versions, such as
http://mysql.mirrors.pair.com/
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Hello,
Where I can find the best stable version 4.xx?
Greetings,
Łukasz Ciszak
http://www.subasta.pl
On Fri, 2007-04-27 at 09:19 -0500, [EMAIL PROTECTED] wrote:
> So if one is doing a full mysqldump every night, all bin-logs can be
> deleted after this?
On the slave - Yes. In fact I would highly recommend it before
starting the slave processes again. This will reset the bin log's
'position' b
So if one is doing a full mysqldump every night, all bin-logs can be
deleted after this?
If bin-logging is disabled, will master/slave syncing still occur?
David
> Issuing a 'reset master' will purge all of the logs as well. I wouldn't
> just rm them, as they are being tracked in the index fil
So, I take it since I do not have a slave at all, I could safely just
disable this feature altogether?
If I do not need point in time recovery, and the once every 12 hour dump I
do across all databases is ok with me, I suppose I can just disable said
feature? Heck, some of these boogers are a GB
Issuing a 'reset master' will purge all of the logs as well. I wouldn't
just rm them, as they are being tracked in the index file.
If you aren't running a slave, then these files are only good for data
recovery purposes. Say a DBA goes crazy and deletes all of the databases
mid-day (too much s
> Yes -- sorry for being so general. You can use the binlogs for a)
> replication b) replaying changes since your last backup so you get
> point-in-time recovery. If you have no replication slaves, just delete
> everything older than your latest backup. You can just use 'rm'. If
> you use PUR
Hi Scott,
Scott Haneda wrote:
In the short term, see the manual page for PURGE MASTER LOGS. In the
long term, write a cron job.
innotop (http://sourceforge.net/projects/innotop) also has a new
feature, unreleased because I just wrote it a few hours ago, which will
help you figure out which bin
> In the short term, see the manual page for PURGE MASTER LOGS. In the
> long term, write a cron job.
>
> innotop (http://sourceforge.net/projects/innotop) also has a new
> feature, unreleased because I just wrote it a few hours ago, which will
> help you figure out which binlogs can be purged sa
Hi,
Scott Haneda wrote:
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
See attached message I just sent to
Running mysql 4, just poked into data and see I have gigs and gigs of
hostname-bin.xxx log files.
How does one maintain these, can someone point me to relevant data on what
to do about drive space being lost to these?
thanks
--
-
Scott
AIL PROTECTED]> wrote:
hi,
we are in the process of moving from our old hosting company to new one.
and I was thinking that it's the best time to move from mysql 4 to version
5. currently, we use php 4.3.4 / mysql 4.0.18 / apache 2.0
where I can expect problems because of difference in versions?
al
hi,
we are in the process of moving from our old hosting company to new one.
and I was thinking that it's the best time to move from mysql 4 to version
5. currently, we use php 4.3.4 / mysql 4.0.18 / apache 2.0
where I can expect problems because of difference in versions?
all queries I us
When I ran version 4, mysql would start as many mysqld process as it
needed. This would vary depending upon how busy it was. As a lay
perosn I will refer to this as the threading model.
I have upgraded to version 5 and notice that no matter what it only
runs 1 mysqld. Everything seems to work
Willy wrote:
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varc
Hello,
I have solved this problem, thanks.
Regards
Willy
- Original Message -
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NU
At 23:00 +0100 14/6/06, Graham Reeds wrote:
1) You may have a bogus hidden character in your SQL file. If you
look at it with a text editor (BBEdit, TextWrangler, etc), with the
"show invivisbles" feature on, do you see unusual stuff? Sounds
strange but I've seen stranger.
Took a brief look
letter to all
> lower caps (I thought v5 was all lower caps anyway?)
On systems with case-insensitive file systems, MySQL will lowercase
table and database identifiers.
> * Also an error occurred regarding varchar size (it appears v5 can hold
> 4096 while v4 max is 255).
The maximum siz
Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them ent
Graham Reeds wrote:
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them entirely.
Could you po
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided to see what I can do
e to a
kernel panic, though I don't have direct access to the machine
(colocated) to verify when it occurs.
There are no crash.logs from MySQL, and watchdog and system.logs
show nothing. I have culled the following panic.log - can anyone
tell if MySQL is the cause of such?
Has anyone seen M
rash.logs from MySQL, and watchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
MySQL, and watchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
*
Mon
tchdog and system.logs show
nothing. I have culled the following panic.log - can anyone tell if
MySQL is the cause of such?
Has anyone seen MySQL 4 crash on an Xserve (G4 specifically)? I have
tried two totally different servers, and the problems continue.
- John
*
Mon Jun 12 06:
In the last episode (Apr 21), Vincente Aggrippino said:
> The following query runs fine on my test server at home, running
> MySQL 5.0.15, but on my hosting provider's server, running MySQL
> 4.0.24, it gets a syntax error. Can anyone help me figure out why?
> ...
>
> insert into product (name, u
Vincente Aggrippino wrote:
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
values('Whatcham
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
values('Whatchamacallit', 'http://www.whatcha
bd/temp_mysql_tabledir/tabledir/mnogosearch3235/url.MYD
what`s wrong?anybody can help me?
--
View this message in context:
http://www.nabble.com/symbolic-links-mysql-4-error-on-ubuntu-5.10-t1322625.html#a3528642
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list a
Comma separated JOINS strikes again!!!
[...]
Here is where you will find this change documented in the manual:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
I read that page over and over again... probably too late at night.
thanks for that info. Thanks to Peter, too.
Jan,
>While my query has a cardinality of 23,124*1=23,124 on mysql4,
it has
>6,412*34,341=220,194,492 on mysql5 - and takes forever and makes
>me
think everything hangs?!
Yep, MySQL improved the SQL compatibility of its join syntax beginning
with 5.0.12, see http://dev.mysql.com/doc/refma
Jan Kirchhoff <[EMAIL PROTECTED]> wrote on 02/01/2006 06:31:20 AM:
>
> As I already wrote I try do get a replication running from a
> mysql-4.1.13 (32bit) master to a 5.0.18 (64bit) slave. It only runs
> for a few minutes and then a query hangs.
> I think I now found out why:
> I modified a mul
As I already wrote I try do get a replication running from a mysql-4.1.13
(32bit) master to a 5.0.18 (64bit) slave. It only runs for a few minutes and
then a query hangs.
I think I now found out why:
I modified a multi-table-update that hung to a select. The same query on the absolutely
ident
HALIL DEMIREZEN wrote:
Michael,
Thank you and all for effort to help.. I solved the problem by giving high
limit numbers such as;
(select * from tablea where item=1 order by rand() limit 0, 1)
union all
(select * from tablea where item != 1 order by rand() limit 0,
1);
--
>
>
>
>
> Gleb Paharenko <[EMAIL PROTECTED]>
> 05.12.2005 12:19
>
> To
> mysql@lists.mysql.com
> cc
>
> Subject
> Re: About union sql Mysql 4.x
>
>
>
>
>
>
> Hello.
>
>
>
46
To
HALIL DEMIREZEN <[EMAIL PROTECTED]>
cc
Gleb Paharenko <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject
Re: About union sql Mysql 4.x
HALIL DEMIREZEN wrote:
> Hi,
>
> I am trying to run an sql query such as below to list items=x randomly
and
> then items
HALIL DEMIREZEN wrote:
> Hi,
>
> I am trying to run an sql query such as below to list items=x randomly and
> then items != x randomly..
>
>
> mysql> (select * from tablea where item=1 order by rand()) union all
> (select * from tablea where item != 1 order by rand());
>
> but the result is not a
]
---
Gleb Paharenko <[EMAIL PROTECTED]>
05.12.2005 12:19
To
mysql@lists.mysql.com
cc
Subject
Re: About union sql Mysql 4.x
Hello.
>From http://dev.mysql.com/doc/refman/5.0/en/union.html:
"ORDER BY for individual SELECT sta
Hello.
>From http://dev.mysql.com/doc/refman/5.0/en/union.html:
"ORDER BY for individual SELECT statements within parentheses has an
effect only when combined with LIMIT. Otherwise, the ORDER BY is
optimized away."
Therefore you're getting the same results, because ORDER BY doen't
wor
Hi,
I am trying to run an sql query such as below to list items=x randomly and
then items != x randomly..
mysql> (select * from tablea where item=1 order by rand()) union all
(select * from tablea where item != 1 order by rand());
but the result is not as expected. rand() seems not to be wo
Hello.
>I do have my data
Check if yum has cleared the data directory, if not, you should be
able to recover the data.
>Can I install mysql 5, and it will migrate/work with my existing data?
In my opinion it is a good idea, but be aware of compatibility issues
for your applications wh
MySql v3.23 is part of the Fedore Core 3 distribution. MySQL v4.1 only
became standard in Fedora Core 4.
I suspect it's one of the non-Fedora repositories you're using. Check your
logs and also check /etc/yum.repos.d
grep enabled /etc/yum/repos.d/*
Best regards,
Richard Dale.
Norgate Investor
oss [EMAIL PROTECTED]
Sent: 11/07/2005 03:19 PM
To: mysql@lists.mysql.com
Subject: Linux Yum DELETED mysql 4! Can I install mysql 5 and be on my way?
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5.
Can I install mysql 5, and it will migrate/work with my existing data?
Thanks,
-nat
HARSET=latin1
>
>
> The two tables are EMPTY ,where I try this insert in each version I get :
>
> mysql 5
>
> mysql> insert into manager_new
> (id_from_hits,from_ip,to_ip,lstupdate,comment) values
> (39,'192.118.68.5','192.118.68.5',now(),&#
39,'192.115.52.5','92.115.52.5',now(),'added automatically');
ERROR 1062 (23000): Duplicate entry '192.118.68.5-192.118.68.5' for key 2
mysql 4
mysql> insert into manager_new
(id_from_hits,from_ip,to_ip,lstupdate,comment) values
(39,'192.115.52.5'
9,'192.118.68.5','192.118.68.5',now(),'added automatically');
ERROR 1062 (23000): Duplicate entry '192.118.68.5-192.118.68.5' for key 2
mysql 4
mysql> insert into manager_new
(id_from_hits,from_ip,to_ip,lstupdate,comment) values
(39,'192.118.68.5&#
PD Inc. has open-sourced their "compatibility RPM" that enables system
administrators to install MySQL 4.x on Red Hat Enterprise Linux (RHEL3)
Operating System with minimal impact.
Baltimore -- August 1, 2005 -- PD Inc. today announced the release of
their MySQL-shared compat RPMs for R
Hello.
You have several problems and they're should be resolved step by step.
First fix the problems with permissions. Usually they're solved by
changing the owner of mysql database to mysql user. Check what's wrong
with /var/log/mysqld.log. It might be necessery to create it manually.
Why a
Hi,
Im using : mysqlclient10-3.23.58-6
,mysql-server-4.1.11-2,mysql-4.1.11-2 On fedora 3.
when i run the following command its gives Error:
[EMAIL PROTECTED] etc]$ /etc/init.d/mysqld start
touch: cannot touch `/var/log/mysqld.log': Permission denied
chmod: changing permissions of `/var/log/mysqld.
.xx version.
See notes about them at:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Jerry Swanson <[EMAIL PROTECTED]> wrote:
> I want to install MySQL 4 on Fedora Core 2.
> Questions:
> #1. Do I need to uninstall MySQL 3 from the server first?
>
>
> I want to install MySQL 4 on Fedora Core 2.
> Questions:
> #1. Do I need to uninstall MySQL 3 from the server first?
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
> #2. Where I can get source for MySQL 4?
http://dev.mysql.com/downloads/
Go to the page of the version
Jerry Swanson wrote:
> #1. Do I need to uninstall MySQL 3 from the server first?
Not really.
> #2. Where I can get source for MySQL 4?
At your local 7/11. They usually store it hidden behind the counter along
with the most popular nuclear launch codes.
If they are out of stock, you
I want to install MySQL 4 on Fedora Core 2.
Questions:
#1. Do I need to uninstall MySQL 3 from the server first?
#2. Where I can get source for MySQL 4?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Joey wrote:
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don
On Friday 03 June 2005 03:36 pm, Joey wrote:
> SET PASSWORD FOR 'user'@'localhost' =
> OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
Is there a way to tell mysql 4 to defaul to the old style passwords instead
of having to run this every time we add a user?
SET PASSWORD FOR 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Applications we develop in php, and phpMyadmin don't seem
Hello.
> I want to upgrade mysql 3 to mysql 4.
At first, you should read:
http://dev.mysql.com/doc/mysql/en/upgrade.html
Search the MySQL lists archives about possible problems which you can
expect. It is strongly recommended to make a backup.
> How to remove mysql3 and i
I want to upgrade mysql 3 to mysql 4.
Operating System is Fedore Core 2. Is there any package dependency?
How to remove mysql3 and install mysql 4?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
letly
different.
maybe this can be helpful:
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
From: Prabath Ranasinghe <[EMAIL PROTECTED]> (by way of Prabath
Ranasinghe <[EMAIL PROTECTED]>)
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Authorizing Problem in MySQ
Prabath Ranasinghe (by way of Prabath Ranasinghe <[EMAIL PROTECTED]>)
ha scritto:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hash: SHA1
Hi All,
I installed a fresh copy of Mandrake Linux 10.0 with MySQL.
I tried to login to MySQL server ,But it says that authorization is failed.
My hostname is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hash: SHA1
Hi All,
I installed a fresh copy of Mandrake Linux 10.0 with MySQL.
I tried to login to MySQL server ,But it says that authorization is failed.
My hostname is localhost and user is root.I entered the root password.
Here is the log :-
[EM
Hello.
See:
http://dev.mysql.com/downloads/mysql/4.1.html
sam wun <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I realised that install mysql 4 thru rpm is the best way for a smooth
> installation.
> Can anyone please point me to a site where I can download mysql
Hi,
I realised that install mysql 4 thru rpm is the best way for a smooth
installation.
Can anyone please point me to a site where I can download mysql 4 rpm
for Redhat9?
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ad my my.cnf on start from init.d on
mandrake 10.1 and mysql 4
At 11:02 -0600 12/15/04, Randy Paries wrote:
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There
At 11:02 -0600 12/15/04, Randy Paries wrote:
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc dir, so I created one from my-huge
Hello,
I am building a new DB box.
The box is mandrake 10.1 and mysql 4.0.20
All my other boxes are RH9 and mysql 3
The one problem I am having is they appear to do the my.cnf differently
There was no my.cnf in the /etc dir, so I created one from my-huge.cnf and
placed it in the /etc
But the
ng
<[EMAIL PROTECTED]> wrote:
>
> Does mysql 4 require file locking? I'm not talking about in the
> database -- I know how to lock and unlock tables for data consistency.
> I'm referring to the filesystem that the data lives on.
>
> For reasons too boring to go
Does mysql 4 require file locking? I'm not talking about in the
database -- I know how to lock and unlock tables for data consistency.
I'm referring to the filesystem that the data lives on.
For reasons too boring to go in to, I have a mysql server and I'm keeping
the database f
-Original Message-
From: Ravi T
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:49 AM
Subject: Is there any good soul out there who can help me with mysql 4.0.17
replication.
Hi,
I am new to mysql and having some trouble with replication. Simple
stuff like,
1. How to restart the stopped res
Hi,
I'm using a kernel 2.4.25 system (Slackware distro) installed
with gcc 3.2.3.
I've tried both 4.0 and 5.0 source tarballs and when
configured with :
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql \
--with-openssl
and compiled, I always end up with:
gcc -DDEFAUL
Hi!
Marius Stan wrote:
Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
8<
Are you sure you _do_ have ncurses devel pack
Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
lib_termcap.o(.text+0xcc): undefined reference to `__ctype_b'
/usr/lib/gcc-lib/i386-
You could try MySQL 5(it is in alpha state), which comes with stored
procedures, mixing stored procedures and prepered statements could be a
possibility.
About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very
nice. IMHO
Best Regards
On Thu, 2004-03-04 at 23:23, [EMAIL PROTECTE
Hi there, i happened to be peering into the Sybex book on Mysql4 , it was
pretty expensive about 100 AUD is it a good one ? Anyway i had reference to
be able to compile c code into Mysql to add functions into it. Is there
anyway posible to avodi doing this and add it using queries ? Let me know
tha
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top "reply all" so t
yes it does. we use a bigint(20) for example.
[EMAIL PROTECTED] wrote:
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
Jeff Mathis, Ph.D.
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
El Sáb 07 Feb 2004 02:28, escribió:
> Mr. Alfredo
> Pls, will you give the complete structure as 'create query' of your
> database? that will help us to solve your problem.
> Pradap
This is the structure of the table that holds the sequential numbers for
various documents that need them:
CRE
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's.
In my application, I have a table that stores the sequential numbers of
invoices prepared by several stores. Every time a salesman prepares an
invoice for a customer, the system goes to this table, locks it with lock
tables write, read
Reto Baumann wrote:
Is there a way to see if the key buffer size was ever reached?
It's not really an issue. You can determine how frequently it
has the needed index data in memory, to judge the key buffer
efficiency.
Key read requests 3518220013
Key reads 94807
Key reads / Key
Hi all
I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The
database primarily uses MyISAM tables with 60% SELECT statements. The database is used
as a backend for a PHP web application.
Do the following values make any sense?
set-variable= key_buffer=200M
set-
1 - 100 of 232 matches
Mail list logo
