mysql.sock

i've fix itthanksi've got another problem... when i rebooted the system...i can't anymore connect to the mysql database ...error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' thanks, rizal Megan Payne wrote: > It is looking for the DBD perl module a

FW: OPTIMIZATION

Please give me advice on optimizing my server: Here are the system specs dual 733 Pentium 512 megs of ram 9 gig scsi -- Here is the options that I use based on the documentation for a moderate # of users: -O max_connections=1000 -O key_buffer=64M -O table_ca

AW: Another signal 11 dump ...

What?? ... no I haven't ... It's slightly a problem doing exact logs ... cause this Database-Server crashes every 2-4 Days ... and does about 600,000 Queries an hour ... I generated a mysqld.sym ... if anybody needs this ... I'll send it ... I think this Mailinglist does not accept this large m

Is this proper

Using Windoze version, latest build. My table has four fields three VCHAR and one BLOB. After inserting into the table two names and two bmp files into the blobs, worked nice thanks to the help I got from here, my table looks like this. It's the crazy - stuff thats throwing me. --

Re: timestamp column

Use one of the other column types, like datetime, instead. - Original Message - From: "MikeBlezien" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 23, 2001 11:37 Subject: timestamp column > Hello All, > > I need to create a database table with a timestamp column data t

Re: timestamp column

"MikeBlezien" <[EMAIL PROTECTED]> wrote: > I need to create a database table with a timestamp column data type, but I don't > what it to change each time the row is updated. How can you prevent the > timestamp column from changing each time it's updated. Use the DATETIME field type instead and se

Re: Another signal 11 dump ...

have you tried trussing the mysqld process and then moving your system time up to the crash point? see what its calling right before it dies? Stephan Skusa wrote: > > Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes > seems not to be the solution for the signal 11 at 0 o'cl

timestamp column

Hello All, I need to create a database table with a timestamp column data type, but I don't what it to change each time the row is updated. How can you prevent the timestamp column from changing each time it's updated. thanks, Mike(mickalo)Blezien Thund

Another signal 11 dump ...

Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes seems not to be the solution for the signal 11 at 0 o'clock ... stated some weeks ago! mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a r

Can't locate DBD/mysql.pm

Everytime i connect to my database using perl i get this error message : install_driver (mysql) failed: Can't locate DBD/mysql.pm in @INC Can anyone help me ? Thanks. rizal -- "If you think your playing too much, play more" -Tilde

Re: Installation Trouble

Firstly, if you have installed RH's mysql RPM , I strongly suggest you remove it, download the latest one from the MySQL web site, both client and server, and install that version instead. BTW you don't need Perl to install mysql. If the mysql's rpms come up with a Perl dependency problem then i

Re: FULLTEXT built for 2 char words OK ?

Yes, It's OK!, you can rebuild mysql to support 2 char FULLTEXT search. You can see a example at www.made-in-china.com, It's built with 3.23.33. ___ Web Development Department Yongzhong Xie <[EMAIL PROTECTED]> http://www.made-in-china.com On Tue, 22 May 2001 15:2

Re[2]: Help! (LONGTEXT)

