On 7/21/2010 12:16 PM, Nunzio Daveri wrote:
database is around 150GB with over 5,000 tables. To make things worse, if I
shutdown MySQL, top-c still says all the memory is still used? Is this a bug,
why would it say all the memory is used when I turn off MySQL. The weird thing
is that when I
Dan Nelson wrote:
In the last episode (Jul 06), Blog Tieng Viet said:
I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
problems related to thread management. And 1 year ago, I found that my
FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
because
Hi Dave,
There is not enough information here to know if your test is failing
or your compile is bad. Did the compile complete without errors? What
version of BSD/OS are you using there are many versions and varieties.
Most of them have a package system with per-built binaries, I would
Try a union instead of an or condition.
http://dev.mysql.com/doc/refman/5.0/en/union.html
Johnny Withers wrote:
I have the following tables:
Customer: id,ssn
Customer_Id: id,customer_id,id_num
The customer table holds customers along with their SSN and the customer_id
table holds
, Ken Menzel wrote:
Yes, you can still use a hostname in the connection string, that's
not what mysql uses it for, that hostname gets you from the client
to the server. If you use GRANT to permit access from certain hosts
IE 'grant all on mydb.* to 'mydbuuser'@'%.mydomain.com'. Then the
server
can still use a hostname in the
connection string, and it works.
On 23-Sep-08, at 5:44 PM, Ken Menzel wrote:
Hi Rene,
This smells like an old freebsd issue with a non thread safe
get-host-by-name issue and possibly other thread issues. Since Mac
OS/X/Darwin is a freebsd 4 branch
Hi Rene,
This smells like an old freebsd issue with a non thread safe
get-host-by-name issue and possibly other thread issues. Since Mac
OS/X/Darwin is a freebsd 4 branch it is a good bet they are the same.
Is it possible for you to try adding skip-name-resolve to my.cnf.
Alternatively you
VeeJay wrote:
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs...
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below is
the method we are following.
1. create empty table with all the indexes.
2. disable keys
3. Load data using LOAD DATA INFILE, close to 99 Million records which takes
around 3 hrs
4 . Enable
Ananda Kumar wrote:
We have 200GB of free space on the file system where our database is
located.
On 6/12/08, Ken Menzel [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
Hi All,
We are doing load data into a table using LOAD DATA INFILE process. Below
is
the method we are following.
1. create
Nanni Claudio wrote:
You can try to dump-to-sql the whole DB,
Create a new DB and import the sql-dump in the new DB.
Aloha!
Claudio
-Messaggio originale-
Da: Thomas Raso [mailto:[EMAIL PROTECTED]
Inviato: martedì 12 febbraio 2008 17.20
A: mysql@lists.mysql.com
Oggetto: rename
- Original Message -
From: Chris [EMAIL PROTECTED]
To: jekillen [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version
Have a look at kern.threads.max_threads_per_proc: 1500
and kern.threads.max_groups_per_proc: 1500
You are probably hitting one of these sysctl's. Here is a link to
some other info
http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2006-01/msg2.html
There is also a wiki on
http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html
enable old-passwords in my.cnf
Hope that helps,
Ken
- Original Message -
From: Odhiambo Washington [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 22, 2006 1:38 PM
Subject: MySQL 4.0.27-client and
Hi,
I just saw your e-mail.
We use mysqldump on solaris 9 with large files all the time. Is the
partition you are writng the file to mounted with the largefiles
option in /etc/mnttab?
Our mysql dump files are 25 gig.
Ken
- Original Message -
From: Duhaime Johanne [EMAIL
Hi Bruce
SNIP
- Original Message -
From: Bruce Dembecki [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, December 30, 2004 2:51 AM
Subject: Re: Fixing the worst InnoDB corruption bug in 3 years -
when
As a side note with demonstrated performance increases when using
Hi,
It sounds like you are using the default thread library. I would
install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see
options in Makefile) or barring that try Jeremey's excellent build
recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We
used to have the same
Hi Terence,
Hi all,
My system reports:
Open_tables 512
Opened_tables 24,429
The docs say that if the latter is high I should increase the table
cache size. (currently at 512)
Looks like you should do that.
How does one decide what size to increase it to? And is there a
problem
with
Hi,
Signal 11 can also indicate hardawre problems on BSD. Also FreeBSD
might get you more answers quickly as there are more of us running
FreeBSD with MYSQL for some reason. We runn FreBSD w MySQL/Linux
threads on 4.9 and 5.2 and both work just fine.
Ken
- Original Message -
From: RV
Should work fine. Quick test from a large sales test table (1.9
million rows):
mysql select count(*) from sali;
+--+
| count(*) |
+--+
| 1983026 |
+--+
1 row in set (0.00 sec)
mysql select salidate,sum(saliQtySold) from sali where salidate
DATE_SUB(CURRENT_DATE,
Hi Bob,
I don't use openBSD, but from the FreeBSD ldconfig man page I have:
-m Instead of replacing the contents of the hints file with
those
found in the directories specified, ``merge'' in new
entries.
Directories recorded in the hints file by previous runs
Hi Guy's,
first: Your are correct it is contraints:
bash-2.05a$ perror 150
Error code 150: Unknown error: 150
150 = Foreign key constraint is incorrectly formed
Second you could also try:
set foreign_key_check=0;
at the beginning of the restore file.
set foreign_key_check=1;
at the end!
hi Lou,
I believe this is a recent feature so make sure you on on 4.0.18 if
possible, I know is was added before 4.0.14. I am not sure this
works on 3.23.
Ken
- Original Message -
From: Lou Olsten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 10:38 AM
Subject:
Hi Andy,
The best way to accomplish this is at an application level, setup a
lock table and put your locks in there. There are many methods for
handling application locks. Choose one that work for you. With a
database level lock, when the connection terminates the lock is
released.
Persistant
Hi Kamlesh,
You should send an explain of the query, but if there is no index
on tableB.user_id your join will not work well, since the actual join
would be on tableB.user_id=tableA.user_id
Either change your index on table b to be user_id,user_data2 or add
this index.
Hope this helps,
Ken
Seems like MySQL is selecting the primary key, or thinks that reading
all rows is faster than using the month_day key.
What happens if you do one day at a time with an = as in:
WHERE month_day = 14
or WHERE month_day = 14 AND month_day=7 (etc)
Does it run faster? Does the explain show key
Hi Erek,
This seems familiar to me, are use still using Solaris make? If
yes, try using GNU (gmake) it looks like a make problem. Hope this
helps,
Ken
- Original Message -
From: Erek Dyskant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 12, 2004 8:44 AM
Subject:
Are you able to run show process list? What is the status of your
query? What date was your freeBSD 5-current built on? Please send
output of uname -a, so that we know exactly which version on which
date because -current changes every day.
Also are you using libmap.conf? If yes, what are it's
Hi Sam,
There are many methods and you should alsways employ more than one.
The first is to use the grant system inside of mysql
http://dev.mysql.com/doc/mysql/en/GRANT.html
If you want no network access at all use
--skip-networking
Don't listen for TCP/IP connections at all. All interaction
Hi Kirti,
mysql_config tell the perl build module how to link with the
driver. The easiest way to fix this is make sure the bin driectory of
MySQL is in your path. If you can type 'mysql_config' at the command
line and get an answer like:
Usage: /usr/local/bin/mysql_config [OPTIONS]
Options:
Did you run it from the directory from which you install mysql? EG:
Installed mysql at /usr/local/mysql-max-4.0.18-sun-solaris-etc
cd /usr/local/mysql-max-4.0.18-sun-whatever-the-rest-is
./bin/mysql_install_db --user=mysql
a.. If you installed MySQL using a binary distribution, use this
Just type in the empty search box at the top of the screen:
DBI returns:
http://search.cpan.org/~timb/DBI-1.42/DBI.pm
mysql returns:
http://search.cpan.org/~rudy/DBD-mysql-2.9003/
Hope that helps
Ken
- Original Message -
From: Kirti S. Bajwa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
.* TO 'usager'@'localhost' identified by
'mot-de-passe'
vois:
http://www.mysql.com/doc/fr/GRANT.html
espère que ça t'aide,
Amicalement,
Ken Menzel
- Original Message -
From: samana [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 7:57 PM
Subject: aide urgente site
Hi JJ,
Not really a MySQL question but more a UNIX/Linux question.
UNIX 101
If mysqldump encounters an error it will like all well behaved
programs write an error message to stderr. You can also from your
script check the error return from the command and perform additional
actions. I would
Hi Charles!
Great, a little extra info is needed. Is it windows XP or 2000?
My guess would be not the server version?
What do you mean running as a server? Did you tpe something like
cd c:\mysql
mysqld --install or mysqld --install-manual ??
Also what version of mysql?! The
That's a mess of a problem. If the libraries were included in the
link,
configure must have detected them on your system somehow, but now
they are not
working. Did you by any chance use --with-mysqld-ldflags=-all-static
?
Yes I did, now I realize this doesn't work on Solaris. I tried
Hi Ganbold,
I think you are asking in the wrong place. I would suggest
[EMAIL PROTECTED] or [EMAIL PROTECTED] or [EMAIL PROTECTED] see .
But my personal thoughts on this is if you are not ready for these
types of issues don't track freebsd-current. This is bleeding edge
stuff. FreeBSD-stable
Not at this time, however you could have two different slaves on the
same physical server using mysql_mutli type of configuration.
http://www.mysql.com/doc/en/mysqld_multi.html
Hope it helps
Ken
- Original Message -
From: Ari Davidow [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
OK, sorry to answer my own post, libgcc was is /usr/local/lib which
did not get properl added with crle!
crle -u -l /usr/local/lib
Problem gone! Sorry to waste bandwidth (we are just learning
solaris!).
Ken
- Original Message -
From: Ken Menzel [EMAIL PROTECTED]
To: Sasha Pachev
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Cliff,
Either way for a production system I recommend using Linuxthreads
with FreeBSD4 (also works on 5 but threads are much improved on 5).
Please use the ports and make WITH_LINUXTHREADS=yes and others that
use (see make pre-fetch in
/usr/ports/databases/mysql-favorite-version)
or
Bonjour Pierre,
Non mysql ne support pas un format hyperfile. C'est un format
propriétaire. S'il il est possible d'exporter les donnees en format
ASCII ça pouvait marcher avec un mysqlimport ou load data commande.
Voici le doc en français:
http://www.mysql.com/doc/fr/mysqlimport.html
En plus
Hi Andre,
I think you are looking for this:
http://www.mysql.com/doc/en/Binary_log.html
Hope it helps,
Ken
- Original Message -
From: Andre MATOS [EMAIL PROTECTED]
To: Ware Adams [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 12:09 PM
Subject: Re: MySQL Backup
Hi Christof,
You don't mention the OS version you are using (So I will assume
Linux) is there a sysctl for the max number of threads on your OS?
Ken
- Original Message -
From: Christof Egner [EMAIL PROTECTED]
To: James Kelty [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday,
Hi Ronan,
Did you perhaps set MAXDSIZ is your kernel configuration above
(2047UL*1024*1024) ?
Ken
- Original Message -
From: Ronan Lucio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 3:06 PM
Subject: my.cnf in MySQL-Server-4.0.17
Hi All,
I´m trying to
Hi Arnaud,
I did not see an answer to this so; I think the info you need is
here http://jeremy.zawodny.com/blog/archives/000203.html and here
http://jeremy.zawodny.com/blog/archives/000697.html
But I think you want skip-name-resolve to be specified in my.cnf.
Ken
I have included the relevant
Hi Leo, a quick search for multiple daemons at www.mysql.com/doc
reveals:
http://www.mysql.com/doc/en/Multiple_servers.html
This should give you all your answers and make it possible to do what
you want.
Hope this helps,
Ken
- Original Message -
From: Leo [EMAIL PROTECTED]
To: [EMAIL
Perhas you want SELECT DISTINCT ?
http://www.mysql.com/doc/en/SELECT.html
Hope that helps,
Ken
- Original Message -
From: Hunter, Jess [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:47 AM
Subject: How to keep multiple instances of the same information from
Len,
You shouldn't post private information to a public mailing list
(never do that!). Please send these type of questions to
[EMAIL PROTECTED] But my guess is you should download and install it
if you have not already done so.
Ken
- Original Message -
From: Len Buchanan [EMAIL
Hi Robert,
I did not see any suggestions to you. So here is one. If you want
a guarantee simple brute force dump the entire DB with mysqldump and
recreate of the slave.
For Exmaple
mysqldump --opt mydb | mysql -umyuser -pmypwd -hremotehost myremotedb
You can run this through an ssh tunnel for
Hi Rob,
My guess would be you did not see this in the Fine Manual
http://www.mysql.com/doc/en/Post-installation.html
or this
http://www.mysql.com/doc/en/Starting_server.html
Hope this helps,
Ken
- Original Message -
From: Rob Snow [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
Hi Alex,
What user is the mysql daemon running as? Are there any limits on
that user or user class (/etc/login.conf). Just because you have
raised the kernel limits does not mean they are raised for the user.
Can you login as that user and type limit and get something like -
%limit
cputime
Hi Franz,
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number
You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
Syntax using table options at the end. Use the MAX_ROWS
parameter and set
Hi,
- Original Message -
From: [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:52 AM
Subject: Re: Views in MYSQL
much cut
What about when the script uses persistent connections, these Temp
Tables
would never go away
Bonjour Frédéric,
Ce liste est en anglais. Je crois que tu veux http://www.vbmysql.com . Mais le
site est en anglais. Il y a beaucoup de exemples de VB 6 et VB .net sur ce site.
En plus il existe un liste français à (mais il y a récemment beaucoup de silence) :
Liens utiles :
Poster un
http://www.mysql.com/doc/en/DELETE.html
and from that page:
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
or
DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
In the above case we delete matching rows just from tables t1 and t2.
From MySQL 4.0, you can specify
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number
You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
Syntax using table options at the end.
You can verify your changes by running SHOW
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 12:00 PM
Subject: Re: No more room in index file
So then Ken Menzel says...
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large
Hi Nick,
This is due (so I am told) to a problem in FreeBSD threads. I have
this happen once in a while also. There have been some threads
changes for 4.9 but I am not sure there is any change in this.
The common suggestion is to compile with LINUXTHREADS option using the
ports tree. This
-
From: Jeff McKeon [EMAIL PROTECTED]
To: Ken Menzel [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:54 AM
Subject: RE: Aborted clients
No, no changes to the max_connections. What we did discover is that
although this is a master db and not a slave of any, it was trying
to
replicate
Hi Venelin,
If you have the source code go into the ./Docs directory of the
source tree and read the Makefile on how to build the format you want
(PDF, HTML etc) if that is the machine you built on there may
already be the HTML format document there.
Hope this helps,
Ken
- Original
Hi Jeff,
Just a quick guess did you change the max_connections variable up
from the default of 100? You did not provide a show variables so I
can only guess.
From the [mysqld] section of /etc/my.cnf
set-variable= max_connections=500
Ken
- Original Message -
From: Jeff McKeon
).
Thanks for the very helpful documentation, you guys do a fantastic
job!
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
mailto:[EMAIL PROTECTED]
- Original Message -
From: Luis Enrique Bauzá Peña [EMAIL PROTECTED]
To: Lista Mysql Inglés [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:59 AM
Subject: Help me!!!
Hi, I need some link to a spanish mysql list, would you ...?
--
MySQL General Mailing
Hi Paul, (good to hear from you!)
We use (invoice number+date) number as the primary key for the
header and (invoice number+body item number+date) in the body of the
invoice. We do not allow the same invoice number to be reused on the
same day. However they can eventually rollover (ours is
Hi Maciej,
1) MySQL works very fine for me I have 3 servers with about 150
connections per server. For other success stories see
http://www.mysql.com/press/user_stories/index.html
2) for configuration info see the example configuation files included
with mysql my-huge.cnf and my-large.cnf and
Le reponse de Harald est entirement correct. En plus il existe un
liste en français:
Liens utils :
Poster un message: [EMAIL PROTECTED]
S'abonner: [EMAIL PROTECTED]
Se désabonner : [EMAIL PROTECTED]
Ecrire au proprio : [EMAIL PROTECTED]
URL sur Yahoo :
Bonjour Jérôme,
En premier cette liste est en anglais pourtant j'ai plusieurs
questions de te demander. As tu essayé de compiler MySQL sur HPUX ou
utiliser l'édition precompilé sure le page de télécharger? Je te
conseil de employer la version compiler par le groupe de mysql. En
plus y-a-t'il
Hi William,
Sleeping processes are the result of persisitant connections and
should not slow down your server. As to why you server is so slow
you will have to provide specific examples of what is slow. We reach
speeds of 600 queries per second on slower hardware. Also please
indicated
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
- Original Message -
From: Lenz Grimmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday,
Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 50. You can verify this effect by
BEFORE makeing the
Hi Maximo,
Try this: add this to your HTML document
meta http-equiv=Content-Type content=text/html;
charset=iso-8859-1
Hope it helps
Ken
- Original Message -
From: Maximo Migliari [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 11:19 AM
Subject: Character
Well, just a suggestion, but if you did not install world (where the
threads are) then you have a mismatch between kernel and world.
OT (but what the heck!)
proper procedure for freebsd
cvsup to desired version
cd /usr/src
mergemaster -p
make buildworld
make buildkernel KERNCONF=yourkernel
make
Hi Jeremy,
My only concern with LinuxThreads is building MySQL 4.0 or 4.1 with
them as there is still not a FreeBSD port for MySQL 4 !!! I had alot
of trouble making Linux Threads work initialy. If people want to use
MySQL 4 and want to build from ports (the recommended method) I think
they
Hi Dan,
Thanks for that information, does that mean (for us simple SQL
guys) that even though I am running 5.0RC3 and can compile and install
MySQL just fine (from ports or with my own script) it is using the
threads library from 4-STABLE branch not the new threads?
Also does this have
Hi Maximo,
The problem is that you have a config that requires more memory
than you have available. Please reduce key buffer, record buffer and
sort buffer. The clues are:
030117 17:02:55 Out of memory; Check if mysqld or some other
process uses
key_buffer_size + (record_buffer +
Hi Dave,
Couple of things: Did you see these notes? They apply to BSDi also
http://www.mysql.com/doc/en/FreeBSD.html
Do you have more that 1.2G of free memory? What version of Mysql?
Ken
P.S. my compile script
rm config.cache
CC=gcc CFLAGS=-O3 -DHAVE_BROKEN_REALPATH CXX=gcc \
Well, not the way you seem to be implying. You must use your web
application to create a connection to the other database. You can't
join or union tables, just create the connection and run the query.
Then your app can do what ever it wants with the data.
Ken
- Original Message -
From:
Hi Wash,
Please see ntoes on this page for explanations.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
Next please upgrade to 3.23.54 as this does contain some fixes that
should help including a compile option for broken real path.
Here are my compile flags, I don't recommend -O3
Hi Shawn,
Also under BSDi make sure you are not running out of file
descriptors. MySQL behaves very badly on BSDi when file descriptors
run out!
Ken
- Original Message -
From: shawn xu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 11:12 AM
Subject: MySQL
before yelling for help.
Thanks again,
Ken
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Ken Menzel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 5:17 PM
Subject: Re: mysql source for 4.0.5
In the last episode (Nov 19), Ken Menzel said:
I have tried
Yes, you are correct and it can be worse because you have not
considered that there are some descriptors required by other processes
running. I suggest you increase your file limit to at least 2048.
Good luck
Ken
- Original Message -
From: Lance Lovette [EMAIL PROTECTED]
To: MySQL
this helps, but it is off topic for this list.
Ken
- Original Message -
From: Thomas Seifert [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 20, 2002 9:25 AM
Subject: Re: table_cache too high?
and how on-the-fly?
Thomas
On Wed, 20 Nov 2002 09:18:15 -0500 Ken Menzel
I have tried 4 mirrors in USA to download mysql source for 4.0.5
seems like
the file is missing. Is anyone else having the same problem?
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED
find out what the MAX_ROWS setting on a table is?
SHOW CREATE TABLE tbl_name;
or
SHOW TABLE STATUS LIKE 'tbl_name';
- Original Message -
From: Ken Menzel [EMAIL PROTECTED]
Date: Tuesday, October 22, 2002 4:05 pm
Subject: Re: How to index a large table?
Just curious
Just curious Chris, did you set MAX_ROWS option during table create
to a really large value? If not alter the the table with this and try
again, it affects the size of pointers used to create the index.
(See CREATE TABLE in the manual)
Hope it helps,
Ken
- Original Message -
From:
But did you check if the file size is at 4Gig? This will cause
strange things to happen, mysql does not gice a nice error for this
condition. If the table was not created with MAX_ROWS option = to
some real large number like 5000, then you could be running
into a problem with the size
Hi Cristiana,
I am another FreeBSD user and I can tell you that FreeBSD 4.1.1
does have problems with threads. I would very much recommend that you
update as there are also many security problems with that version if
you are running a server that is remotely available. There were many
Hi Andrew and Richard,
The password and connection info is scrambled up. You can look, If
you want to check it out for your self look in the source code of
./mysql-3.23.XX/libmysql search for the following functions.
especially in 'mysql_real_connect' function. It is not the best
method, but
Does this also apply to non-open-source but free applications? For
example, we give away Escapade for free - always have, always will,
at least for the minimal version of the product. If we develop a
non-free version of Escapade that uses mysqlclient, what happens
then? We also
found it
interesting that the licensing quietly changed and I wondered if
anyone else cared or if this change cleared up some previous confusion
and is a good thing?
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED
Hello,
First shutdown mysql. The move or copy databses to new directory.
Restart server using --datadir=/my/path/for/data or place info in
my.cnf file. (See examples provided with MySQL code).
Ken
- Original Message -
From: Soheil Shaghaghi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi JC,
From http://www.mysql.com/doc/en/Table_size.html (I searched on
size)
If you need bigger tables than 4G (and your operating system supports
this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when
you create your table. See section 6.5.3 CREATE TABLE Syntax. You can
also
Hi Alexander,
I believe that the the 'count()' function works differently under
INNODB type tables. With MyISAM count(*) is stored in a 'table
status' area, but INNODB must scan the tables and count the rows
(very slow). All other types of queries should perform much better
for you, but
Hi John,
Yes, BSDi 4.1 does indeed have serious threading problems. There was a
patch issued that would stop the crashing, but I don't remeber the number.
I am now installing 4.3. If you are running a server that will be available
on the internet I highly advise upgrading to 4.2 or 4.3 with
Hi Andrew,
We have a catalog database with 147 Million records, but size is
only about 8.5G. It is a read only application and is extremely fast
under mysql. Only have about 200 users hitting it, as it is a special
database for a point of sale application.
I think the biggest problem you will
Hi Oleg,
I have similar problems on FreeBSD with one or two slow queries
hogging the CPU. I am running native threads. I am looking at a
parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ
parameter and has to do with polling frequency. The default is 100,
I am experimenting
Hi,
As a first step I would find out what mysql is doing, Use either
'show processlist' or using mysqladmin 'mysqladmin proc'. Or even
better install mytop (cd /usr/ports/databases/mytop; make install; ).
This program sorts the output for you. There does seem to be a
sometimes bug with mysql
Hi Ovanes,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 50. You can verify this effect by
BEFORE
Hi Chris,
Dear Sir/Madam seems a little formal for a public mailing list!
Anyway, we use perl scripts to transfer information from Microsoft
SQL server (which was and is somewhat compatable with SyBASE) use the
freeTDS sybase/mssql drivers to mysql. I modeled the databse with
ErWIN first
1 - 100 of 252 matches
Mail list logo
