Hi,
May I offer a bit of distraction and an idea?
Below might draw flames of (browse the site), but I like databases because
they turn me on
I am a recovering micsofrot addict. WHEW! It feels good to get that off my
chest. I am also a Linux newbie (Since 12-00) and am exploring MySQL. I hav
SATYAN NAIR writes:
> dear friends,
> i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0
> it says REQUIRES PERL5 at /usr/bin/perl5
> and under /usr/bin i have perl as well as perl5.006
>
>
> please let me know how do i install the rpm on linux!!
Hi!
We have fixed this pro
It would be better if you asked this question in the oracle lists.
Anyhow, here's the code for a simple select script:
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect("dbi:Oracle:dbname", $user, $password) || die "Can't
connect to dbname: $DBI::errstr";
my $sth = $dbh->prepare( q{
SELECT
This is a follow-up to my post "slow queries -> crash"
I've searched through the MySQL manual and the complete mailing list
archive after "Got an error reading communication packets" and I've found
two postings in the mailing list archive which refers this error to
replication.
So, is replicatio
Hi,
I'm very new to MySQL and tries to execute some applications with it...
I'm having problems which are certainly do to a misunderstanding of how
MySQL works...
I want to access to MySQL with any application where I want to show only the
20th records of the table or of the result of a query (w
Hello everybody,
I have problems to integrate a UDF into mysql!
The systems aborts with the error message:
ERROR 1126: Can't open shared library 'FThumbnail.so' (errno: 22
/vol/ibase/Sicherheitskopie/dipl_NWI/Feature/programming/FThumbn)
The LD_LIBRARY_PATH is set correctly! And the shared obje
Well, I run an online comic strip at http://www.monkeydyne.com/rmcs/
I've done so for three years now, and this is the first time I've been
stumped enough to ask the mysql list for help.
On the site, users can submit their own comics and they can vote on
other people's comics. When a particular
>Description:
gcc -O2 -s -I/usr/include/ncurses -DNCURSES
-I/usr/local/mysql/include -I/usr/local/iceb/include
-DCONFIG_PATH=\"./\" sozs
qlbaz.o -o sozsqlbaz -lncurses -L/usr/local/iceb/lib -ldev -lbuh
-lutil -lscr -lsql -lconfig -L/usr/local/mysql/lib -lmysqlclient -lm
/usr/loc
* Soren Ragsdale <[EMAIL PROTECTED]> wrote on 11.01.01 11:30:
> SELECT comics.tagline,votes.score FROM comics,users LEFT OUTER JOIN
> votes ON comics._rowid=votes.comic AND votes.voter=30 WHERE
> users._rowid=comics.author;
I would try the simpler inner join to get the result you want:
SELECT co
Hi !
I'm new to the list, new to MYSQL in general, although not to SQL, and i was wondering
if it is possible to drop a field from a table in MYSQL and what is the correct sintax
to drop it.
I have been searching in the Dubois's MySQL book but it didn't told any about, or at
least i didn't fo
The ALTER TABLE syntax is explained thoroughly on section 7.8 on the manual
pages.
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
orADD [COLUMN] (create_definition, create_definition,...)
Make sure you have zlib installed and add -lz to your linking options.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/
Hello mysql,
I've recently tried to do a test of mysqld with big tables (>4GB) on
linux 2.4 mysql 3.23.30
1) The strange thing is even without setting up max_rows got a
table to grow for more than 4Gb with insert test. Is this possible ?
(May be you use special pointers for static ro
Hi,
I have read on some presentation that you can create a table in
memory that then gets written to disk once every few hours.
I can't find information about that in the documentation, but it
would be a perfect solution for me. I need 500+ updates per second,
so a table in memory would be th
Hello!
I want to install mysql-3.23.29-1.src.rpm on an Dell Poweredge 2400 with 2
PIII 700 MHz processors. After rebuilding the src code, i install the rpms.
My problem is, that I can't start the mysqld deamon. I've tried to install
the pre-compiled rpm files with the same result. The same files
Hi !!!
I was wondering if there's any other method in SQL to test if a given record exists
that the typical error handling or the archetypical select clause looking for the
primary key.
I'm making a table where the e-mail adress is the primary key, nothing amazing but
it's my first MYSQL data
I have a strange problem with MySQL 3.23.30 running on my server.
Configuration:
1 Intel Pentium III
512 meg. RAM
RedHat Linux.
Basically eveithing works fine. Eventually, the system comes to a grinding
halt,
with load average hovering around 20.00.
Here's a processlist :
+--+---+
Hi,
I have to deploy a java GUI to a remote MySQL server. The GUI part is OK,
but now I have some concerns about security issues, like: how could the
conduit between the GUI and the database be secured (possibly encrypted) ? I
think one solution would be to use SSL, but that implies SSL support o
Hi!
New version of mysqlgui for Windows, version 1.7.4 has (finally) hit
mysqlgui page on our site.
What follows is readme that accompanies this Windows version.
This is a static binary version of the MySQLGUI client, version 1.7.4
for Windows.
This is a fifth release of MySQLGUI version
ÎÒÔÚÎҵĻúÆ÷ÉÏ°²×°ÁËRedhat
7.0·þÎñÆ÷È«°²×°£¨ÆäÖÐÔÚ/usr/sbin/Ϻ¬ÓÐperl5.6.0)µ«ÎÒÔÚ°²×°MySQL-3.22.29a-1.i386.rpmµÄʱºò£¬×ÜÌáʾÎÒÐèÒª/usr/sbin/perl5,²»ÖªµÀΪʲô£¬ÇëÖ¸½Ì£¬Èç¹ûÎÒÏë°²×°MySQL¾¿¾¹¸ÃÔõô²ÅÄÜ°²×°perl5¡£
Hi,
check the following for a description on HEAP tables.
http://www.mysql.com/documentation/mysql/commented/manual.php?section=HEAP
HEAP tables are suitable as temporary tables since they are not saved to
disk. What you can do if heap tables suite your needs is to write a script
which writes a
[EMAIL PROTECTED] writes:
> Hey there, I've written about this a few times now and haven't received very many
>ideas.
>
> I'm running a pentium based server with 256 megs of ram using BSDI O/S 4.1
>
> I currently have the latest build of Perl 5 on my system as well.
>
> When I do a mak
Thierry Coopman writes:
> Hi,
>
> I have read on some presentation that you can create a table in
> memory that then gets written to disk once every few hours.
>
> I can't find information about that in the documentation, but it
> would be a perfect solution for me. I need 500+ updates
Anton A. Zabannikh writes:
>
> I have a strange problem with MySQL 3.23.30 running on my server.
> Configuration:
> 1 Intel Pentium III
> 512 meg. RAM
> RedHat Linux.
>
> Basically eveithing works fine. Eventually, the system comes to a grinding
> halt,
> with load average hovering aro
-Hallo
- If you want views and stored procedures you can try something like
Postgresql.
- I believe this is explained in the MySQL documentaton.
On Thu, 11 Jan 2001, Pål Wester wrote:
> Is there any way to create views or stored
> procedures in mysql?
>
> thx in advance,
> Pål Wester
>
>
>Bob Hall writes:
> > >This is the first time I've ever been directly in charge of adminstering a
> > >mysql server. I have a few questions. Since I can't get mysql 3.23.X to
> > >install, I'm stuck with 3.22.30 and I was wondering what I could do to
> > >facilitate backups, and to be able to
hi,
i've Mysql installed on linux, binary install,
i launched the server : bin/safe_mysqld &
and if i try to connect to mysql ( mysql -u root -p mysql ) i get this
message :
Can't connect to local Mysql server (111)
i tried : mysql -u root test but i get the same message.
how to debug this ???
Hi Siim,
Both things are really implemented, in one way or another.
To secure your servers parms just uncheck Save Password in the
Options=>Preferences. This way every time you start DBTools it will ask you
the passwords to connect.
Importing from MSEXCEL it's already done and working. Just ch
fractals wrote:
> I have to deploy a java GUI to a remote MySQL server. The GUI part is OK,
> but now I have some concerns about security issues, like: how could the
> conduit between the GUI and the database be secured (possibly encrypted) ? I
> think one solution would be to use SSL, but that i
I have started testing MySQL 3.23.30g with latest MySQL provided Berkeley
source (3.2.3g)
I am using RedHat 6.2 and RPM source of MySQL. I compiled MySQL and altered
my existing tables to BDB.
So far my tests show that transactions are working. They are working for
new BDB tables and the altere
Maybe it is the lack of coffee this morning talking or maybe it is the fact
that I have spent 4 days trying to get mysql up and running on linux(a
platform I am unfamiliar with) but I assumes this mailing list would allow
me to have contact with other users who have been thru the same issues I
hav
Sorry for my English.
I would like use jdbc with MySQL.
I write this code but I've a running error.
Why ?
The code :
import java.sql.*;
import java.util.Properties;
import java.io.FileInputStream;
import java.io.IOException;
public class ConnectionDB {
private Connection con;
public Conn
I was looking to see the length or size of the BLOB data type in the manual
and it is not listed. Does anyone know the size of BLOB?
Also what is the largest number that can be stored in BIGINT?
Thanks,
Mike
-
Before posting
Mr. Samuel,
Im new in this field (mysql, linux, etc.), I am a MCSE, and at this time, I try to
impulse this software (Mysql, Linux, etc) in Central America, I see many feactures
in this software but I need to Know if exist a maillist for dummies as I, mybe in a
two months I can give to people like
Hi,
> I was looking to see the length or size of the BLOB data type in the
> manual and it is not listed. Does anyone know the size of BLOB?
> Also what is the largest number that can be stored in BIGINT?
you can find answers to both of your questions at:
http://www.mysql.com/doc/C/o/Column_ty
Thank you.
> Both things are really implemented, in one way or another.
>
> To secure your servers parms just uncheck Save Password in the
> Options=>Preferences. This way every time you start DBTools it will ask you
> the passwords to connect.
>
> Importing from MSEXCEL it's already don
I _need_ help with this connections-to-mysql issue. Until I changed a few stuff in the
MySQL setup, I kept getting the "Too many connections" message when connecting. After
increasing both max_connections and table_cache, I get the error:
Warning: Can't create a new thread (errno 11). If you ar
> Carlos Corzo wrote:
>
> > Some people have tried the manuals verbatim but are really confused
> > because they are not at your intellectual level. If this list is for
> > the "intelligent only", change the title please. Not everyone can
> > decipher a manual. I may post questions but there ar
Good idea
Quentin Bennett wrote:
> Perhaps, along with the 'Please check the manual' message at the end of all
> messages, there should be a reference to a reliable archive, allowing list
> users who are referred to the archive an easy way of finding it!
>
> Quentin
>
> > -Original Message--
Xavi Gracia wrote:
>
> Hi !!!
>
> I was wondering if there's any other method in SQL to test if a given record exists
>that the typical error handling or the archetypical select clause looking for the
>primary key.
>
> I'm making a table where the e-mail adress is the primary key, nothing ama
On Thu, 11 Jan 2001, Johan Björk wrote:
> I _need_ help with this connections-to-mysql issue. Until I changed a few stuff in
>the MySQL setup, I kept getting the "Too many connections" message when connecting.
>After increasing both max_connections and table_cache, I get the error:
>
> Warning:
In order to conserver bw I'll only through my $0.01 in...;) I do believe that
if you search the list you will see that many of us who are not on the devteam
do answer questions. Although I do whole heartedly believe in RTFM; I agree
with you about the power of the people, and feel it is important
Hi!
I'm using mysql version 3.23.29a under a heavy loaded production
environment. Now I've set up our mysql server as replication master and
installed second mysql machine to be the slave.
Replications as itself works, but how do I get the slave server in sync with
the master without shutting do
i can now connect to mysql but when i login as root with the root
password i get the ERROR 1044 : Access denied.
if i don't give any password i can connect but if i write:
mysql> use mysql
i've got the same message, so i can't do anything neither connect nor
create database,tables...
-i made the
It is not that the "seasoned veterans" don't want to help you. They want to
know that you have helped yourself first before seeking help from them. It
is obvious when someone asks a question and they haven't tried reading the
manual first. A question that comes up from time to time is "how do I
Human nature and education...
In most cases as youngsters we are 'given' the answers and the methods for
solving our problems. As we get older we continue to expect this and un-able
to function when told to figure something out.
My first computer class in High school (NCR Mainframe/BASIC), I h
- Original Message -
From: "Franck ABELLI" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 23:29
Subject: ERROR 1044
> i can now connect to mysql but when i login as root with the root
> password i get the ERROR 1044 : Access denied.
> if i don't give any pa
Hiya
I compiled mysql-3.23.30-gamma.tar.gz
using pggc version pgcc-2.95.2.1
and kernel 2.4.0
CFLAGS="-Os -O6 -march=pentium"
CXXFLAGS=$CFLAGS
configure:
./configure --enable-static --prefix=/usr/local/mysql
--localstatedir=/home/mysql --enable-assembler
when running the tests:
...
join_o
Hiya
update:
when using --force this one fails too
and the system is redhat 6.2
rename0.16 0.12 0.32 [ pass ]
replace 0.19 0.08 0.30 [ pass ]
rollback 0.17 0.09 0.26 [ pass ]
rpl01
Interesting. My guess is that you must be in your early 20s. When I was at
high school (& even uni), apart from normal lessons, researching for
assignments, etc, meant going to the library, not downloading the answer
from the internet. Internet didn't exists in those days. Maybe in the
States i
I am running SuSe 7.0 and have had the same experience. I think that I
remember reading in the SuSE manual about some standard Linux directory
structure which they are using. I wonder if this is a recent Linux standard
and MYSql.RPm has not
been updated to use this structure. I do not find the fil
我懂你的意思可是我中文不好, so I'll write English instead.
This is an FAQ. Just ignore the error and force the install.I.e. use
the --nodeps flag
- Original Message -
From: "weixin2001" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 19:49
Subject: 请教！
> 我在我的机器上安装了Redh
Thanks, but actually I'm late 30s. The high school where I went was given
federal and state funding to build their system and the class room had it's
own liberary of 1000+ books. We did not not have access to the internet, in
fact I don't think the phrase had been 'coined' yet. We used DECwrite
This is an FAQ. Just force the install, ignoring dependencies. --nodeps, I
think, is the switch. This will be fixed with the next Mysql version.
- Original Message -
From: "kentj" <[EMAIL PROTECTED]>
To: "Neil Zanella" <[EMAIL PROTECTED]>; "MySQL Mailing List"
<[EMAIL PROTECTED]>
Sent: F
So you've "bound" the datasource to the text box. I've never done
that. I've always done all my ado updates manually. I suggest you look
into doing all the ADO work on the backend, and manually update your text
boxes. I've never had any problems doing that. Binding isn't very good
practic
Try building from source from the mirror site http://mysql.hjc.edu.sg if u
are in India.
Cheers.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
That garbage was written in Chinese, but you probably don't have the chinese
character font so all you'll see is garbage.
The guy said he installed Redhat7.0 and also perl 5.6.0 in the /usr/sbin
directory. When he tried to install MySQL, he gets the "now famous" perl5
dependency check error and
Hello,
I have switched this morning our Web server from mSQL to MySQL.
I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm
on a Linux server (RedHat 6.2).
mysqld dies very ofen (uptime is between 2mn and 20mn) and
the only messages I have in error file look like :
Number of process
Hi!
> "Ask" == Ask Bjoern Hansen <[EMAIL PROTECTED]> writes:
Ask> Hi Monty,
Ask> a few fixes to mysqlhotcopy.
Ask> :-)
Applied; Thanks!
Regards,
Monty
-
Before posting, please check:
http://www.mysql.com/manual.ph
Hi Friends, I'm Riccardo Scannapieco, an italian's boy! Sorry for my
english, it isn't very good! I installed mysql 3.22.25-1 but it doesn't
running! When I launch the command safe_mysqld & the deamons start and end
quickly.
How I can resolv my problem?
---
Ok, I finally managed to get it installed.
Someone over at MySQL gave me some input and I want to document how to get
the bloody thing installed:
You must have
1) autoconf and automake installed.
2) Use Make version 3.79
Execute:
aclocal
autoconf
gmake
Get lunch, when you come back you'll
Guys,
Amen. When I was 13 and got my first commodore 64, I decided to teach myself
BASIC. All I had was the manual. (the MySQL manual is the library of
congress compared to this manual!) There simply were no other resources for
me since I couldn't afford a modem until 2 years later, when I got a
Hello
I need to migrate the structure of my MSSql database with its relations and
tables to MYSql. Is it possible? And how do i make that happen?
I have searched through a LOT of sites and forums on the internet but I have
not found the answer. Perhaps one of you know the answer?
Grateful fore
I posted a couple of days ago abou this error and got no response, so I am
trying again with a bit more detail this time. I am running mysql
3.23.28-gamma on a pretty much stock RH 6.2 box. I am accessing the
database using Perl CGI scripts and the DBI API. I have reset the
max_allowed_packet a
Check your error log, usually located in the main database directory
(/var/lib/mysql on my sys)
- Original Message -
From: "Riccardo Scannapieco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 9:42 AM
Subject: Mysql doesn't running
> Hi Friends, I'm Riccard
Hi,
I am new to mysql. I want to know if there is
thread locking support for java and concurrency
control mechanism in mysql.
I will be thankful for any help in this regard.
Please cc the answer to me since i am not in the mailing list.
TIA,
Mitul
--
M
No, it should work just fine 'out of the box' with SMP kernel. Most
likely you have a permission problem. Check permissions of your MySQL
data directories.
I have a dual P866 Dell Poweredge 2400 / RH Linux 7.0 / MySQL 3.23.29a.
Works just fine.
Cheers,
Vadim.
Lars Freymark wrote:
>
> Hello!
>
Excellent post, Neil! I'm with you! (Sorry to be using up the bandwidth
with this "me too" stuff, but couldn't help it :))
Cheers,
Vadim
Neil Davis wrote:
>
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decided to teach myself
> BASIC. All I had was the manual. (the MySQL ma
this is curious:
the table:
CREATE TABLE inbw_day_diffs_2001_Jan_02_10 (
hostname char(20) NOT NULL default '',
variable_name char(64) NOT NULL default '',
variable_index_value char(114) NOT NULL default '',
variable_index_label char(50) NOT NULL default '',
variable_result_value_numer
Hi,
I just installed LinuxThreads on my server, to use with MySQL to get maximun
performance from my dual CPU setup.
The README.FreeBSD file tells me to compile applications with the following
line:
-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -llthread -llgcc_r
But where should i
The books you are using are probably outdated as installation
instructions tend to change from release to release.
Installation instructions are perhaps one thing that should
not be put in a book. Rather a book should tell you where to
find the installation instructions. The MySQL RPMS do adhere
I have a database with tables containing file names with a .sgm
extension.. Any ideas as to how I could traverse the database through
the different tables and change all the .sgm extensions to .htm?
Any easy way?
--
Ashwin Kutty
Systems Administrator
Dalhousie University Libraries
(902) 494-269
Hi All,
What is the best way to move an entire row of data from a table in one
database to another table in a different database? The two databases are on
the same system.
Thanks in advance,
Dang H. Nguyen
-
Before posting, pl
I am trying to do the same thing. The best bet so far is mysqldump.
You can find more detail in
http://www.sql.com/document and do search on mysqldump
Pär Lindhe wrote:
> Hello
>
> I need to migrate the structure of my MSSql database with its relations and
> tables to MYSql. Is it possible? And
Go to the MySQL Contributed page and go from there to get the Zeos MySQL
components. (They may be under Borland Delphi, but they come with components
for C Builder 4 and 5)
Either that, or you can just use the standard TDataSet components and use
MyODBC to create the data source.
- Original
Neff Patrick K writes:
>
>
>
> I in fact finally got mysql up and running last night but not one
> word in your manual helped me do it. So in fact all the reading in
> the world would have left me sitting in the same position.
Neff,
What stumbling blocks in the documentation did you run acros
I think you need to copy data first then delete the data.
copying data between two databases:
insert into databaseA.table select * from databaseB.table where .
delete data :
delete from databaseB.table where ...
Dang Nguyen wrote:
>
> Hi All,
>
> What is the best way
Matt Wagner writes:
> SATYAN NAIR writes:
> > dear friends,
> > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0
> > it says REQUIRES PERL5 at /usr/bin/perl5
> > and under /usr/bin i have perl as well as perl5.006
> >
> >
> > please let me know how do i install the rpm on
My personal opinion on the documentatios is:
It is good, however it is written in a very dry and technical manner
which will be hard to understand for less technically inclined
people.
This I guess is normal since the docs are probably written by the
same people that actually work on MySQL.
Hi!
Do HEAP tables use table locking?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
If I may add my 0.5c here too, the MySQL manual, like so many of its kind
was obviously written by a highly skilled developer(/s) but who, like
virtually all of that ilk, lacks the ability to impart knowledge to others.
As always, the issue is largely that of ignoring countless items considered
tr
We have been using 3.23.28-gamma with berkely db files so we can use
transactions.
Platform: BSDI 4.1
Everything was rolling along fine when we ran into this while doing some
simple command line stuff...
It gives me the error that mysql has gone away... lost connection...
Something I have se
The fundimental problem lies in human nature craving social contact. Even us
geeks need it. No matter how good a manual is, people will still come and
ask first/read later just to hear (read, whatever)someone else say "Go read
the damned manual". I think we all need to lighten up on this whole sub
If the manual was written any better, you'd put all those book publishers
out of business. The reason this list has such a high volume of traffic
might not be ambiguity of the online manual, rather the popularity of MySQL.
The contents of the manual are more than sufficient, but the search could
Doug Young wrote:
>
> If I may add my 0.5c here too, the MySQL manual, like so many of its kind
> was obviously written by a highly skilled developer(/s) but who, like
> virtually all of that ilk, lacks the ability to impart knowledge to
> others.
The MySQL manual available at www.mysql.com is t
My pennies worth:
The manual is excellent, read it! Be patient, it may take you a while to
find exactly what you are looking for. You can always try entering "mysql
your_key_words_here" in the google search http://www.google.com to see what
else pops up.
Actually the MySQL docs search is pretty
> any thoughts/suggestions?
>
> the only thing that's different is the SUBSTRING_INDEX(MAX(CONCAT()))
> construct, and i can't immediately see why that slows it down so
> much...
okay, with gdb i can see that this column becomes a blob (thereby
not allowing heap tables to be used - which has got
I'm going to contribute to this discussion again. I want to counter some of
your basic arguments.
You seem to be trying to place MySQL newbies in the same level as computer
newbies. IMHO, this is a very bad thing to do. Someone who is going to be
working with MySQL is going to be using it for
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I've recently tried to do a test of mysqld with big tables (>4GB) on
Peter> linux 2.4 mysql 3.23.30
Peter> 1) The strange thing is even without setting up max_rows got a
Peter> table to grow for more th
SATYAN NAIR wrote:
> dear friends,
> i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0
> it says REQUIRES PERL5 at /usr/bin/perl5
> and under /usr/bin i have perl as well as perl5.006
RedHat includes perl5, it is the dependency rule which is broken.
Just install as
I'm trying to run a very long query and after trying it in various
ways, it seems like there is a limit to the number of characters
allowed in a query.
If this is true, is it possible to increase the number of characters allowed.
(the database is hosted at an ISP)
I've tried -q and -f in the q
I know everyone on this list has discussed scaling over and over.
I am only in a need of a simple anwser.
Can mysql handle a database with 20,000,000 records?
There will be several tables(about 10) each with no more that 4 columns.
In each table there will be 20 million records. These table
hi,
I am working on Mysql Database. I am facing following problem while trying to grant
permission after login as administrator
mysql Ver 9.16 Distrib 3.21.33b, for pc-linux-gnu (i586)
server version: 3.21.33b-log
mysql> grant all on temp.* to ravi@localhost identified by 'ravi';
ERROR 106
What size records, what OS, what processor? Linux on 32 bit platform
does have a file limit which might come into play.
On Thu, 11 Jan 2001, Chris Murley wrote:
> Date: Thu, 11 Jan 2001 17:54:23 -0600 (CST)
> From: Chris Murley <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: The scalin
Hi All.
I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm
using redhat 7 any ideas?
c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o
sql_string.o completion_hash.o ../readline/libreadline.a -lncurses
../libmysql/.libs
Greetings,
I have just subscribed to this list, so I am really sorry if I'm asking a
question that has been asked already, but I wasn't having any luck plowing
through the archives, so I thought I'd try my luck with the list.
I'm using MySQL 3.23.29 with PHP4 and apache 1.3.14 on a FreeBSD 4.2
Surely this is a PHP question, not a MySQL Question
> -Original Message-
> From: Ryan Hagan [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 1:14 PM
> To: [EMAIL PROTECTED]
> Subject: urgent question
>
> Greetings,
>
> I have just subscribed to this list, so I am really
I have a database in which one table has 15,000,000 records and another has
50,000,000 records.
Selects work fine so long as you use an index.
You may be limited by the OS.
Regards
Quentin
> -Original Message-
> From: Chris Murley [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2
There is a limit to the size of a packet sent to mysqld, which is
configurable. Check the manual for it, and see if you are hitting that.
Regards
Quentin
> -Original Message-
> From: Mark Dale [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 12:39 PM
> To: [EMAIL PROTECTED]
>
I've tried "mysql --set-variable=max_allowed_packet=8M" with no luck.
I'm not getting the error message.
The query has multiple selects. When I copy and paste the query with
4 selects in it, everything's fine. If I try with 5, it dies half way
thru the 5th select as its pastes.
Any more clues
1 - 100 of 129 matches
Mail list logo