At 3:35 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >Hello Paul, > >Wednesday, May 23, 2001, 3:24:29 AM, you wrote: > >PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >>>Hello mysql, >>> >>>Can anybody tell me what should I do? I use LONGTEXT column in my >>>table to store data files (

Re[2]: Help! (LONGTEXT)

Hello Paul, Wednesday, May 23, 2001, 3:24:29 AM, you wrote: PD> At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >>Hello mysql, >> >>Can anybody tell me what should I do? I use LONGTEXT column in my >>table to store data files (html, for example). But I see that I cannot simply >>INSERT INT

Re: Help! (LONGTEXT)

At 3:22 AM +0300 5/23/01, Olexandr Vynnychenko wrote: >Hello mysql, > >Can anybody tell me what should I do? I use LONGTEXT column in my >table to store data files (html, for example). But I see that I cannot simply >INSERT INTO table SET longtext_column=whole_file. But I must do it today. But >ho

Help! (LONGTEXT)

Hello mysql, Can anybody tell me what should I do? I use LONGTEXT column in my table to store data files (html, for example). But I see that I cannot simply INSERT INTO table SET longtext_column=whole_file. But I must do it today. But how??? Thanks beforehand. -- Best regards, Olexandr Vynnyc

About MyODBC Some Common Errors

Hi! > "Avukatpro" == Avukatpro Limited Sirketi <[EMAIL PROTECTED]> writes: Avukatpro> In ODBC documents some common error section is says Avukatpro> - If you are connecting to a server with a character set that isn't compiled Avukatpro> into the MySQL client library (the defaults are: Avu

[Fwd: Ramifications of /Lost+Found in DataDir]

database Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the repl

Possible UPDATE bug

>Description: When updating a table after it has been selected with a LEFT JOIN, some UPDATE queries execute normally without actually updating the data, unless the data to be updated is selected normally first. This script is written in mod_perl, using DBI::mysql to connect to the

Re: Can/Does Mysql Broadcast to IPs?

Hmmm...anyone up for a new module? ! Dan Nelson wrote: > In the last episode (May 22), Jacob Martin said: > > Actually what I'm asking is what will happen if 50 users all in the > > same subnet (A.B.C.*) all request the same huge row from the > > database? > > > > Are there any optimizations for

Re: Can/Does Mysql Broadcast to IPs?

Anyone up for a new module? Dan Nelson wrote: > In the last episode (May 22), Jacob Martin said: > > Actually what I'm asking is what will happen if 50 users all in the > > same subnet (A.B.C.*) all request the same huge row from the > > database? > > > > Are there any optimizations for this? >

RE: Porting Access to MySQL

www.accessmysql.com I use it when doing conversions free download too Cost ya 30 dollars US not get annoying messages every 5 or 10 minutes Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Mitchell [mailt

Porting Access to MySQL

Hi, I have a user who want to move there database from Access to MySQL. Are there tools available to make the conversion simple, or what is the best way of going about this? Thanks - Before posting, please check: http://ww

Re: Using identical column names in seperate tables

In the last episode (May 21), Nathanial Hendler said: > >From the MySQL Manual (13.6 Other Optimization Tips) > http://www.mysql.com/doc/T/i/Tips.html > > "Columns with identical information in different tables should be > declared identical and have identical names. Before Version 3.23 you > got

TR : Date format prolem in database

Database,sql,query > -Message d'origine- > De : Nicolas Villatte [mailto:[EMAIL PROTECTED]] > Envoyé : mardi 22 mai 2001 23:18 > À : '[EMAIL PROTECTED]' > Objet : Date format prolem > > > I insert a date like this '2002-10-15' in the DB, everything > is ok when doing a select with DBT

FULLTEXT built for 2 char words OK ?

We need FULLTEXT searching on 2 character length words. If we recompile MySQL to do FULLTEXT indexes on 2 char length words is it going to work OK or will such short words undo the advantages of FULLTEXT ? Also will the data files be useable by other standard MySQL binary builds or will we h

Re: Fulltext and Word Documents ...

On Tue, May 22, 2001 at 10:37:20PM +0100, Nii Larnyoh wrote: > > I have just loaded a MICROSOFT WORD document to be stored in a mySQL > blob column. I will like to know if the blob column that will be > indexed by the FULLTEXT indexer? Given that it's not [just] text, what do you expect to happe

Re: Two connections with C-API

> Is it possible to connect a database two times > simultaneously with the C-API? works... just wrote a bug with a pointer sry for posting Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: mysql.sock file

I faced the same problem and I solved it by creating a link under tmp called mysqld.sock pointing to my mysql.sock let me know if it helped Siomara >From: Dennis <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: mysql.sock file >Date: Tue, 22 May 2001 16:56:19 -0400 > >We have a client pro

Using identical column names in seperate tables

>From the MySQL Manual (13.6 Other Optimization Tips) http://www.mysql.com/doc/T/i/Tips.html "Columns with identical information in different tables should be declared identical and have identical names. Before Version 3.23 you got slow joins otherwise. Try to keep the names simple (use name i

Connect to server problem

Hi I have the Mysql server on W2k and local all is OK, but when I want connect from other computer to Mysql I became error message " General SQL error - alias " my application use Delphi. please help me. TNX Krystian - Before

Two connections with C-API

Is it possible to connect a database two times simultaneously with the C-API? I always get a segfault when connecting a second time. I need this because I want to feed a second table with data processed within a mysql_use_result fetch. I can't use mysql_store_result, because the result set is

Re: configure error: no curses/termcap library found

Just a guess, but you might have to add "--with-ncurses=/usr" so that you provide the basedir for the curses package. Do a ./configure --help and it will list the options. I believe --with-curses or --with-ncurses is one of them. Also, I think there is supposed to be a libncurses.so and libter

RE: mysql.sock file

Dennis, do a find / -name mysql.sock 2>/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check

Installation Trouble

I installed the RPM of 3.23 on RH 7.1 today. Everything seemed to go OK (once I got Perl in the right place), but now I don't have any client tools to access any of the databases or run sql queries. Any suggestions? Sean Tibbetts "Do nothing which is of no use." Miyamoto Musashi Sean

Fulltext and Word Documents ...

I have just loaded a MICROSOFT WORD document to be stored in a mySQL blob column. I will like to know if the blob column that will be indexed by the FULLTEXT indexer? * * Visit http://www.computerstaff.net - Computer Jobs at all

Re: Can/Does Mysql Broadcast to IPs?

In the last episode (May 22), Jacob Martin said: > Actually what I'm asking is what will happen if 50 users all in the > same subnet (A.B.C.*) all request the same huge row from the > database? > > Are there any optimizations for this? Since the transport is TCP, there's nothing Mysql can do abo

configure error: no curses/termcap library found

I am running Redhat Linux 7.0 (kernel version 2.2.17-14) on a Pentium II, and I loaded the source for mysql version 3.23.38. When I run ./configure --prefix=/usr/local/mysql (as it says to do in the documentation), I get the error listed as the subject of this mailing. When doing a search for

mysql.sock file

We have a client program that fails trying to access tmp/mysql.sock on open. It seems that newer servers either dont create the tmp file or store it somewhere else. What can be done to make the existing binary work with both older and newer servers? Is there a my.cnf setting? And also, why has

RE: Fulltext Strange Results...

Do you know roughly when this will be done. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * > -Original Message- > From: Sergei

database shutdown!

Hi, 1. Anyone recommends a particular shutdown procedure for mysql database? 2. The reason: i)I get some weardy errors on NT4.0 workstation like memory referencing while doing the shutdown ii) Some times I get an error while shutting down the mysql server .Once I use "SHOW Databases" after the sh

Replication problem

I am attempting to setup a stand by database using replication. I have a table "abc" on the master server that I wish to replicate to the slave server as "abclive". In other words, I want the updates to be written into a database of a different name on the slave. I thought this would be easy

Re: sql manual

Found this one to be excellent: http://w3.one.net/~jhoffman/sqltut.htm On Tuesday 22 May 2001 08:58, webmaster wrote: > is there any sql manaual over the internet0' no matter that is not a > mysql specificly, I would like to have a good manual for beguiners, > cheers -- Joshua Kugler Associate

RE: count(*) on different tables

I had the same problem to solv before, and this is what I did. PS: I don't know if this is the right way to do it, but it worked for me. mysql> CREATE TABLE Test.myTempTable (myTable VARCHAR(20), nrows AS INTEGER); mysql> INSERT INTO Test.myTempTable SELECT "Table1", COUNT(*) FROM Table1; // 10

Re: Re: Ugly output

The excess space could've come from the very long column name of the first field. Shrink that with an alias: select if(substring) AS shortname, sec_to_time( ) AS session ... Cheers, Kent Hoover filter fodder:database,sql

Re: Re: Ugly output

The excess space could've come from the very long column name of the first field. Shrink that with an alias: select if(substring) AS shortname, sec_to_time( ) AS session ... Cheers, Kent Hoover filter fodder:database,sql --

Query on Merge table

Why did this not work? mysql> select cdate,hour(ctime) as hr, count(distinct sName) from dbpopsj1 where hour(ctime) = 0 group by cdate, hr order by cdate, hr; ERROR 1032: Can't find record in 'dbpopsj1' While this did work! mysql> select cdate,hour(ctime) as hr, count(sName) from dbpops

Re: request

On Tue, May 22, 2001 at 04:21:03PM +0200, Pascal Bruyere wrote: > I'd like to know how many similtanous request support a MySql > database . It depends on the hardware/software involved, but you can pretty easily handle a few thousand on good hardware and a good operating system. Jeremy -- Jer

Disregard Ugly Output

Pardon my idiocy in posting that this command gave ugly output: select if(substring(username,1,8)='cctcpin-', lcase(trim(leading concat(substring_index(username,'-',1), '-') from username)), lcase(username)) as username, sec_to_time(sum(acctsessiontime)) as session from radacct where acctstartti

Re: Sun-Solaris 2.6 binary

On Tue, May 22, 2001 at 02:59:17PM -0400, Eva Hammel wrote: > Hi, > > We are running on a SunOS 5.6 Generic_105181-25 sun4u sparc SUNW,Ultra-5_10 > platform. I noticed that there is not a binary file for 2.6. Is there > anyway way for you guys to generate one for us. If not, I can probably bui

Re: MYSQL performance question

VVM Ravikumar Sarma Chengalvala wrote: > > Joshua, > > > Comparing Oracle vs. MySQL myisam tables, MySQL will > > save disk space, and provide you with much faster > queries, but you have to be aware of the table > locking issues if you are doing > updates/inserts/deletes mixed > with reads. >

Re: Average of all NON-NULL columns in a ROW?

No, I'm looking for the average of all not NULL columns inside a certain _record/row_. There are other columns in the each row. Right now I have to do this: (these are survey questions, which don't necessarily need to be answered) SELECT IF(q1a,@cnt:=1,@cnt:=0), IF(q1b,@cnt:=@cnt+1,0), IF(q1c,@

Sun-Solaris 2.6 binary

Hi, We are running on a SunOS 5.6 Generic_105181-25 sun4u sparc SUNW,Ultra-5_10 platform. I noticed that there is not a binary file for 2.6. Is there anyway way for you guys to generate one for us. We are a company of about 200 (?) developing GSM network software. I'm evaluating MySQL. I use

Re: port default

On Tue, 22 May 2001 11:15:24 -0700 (PDT), sj c <[EMAIL PROTECTED]> wrote: >>Hi, what is the default port to listen to on MySQL? >> I believe it's 3306. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http:/

Problems with sum() in a query.

I'm gaving a problem with adding several sums together when using a group by clause. The table I have looks like this: school_id int school_name varchar sport varchar cost_a float(9,2) cost_b float(9,2) cost_c float(9,2) The real table is normalized,

Re: Problem in creating table structure

On Tue, May 22, 2001 at 10:36:02AM -0700, bineet suri wrote: > hello mysql > > This is bineet from osprey software technology from > india actually i just installed and configure the > MySql database instead of postgres in linux and i have > a script which actaully create the table structure in >

Re: count(*) on different tables

UNION is currently not supported, though one workaround is merge tables, it's not quite the same thing. As to your query SELECT COUNT(*) FROM table1,table2, it is returning the expected result. Without a WHERE clause, you are getting the cartesian product of both tables (all rows from table1 jo

RE: port default

default port is 3306 Chad -Original Message- From: sj c [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 1:15 PM To: [EMAIL PROTECTED] Subject: port default Hi, what is the default port to listen to on MySQL? __ Do You Yahoo!? Yaho

Re: Can/Does Mysql Broadcast to IPs?

On Tue, May 22, 2001 at 12:39:02PM -0400, Jacob Martin wrote: > Greetings: > > Actually what I'm asking is what will happen if 50 users all in the same > subnet (A.B.C.*) all request the same huge row from the database? > > Are there any optimizations for this? Not that I'm aware of. MySQL trea

mysqldump and locking

I have a database-driven web site that uses PHP and MySQL 3.23.38. The database is about 1 gigabyte in size. While performing a mysqldump --opt to back up the database, the web site is completely inaccessible. After doing some investigating, I believe that this is because of the --lock-tables op

port default

Hi, what is the default port to listen to on MySQL? __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please

Re: MYSQL performance question

VVM Ravikumar Sarma Chengalvala wrote: > > >>>MySql documentation says that mysql enforces > table level locking if no explicit locking is there.If > I am using non transaction sensitive tables can I go > ahead without providing any explicit locking?I am > using myISAM. Yes. This is how I u

Re: bug report

That is pretty old. 3.23.38 works fine. Tarog Adrian wrote: > Hello, > I think me and my fellows here at office, found a bug in mysql. > The system is: > RedHat 7.0, kernel 2.2.16, on Celeron 700MHz > mysql version 3.23.22 > Here is the script: > ( > cat < connect test; > create table test (i nu

Re: bug report

Can you try this with a more recent MySQL version? I cannot reproduce it here, on FreeBSD 4.3 running MySQL 3.23.38. G'luck, Peter -- This sentence contains exactly threee erors. On Tue, May 22, 2001 at 08:32:24PM +0300, Tarog Adrian wrote: > > Hello, > I think me and my fellows here at offic

Re: MYSQL performance question

Joshua, > Comparing Oracle vs. MySQL myisam tables, MySQL will > save disk space, and provide you with much faster queries, but you have to be aware of the table locking issues if you are doing updates/inserts/deletes mixed > with reads. >>>MySql documentation says that mysql enforces tabl

Problem in creating table structure

hello mysql This is bineet from osprey software technology from india actually i just installed and configure the MySql database instead of postgres in linux and i have a script which actaully create the table structure in the database it create the sequence and indexes too.In the sequence it act

Re: mysqld got signal 11;

On Monday 21 May 2001 23:29, Steve wrote: > Hi, > > I am running mysql 3.23.33 getting this error about once a day causeing > mysql to restart > > > > > mysqld got signa

RE: JOIN optimization

Hi Bob, Many thanks for your answer, I was afraid that due to the length of the mail, it would scare everybody... >>Battery: >>* batID (primary key) >>* makID >>* descr >> >>Maker: >>* makID (primary key) >>* mak >A battery can have only one manufacturer, so you might as well add >the mak colu

Re: Average of all NON-NULL columns in a ROW?

Ahh.. that, too :) G'luck, Peter -- If I were you, who would be reading this sentence? On Tue, May 22, 2001 at 12:04:34PM -0500, Cal Evans wrote: > Select avg(id1) from where id1 is not null; ? > > - Original Message - > From: "Graeme B. Davis" <[EMAIL PROTECTED]> > To: <[EMAIL PROTE

bug report

Hello, I think me and my fellows here at office, found a bug in mysql. The system is: RedHat 7.0, kernel 2.2.16, on Celeron 700MHz mysql version 3.23.22 Here is the script: ( cat

Re: UNIX_TIMESTAMP converts to CURRENT_DATE on a second call

Shankar Unni wrote: > Sinisa writes: > > >> - timestamp is saved in datetime format >> - first timestamp column is silently updated on each UPDATE > > > What this means, of course, is that when you want to deal with your own > TIMESTAMP data, you need to maintain some sort of sacrificial co

Re: How to retrieve record-id after 'insert into'?

Did you take a look at the LAST_INSERT_ID() function I mentioned? G'luck, Peter -- This sentence no verb. On Tue, May 22, 2001 at 01:53:24PM -0300, Siomara Pantarotto wrote: > In order to retrieve the id you inserted and not someones's id that was > inserted a bit after yours, I guess you sho

Re: Average of all NON-NULL columns in a ROW?

Select avg(id1) from where id1 is not null; ? - Original Message - From: "Graeme B. Davis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 22, 2001 11:29 AM Subject: Average of all NON-NULL columns in a ROW? > Is there a way to get the AVG of all specified NON-NULL colum

sql manual

is there any sql manaual over the internet0' no matter that is not a mysql specificly, I would like to have a good manual for beguiners, cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: How to retrieve record-id after 'insert into'?

In order to retrieve the id you inserted and not someones's id that was inserted a bit after yours, I guess you should lock the table before your insert statement, do the insert, retrieve the id just inserted, and then unlock the table so others can operate with the table again. This is my gue

Ugly output

I'm running the following: select if(substring(username,1,8)='cctcpin-', lcase(trim(leading concat(substring_index(username,'-',1), '-') from username)), lcase(username)), sec_to_time(sum(acctsessiontime)) as session from radacct where acctstarttime between '2001-04-21' and '2001-05-21' and acct

Re: Average of all NON-NULL columns in a ROW?

On Tue, May 22, 2001 at 12:29:35PM -0400, Graeme B. Davis wrote: > Is there a way to get the AVG of all specified NON-NULL columns in one row? > Right now I am doing this in a little script, but it would be nice if I > could do something like this: > > DATA > - > id1044NUL

Can/Does Mysql Broadcast to IPs?

Greetings: Actually what I'm asking is what will happen if 50 users all in the same subnet (A.B.C.*) all request the same huge row from the database? Are there any optimizations for this? Thank you - Before posting, please ch

RE: UNIX_TIMESTAMP converts to CURRENT_DATE on a second call

Sinisa writes: > - timestamp is saved in datetime format > - first timestamp column is silently updated on each UPDATE What this means, of course, is that when you want to deal with your own TIMESTAMP data, you need to maintain some sort of sacrificial column (e.g. "LAST_UPDATED TIMESTAMP") that

Average of all NON-NULL columns in a ROW?

Is there a way to get the AVG of all specified NON-NULL columns in one row? Right now I am doing this in a little script, but it would be nice if I could do something like this: DATA - id1044NULL3NULL I want the average of 0,4,4,3 ie (0+4+4+3)/4 is there a way to

InnoDB tuning tips now in the manual at www.innobase.fi

Hi! I wrote a short new section 9 to the InnoDB manual at http://www.innobase.fi It is a collection of performance tuning tips most of which I have also given on this mailing list. A new section 4.1 talks about MyISAM -> InnoDB table conversion. Regards, Heikki Tuuri Innobase Oy (Mail filter

Installing in Solaris8 problem

Hi all, i have had several problems trying to install mysql on a Ultra60 sparc with Solaris8, i get the following messages running the configure script. I dont have any idea of why is this happenning, probably some related with 64 bits OS or something. Anyone have a clue ??? thanx friend

Re: JOIN optimization

>Hi, > >I'm rather new to SQL (well, I had a one-year course >at the university many years ago, but they didn't >teach us anything practical). I did a few very simple >data bases, but now I'm moving to something more >serious with joins and 'group by'. The idea is to create >a search engine for a

Group By Question

I have a query that is using Group By Title. Is there anyway to make 2 Titles such as "League of their own" and "League of their own###" group as the same. I am removing the #'s in the output but I still get 2 results - 1 for each. Ideas?

Re: Securely access a mysql server over the net

Cyber Monkey wrote: > > I have found an isp that will leave port 3306 open for me to talk to the mysql >server, my question is > > Is anything sent over this connection secure, if not is there some way of encrypting >it such as ssl? Yes.. you ssh like here www.ssh.com www.openssh.org an

OPTIMIZATION

Please give me advice on optimizing my server: Here are the system specs dual 733 Pentium 512 megs of ram 9 gig scsi -- Here is the options that I use based on the documentation for a moderate # of users: -O max_connections=1000 -O key_buffer=64M -O table_cache

Securely access a mysql server over the net

I have found an isp that will leave port 3306 open for me to talk to the mysql server, my question is Is anything sent over this connection secure, if not is there some way of encrypting it such as ssl?

request

I'd like to know how many similtanous request support a MySql database . thanks for answering - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Re: Q: SQL query problems

>Hello, > >I have a problem composing a sql-statement for my special needs. >I hope anybody can help me. > > >This is the situation: > >I have 2 tables, a and b as following: > >-- >| a | >-- >| eid | name | >-- > > >-- >| b

RE: myisampack

No pack is like zipping some thing up. It makes it small but it still needs to be unzipped to retrieve. There is in real life no advantage to disadvatege except size of DB. Hope this help Simon -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: 22 May 2001 12:54

Re: How can be minimized downtime on MyISAM->InnoDB transition?

Thanks for idea again :) HT> Ilya, HT> actually, it may be safest that you use CREATE TABLE to create HT> an identical InnoDB table, and then do HT> INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something HT> AND yourkey < somethingelse

Re: How can be minimized downtime on MyISAM->InnoDB transition?

Ilya, actually, it may be safest that you use CREATE TABLE to create an identical InnoDB table, and then do INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something AND yourkey < somethingelse; In this way you can divide the insertion in

Re:How can be minimized downtime on MyISAM->InnoDB transition?

Ilya, ALTER TABLE should be faster: InnoDB does not have special optimization for separate index creation. Therefore the fastest way is to do the inserts directly to an InnoDB table. You should set the InnoDB buffer pool size big during the transition, to reduce disk i/o. Not bigger than 80 % of

Re: Trouble with Cyrilic

On Tue, May 22, 2001 at 02:41:44PM -0400, Dimiter Atanasov wrote: > Hello, > my name is Dimiter Atanasov. > I'm newbie in mysql servers. I have a strange problem, when i try to select > anythik written on Bulgarian (windows-1251) I recieve a unexpected results, > some letters are unacceptable l

Re: Problems with MySQL and Poweredge 6450..

Cody, did you copy the InnoDB data files, log files, and .frm files verbatim to the new computer? Have you tried wuith the same my.cnf parameters you had in the old computer? Does InnoDB crash always in the same function call? It looks like the internal data dictionary of InnoDB is corrupted. In

myisampack

If I have a lot of rows with text that never changes. Only more rows are added. Should/Can I then use myisampack ? Will it make my FULLTEXT search faster ? Will other database SELECTs become faster ? For now I do not care about disk space. Best regards Jacob --

Trouble with Cyrilic

Hello, my name is Dimiter Atanasov. I'm newbie in mysql servers. I have a strange problem, when i try to select anythik written on Bulgarian (windows-1251) I recieve a unexpected results, some letters are unacceptable lice a (BG) or 'n' and 'm' and the server miss them. Do you have any ideas h

Re: mysqld got signal 11;

Steve writes: > Hi, > > I am running mysql 3.23.33 getting this error about once a day causeing > mysql to restart > > > Thanks and Regards, > > Steve Reed > Network Administrator > Oznetwork Pty. Ltd. > 8233 1900 > 142 Phillip St > Sydney NSW 2000 > Hi! Please can you check whether your h

Re: Q: SQL query problems

Hi! Paul van den Berg wrote: > > > > > This is the situation: > > > > I have 2 tables, a and b as following: > > > > -- > > | a | > > -- > > | eid | name | > > -- > > > > > > -- > > | b| > > -- > > | id |

Re: Q: SQL query problems

> > This is the situation: > > I have 2 tables, a and b as following: > > -- > | a | > -- > | eid | name | > -- > > > -- > | b| > -- > | id | gid | eid | > -- > > *) a.eid and b.id are

  1   2   >