Installing innoDB

I have MySQL 3.23 installed, which comes with RedHat ES3. I find that innoDB is not enabled. Anybody knows can I enable it? Thanks, Joseph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: 64 Bit Support

Thanks David. But I think the Itanium binaries are available only for HP-UX or Linux but not for Windows 2003. -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 12:10 PM To: [EMAIL PROTECTED] Subject: Re: 64 Bit Support The download page @ My

Re: 64 Bit Support

The download page @ MySQL.com (http://dev.mysql.com/downloads/mysql/4.0.html) shows a wack of Itanium binaries, so I would guess it does. David Nawal Lodha wrote: Can someone tell me if MySQL 4.1.3-beta supports 64 Bit Itanium 2 machines with Windows 2003? Thanks, Nawal Lodha. -- MySQL Gener

64 Bit Support

Can someone tell me if MySQL 4.1.3-beta supports 64 Bit Itanium 2 machines with Windows 2003? Thanks, Nawal Lodha.

mysqldump of longblob data type

Evewryone, We are using mysql to store documents. We are using mysqldump to take backups. We have seen restores of that backups results in corruption of document data. Can anyone tell me the reason. We have 3.24 lunning on Linux RH7 Thanks Pankaj Malviya -- MySQL General Mailing List For li

Re: referential integrity for MyIsam

starofframe wrote: Hi All, I've read that MyIsam type table doesnt have the "referential integrity" function... I hav tried to find other 3rd party s/w that can solve the issue. Finally I read from PhpMyAdmin documentation that "recently PhpMyAdmin can check referential Integrity" but I still

referential integrity for MyIsam

Hi All, I've read that MyIsam type table doesnt have the "referential integrity" function... I hav tried to find other 3rd party s/w that can solve the issue. Finally I read from PhpMyAdmin documentation that "recently PhpMyAdmin can check referential Integrity" but I still dont know how to

Re: Training and certification in Kansas City

At 18:19 -0600 7/1/04, Levi Campbell wrote: Where can I get MySQL training and certification in Kansas City? VUE handles MySQL cert testing. If you visit here: http://vue.com/mysql/ Then on the "See where Pearson VUE has test centers that deliver MySQL exams." line, click the "test centers" link a

InnoDB, odd "insert error" shared row locking behavior

Hi again, I ran into some dead locking that was unexpected, & I basically think the "insert error -> share lock" behavior is problematic. I would think that either a insert error does not acquire a row lock ( equivalent of a basic select ), or that it would acquire an exclusive row lock as if the

InnoDB tablespace fragmentation bug in MySQL 4.0.20

Hi, ( hopefully a MySQL developer sees this at some point! ) I am giving InnoDB a good workout before rolling it out onto production systems, and found a bug in the way the tablespace gets fragmented when doing basic add/drop of indexes. Below my sig is a series of SQL commands I used to replicate

Re: Parent-Child Relationship Question

And here's a follow up question... After looking at my database from a fresh perspective, I'm now thinking of combining tables "area" and "family" into a single table. If I do that, it would make life so much simpler if I had TWO name fields, like this: ID | Name | ParentID | Parent Na

slow response time

Hi, I have (what I thought) was a fairly small mysql setup. It's backing a vpopmail installation, and basically just handling alot of SELECTs. In the process of delivering mail, the db gets hit a few times: -initial check that the user exists during smtp conversation -lookup for homedir during

MyISAM and InnoDB table design

Hi, I read it somewhere that InnoDB is faster for table with high read/write concurrency. I have a table look like this: CREATE TABLE diary ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, body TEXT NOT NULL, date DATE NOT NULL,

All lists off topic... Job Networking Request

To any Moderators: This is the only time I will send this message. Dear List Members, I am seeking a co-op/paid internship in a Computer Science related field. If you or someone you know, directly or indirectly, works for a company that deals with Computer Science, i.e. Computer Programming, ple

Parent-Child Relationship Question

I created a database focusing on the world's nations, states, etc. that uses a "parent-child" relationship, as defined in a table named "family." I'm now trying to figure out how to query the parent, and it occurred to me that my tables might not be set up correctly. If anyone is willing to glance

Merging of 2 selects

I am not entirely sure what I am after is possible, if someone could help me I sure would appreciate it. Mysql 4.0.18-standard I have 2 basic selects I am doing: SELECT id, image_title, 'images' FROM newsletter_images SELECT id, link_title, 'links' FROM newsletter_links In the end, I get 2 sepa

Re: Merging of 2 selects

on 07/01/2004 05:43 PM, Scott Haneda at [EMAIL PROTECTED] wrote: > I am not entirely sure what I am after is possible, if someone could help me > I sure would appreciate it. Mysql 4.0.18-standard > > I have 2 basic selects I am doing: > SELECT id, image_title, 'images' > FROM newsletter_images >

Training and certification in Kansas City

Where can I get MySQL training and certification in Kansas City? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Auto Date selection and format

Michael/Wesley, Thanks for your help. You got me going in the right direction! Thanks again!!! Mike -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:37 PM To: Mike Koponick Cc: [EMAIL PROTECTED] Subject: Re: Auto Date selection and fo

Re: how to insert blob data remotely.. SOLVED :)

Hi Again.. Fortunately I found a way to do this using C++/Qt. Here's the code for who are interested in: QFile *myFile; QSqlQuery query; QString strQuery; QByteArray myByteArray; // open the image and fill the bytearray myFile = new QFile("/root/hm/variostepsa/fotos_marcopolo/paradi

RE: how to insert blob data remotely

Is using a programming language such as Java, PHP or VB an option? -Original Message- From: HÃctor Maldonado To: [EMAIL PROTECTED]; Omar De la Cruz Sent: 7/1/04 10:06 AM Subject: how to insert blob data remotely Hi all!.. How can I insert blob data (specifically a jpg image) into a blob

Re: how to insert blob data remotely

On Thu, 2004-07-01 at 11:06, Héctor Maldonado wrote: > But LOAD_FILE only works if 'picture.jpg' is placed on the same machine > where the server is running. > That makes sense. You could of course NFS mount from the remote machine to the machine you are working from but that is much the same th

how to insert blob data remotely

Hi all!.. How can I insert blob data (specifically a jpg image) into a blob field remotely?.. I mean, the client has to choose a jpg image in his/her PC and upload it to the server. I found this piece of code: INSERT INTO car_models (Brand, Picture) VALUES ('Subaru Impreza', LO

Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote: I re-installed it this time by rpm / Same version but by rpm. / I noticed that my databases are not there anymore when I do a > 'show databases'. I just need to get Bugzilla to run the checksetup.pl script and it will go and create what it needs. but the

RE: bugzilla not working now after MySQL re-installed

The 'mysql.sock' file is at /var/lib/mysql/mysql.sock with a size of 0 Does this look right? [EMAIL PROTECTED] mysql]# pwd /var/lib/mysql [EMAIL PROTECTED] mysql]# ls -l mysql.sock srwxrwxrwx1 mysqlmysql 0 Jul 1 11:41 mysql.sock -Original Message- From: Yiannis Mavro

RE: bugzilla not working now after MySQL re-installed

I re-installed it this time by rpm because when I tried to recompile it with '--with-mqsql' this DRES and some other errors for Keystone tools keeps telling me that MySQL needs to be recompiled with '--with-mqsql'. This time with the re-installed - I used rpm. Same version but by rpm. I notice

Re: Finding Tables created by views

In the last episode (Jul 01), Martin Gainty said: > I have a table that is chock full of errors..(PLAN shows Table Access > full) so I know that it was created wrong Is there an easy way to > setup a query to locate all views that use this table? Mysql doesn't support views yet. It's planned for

Finding Tables created by views

Folks- I have a table that is chock full of errors..(PLAN shows Table Access full) so I know that it was created wrong Is there an easy way to setup a query to locate all views that use this table? Thanks, Martin Gainty (cell) 617-852-7822 From: Bill MacAllister <[EMAIL PROTECTED]> To: Paul DuB

Re: Replication problem on 3.23.57 & 3.23.58

> somebody here can make sense of it. On the slave I get error messages > like: > > 040630 2:43:52 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.163' at > position 37919441 > > It does that several times between 2:20am and 4:30am. and every few

[Stats] MySQL List: June 2004

-- Searchable archives for this list are available at -- ==

Re: Mac OSX Tiger and 64 Bit

On Tue, Jun 29, 2004 at 10:57:41PM -0700, Bruce Dembecki wrote: > So I have a question for those who understand developer speak and MySQL > builds and so on... > > Apple announced their new OS earlier this week, including this information > on the improvements to 64 Bit version using the G5 proces

Re: Replication Performance

On Thu, Jul 01, 2004 at 11:34:29AM +0800, MaFai wrote: > Dear, [EMAIL PROTECTED], > > We have set up 1 master and 4 slave as replication. > Sometime,the slave need 4~10 minutes to synchronize the data with master > database. > Do any way to tune the performance? > Or any other way

RE: Production release of MySql 4.1

At 14:09 -0700 6/30/04, Jon Frisby wrote: As I understand it, the particular cycle a release is in depends on how long it's been since a major bug was reported. So an alpha becomes a beta if nobody reports a major bug after N days, and a beta becomes a production release if goes N days without a m

RE: authentication error

I don't know how to look at the explain plan for that query..or how to find out what query is being run. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:29 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentic

Re: Select help

On Thu, 2004-07-01 at 10:03, rmck wrote: > Hi, > > I have a table with ip,port and I want to see the top ten Ip's with the most > entries? > Ip's can be in db many times... > > Not the first distinct 10... Im stuck... > > I have tried: > mysql> select DISTINCT ip from iptable limit 10;

RE: authentication error

Those values are good. What query is being run when the users are authenticating? Have you looked at the explain plan for that query? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:22 PM Subject: RE: authentication error Key_Reads 57 Key_read_r

RE: authentication error

Key_Reads 57 Key_read_request 16218 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:17 PM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication error What is the value of key_reads/key_read_request? -Or

RE: authentication error

What is the value of key_reads/key_read_request? -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 12:11 PM Subject: RE: authentication error I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128

RE: Select help

Woops! Forget I said that, you wanted to order by the most occurrences. Sorry. SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY 2 DESC limit 10; Heh... I should learn to read one of these days... -Matt -Original Message- From: rmck [mailto:[EMAIL PROTECTED] Sent: Thursday, July

Re: Select help

select count(*) as cnt group by ip order by cnt desc limit 10; rmck wrote: Hi, I have a table with ip,port and I want to see the top ten Ip's with the most entries? Ip's can be in db many times... Not the first distinct 10... Im stuck... I have tried: mysql> select DISTINCT ip from iptable limit

RE: authentication error

I had my admin turn it down from 256M to 50M and it started just dogging at 40 connections. We're now at 128M and checking. How do I set the key_buffer appropriately? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:51 AM To: Chip Be

RE: Select help

Hey Rob, You're looking for a group by to allow mysql to aggregate over the IP's: SELECT ip, count(*) FROM iptable GROUP BY ip ORDER BY ip DESC limit 10; -Matt -Original Message- From: rmck [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:03 PM To: [EMAIL PROTECTED] Subject: S

Select help

Hi, I have a table with ip,port and I want to see the top ten Ip's with the most entries? Ip's can be in db many times... Not the first distinct 10... Im stuck... I have tried: mysql> select DISTINCT ip from iptable limit 10;

Replication problem on 3.23.57 & 3.23.58

We have suddenly run into a replication problem between our master and our slave databases. It had been running without a problem for atleast several months since our last upgrade, and for several years before that. I've tried a number of debugging techniques, and now I'm hoping somebody

Re: mysqld_safe in 4.1.2

--On Wednesday, June 30, 2004 07:36:23 PM -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: At 13:58 -0700 6/30/04, Bill MacAllister wrote: Hello, I am a bit confused by processing of user= specifications in the mysqld_safe script. Here is what I see: * If user= is specificed in the [mysqld] or [ser

Re: System.Data.MySql

Yes. The ByteFX provider has been aquired by MySql and will be released shortly as the supported provider. It will not have the namespace System.Data.MySql since System.* is reserved for bits of the framework shipped as native parts of the framework. The namespace will by MySql.Data.MySqlCl

RE: bugzilla not working now after MySQL re-installed

The original error might be slightly more cryptic than it intends. It is saying that it cannot connect to your db through /tmp/mysql.sock. Check if your mySQL installation has installed the socket file in another place. If it has, a quick and dirty fix is to soft link the socket file wherever it

RE: bugzilla not working now after MySQL re-installed

I am able to logon with user 'bugs' and passwd 'marvin' as below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear

Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote: yes.. below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard Uh, OK. You said MySQL was "re-installed" -- why? Was it the sam

Managing table quota

Hi Is it possible to change the table memory usage quota through mysql 4.X scripts as we do in Oracle. We are migrating our application from Oracle 9i to MySQL does any body have experience in this area and are there some common problems faced during this procedure. Any information will be h

RE: bugzilla not working now after MySQL re-installed

yes.. below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> -Original Message- Fr

Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote: I tried this and get a 0 affect below.. mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON bugs.* TO [EMAIL PROTECTED] IDENTIFIED BY 'marvin'; Query OK, 0 rows affected (0.00 sec) OK, I assume 'bugs' and 'marvin' are the values i

RE: bugzilla not working now after MySQL re-installed

I am able to log into mysql as this: [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> I trie

Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote: MySQL is running.. OK, that's /half/ the question :-) Have you *tried* accessing it from the command-line client, using the username/password set in your "localconfig"? Does the username and password in localconfig get you into the DB using the MySQL client?

RE: odd problem

Your cardinality is null. Analyze the table and then do a show index. -Original Message- From: J S To: [EMAIL PROTECTED] Sent: 7/1/04 10:22 AM Subject: odd problem Hi, The code in my function below (insert_internet_usage) has suddenly dramatically slowed down and I don't understand why.

odd problem

Hi, The code in my function below (insert_internet_usage) has suddenly dramatically slowed down and I don't understand why. The logs I'm parsing are the same size as before, but what used to take 15 minutes has shot up to about 4 hours. It's almost as if the indexes had stopped working. I wonder

Re: Using Access as client all fields are marked "#Deleted"

I've seen this before and do not exactly remember why, think it had something to do with relationships and links, try removing all relationships and see if that helps, if not try deleting tables and relinking them from scratch (found the link manager doesn't always fix problems for some reason)

RE: authentication error

Can you tweak your key_buffer and see what results you get? -Original Message- From: Chip Bell To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 9:38 AM Subject: RE: authentication error My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 con

MySQL 4.1.3-beta has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.1.3, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ a

Re: System.Data.MySql

So far the one I have had the best luck with is ByteFX.Data.MySqlClient I use it in both VB.Net and C# against MySql 4.1.2 on Windows and Linux. It's here: http://www.bytefx.com Larry Lowry - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July

RE: bugzilla not working now after MySQL re-installed

MySQL is running.. [EMAIL PROTECTED] /]# ps -ef | grep mysql root 1338 1 0 10:51 pts/200:00:00 /bin/sh /usr/bin/mysqld_safe --d mysql 1362 1338 0 10:51 pts/200:00:00 /usr/sbin/mysqld --basedir=/ --d root 1374 1124 0 10:51 pts/200:00:00 grep mysql -Original

RE: authentication error

My bad, just realized that read_buffer_size USED to be record_buffer My total @ 100 connections is 2356M. I'm going to guess that I should shave that down a bit?? -Original Message- From: Chip Bell Sent: Thursday, July 01, 2004 10:17 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: R

Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote: Your thoughts on this would be appreciated. MySQL was re-installed ,,, Can't connect to the mysql database. Is the database installed and up and running? Do you have the correct username and password selected in localconfig? What else do you need besides

System.Data.MySql

Hello! Is there an implementation os System.Data.MySQL for the .net-framework? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bugzilla not working now after MySQL re-installed

Your thoughts on this would be appreciated. MySQL was re-installed and now Bugzilla is not working now I am getting this error when I bring up - http://localhost/bugzilla/ * Software error: Bugzilla is currently broken. Please try again later. If the problem p

RE: authentication error

Ok, I have no "read_buffer" anywhere... 256M (key) + 20 (sort) * 100 (connections) Correct? -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:09 AM To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] ' Subject: RE: authentication er

Re: MySQL and VBquestion - problem with query that returns 100000+ records

Shawn I took your advice and let the app run for a good 12+ minutes - miraculously it worked and the resulting report did show up.I am now convinced that the status shown in the task manager is misleading. I am trying to implement your suggestion of using an asynchronous call. So I am doing som

RE: authentication error

Do the math and see what your memory usage is with 100 simultaneous connections. If I recal you said you had three gigs of ram. -Original Message- From: Chip Bell To: Victor Pendleton; [EMAIL PROTECTED] Sent: 7/1/04 5:27 AM Subject: RE: authentication error Nope, nothing out of the ordin

RE: Replication Performance

What does the network setup look like? What type of data is being replicated varchar, text, blob? Is the network connection being dropped or are there any errors being logged anywhere? -Original Message- From: MaFai To: [EMAIL PROTECTED] Sent: 6/30/04 10:34 PM Subject: Replication Perfor

Re: Access denied for user: 'root@localhost' (Using password: NO)

On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote: > shouldn't I be able to issue commands at the shell it goes and does it > thing and give back output? or does this mean I have a passwd already set > and it's secured? > http://dev.mysql.com/doc/mysql/en/User_Account_Mana

RE: Access denied for user: 'root@localhost' (Using password: NO)

shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 8:57 AM To: Nguyen, Long P (M

Re: Access denied for user: 'root@localhost' (Using password: NO)

Re-installing does not get rid of your old passwords. You need to use the -p option. Nguyen, Long P (Mission Systems) wrote: Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would ge

Access denied for user: 'root@localhost' (Using password: NO)

Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'. Could someone please tell me what

Crash with join query in 4.1.1

Is this bug a known one? I can reliably crash 4.1.1 with this query every time right now, which is a bit of a bummer. From the error log: Some pointers may be invalid and cause the dump to abort... thd->query at 0x86644a0 = SELECT profileid, profile_name, domain_name, domainid FROM profiles, do

select query that uses a temporary table

Hi All, There's something that bothers me.. I have a query that uses a temporary table (has a necessary GROUP BY clause). The query also uses ORDER BY clause (necessary too). And I also use LIMIT clause. If the query finds 10,000 rows, then MySQL will insert 10,000 rows into the temporary table an

RE: select, = and like

Hi Karsten, I'm quite sure you have special characters in the end of the field T_Instance for T_Instance like "VA_SD_STOPFENFUEHRUNG". Can you display the contents of this field in hex format? Regards, Laercio. -Original Message- From: Karsten Backhaus [mailto:[EMAIL PROTECTED] Sent: q

RE: authentication error

The email users authenticate against a MySQL table... -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 6:12 AM To: [EMAIL PROTECTED] Subject: Re: authentication error "Chip Bell" <[EMAIL PROTECTED]> wrote: > Hello, I run a toaster email serve

Re: Index problem

"Oropeza Querejeta, Alejandro" <[EMAIL PROTECTED]> wrote: > Hi, i'm trying to create an index on a table with 199 million records. > The problem is that is taking too long (8 hours and is not yet > finnished). > does anyone have any idea? Wait until it finishes.:) We have tables where index cre

Re: Mysql growing pains, 4 days to create index on one table!

Are you running this under Microsoft Windows? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL

Re: MySQL Security

Sheraz <[EMAIL PROTECTED]> wrote: > How can i achieve Security acpect in mysql? > How secure can we make transactions over internet for > 3306 ? Use SSL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita

Re: authentication error

"Chip Bell" <[EMAIL PROTECTED]> wrote: > Hello, I run a toaster email server which is having trouble > authenticating at times. Both methods of authentication, imap AND web > for some reason just hang. I'm pretty new to MySql but I figure if both > methods are trying to authenticate against the

Re: php-mysql RPM

[EMAIL PROTECTED] wrote: > I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a > dependency libmysqlclient.so.10. My mysql server version is 4.0.20. > > Can anyone tell me where I can get libmysqlclient.so.10. Download MySQL RPMs from http://dev.mysql.com/ The package co

RE: authentication error

Nope, nothing out of the ordinary. I tested this about 5 times last night and EVERY time the "show processlist" was 100 or above, it hung. The ONLY variable I can find with a setting of "100" is that "delayed_insert_limit". Obviously I was thinking of just changing that and watching, but you guy

Re: C API -- huge result sets slowin me down

"Matt Eaton" <[EMAIL PROTECTED]> wrote: Try to profile application from that point ... >if (mysql_real_query(&dbase,sqlBuff,strlen(sqlBuff))) { >printf("Pool Attributes Select Failed... dumbass\n"); >fprintf(stderr, "Error: %s\n", >

Re: defaults for net_read_timeout and net_write_timeout?

Marten Lehmann <[EMAIL PROTECTED]> wrote: > what are the defaults for the following options? > > net_read_timeout 30 seconds. > net_write_timeout 60 seconds. See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html for details. -- For technical support contracts, goto https

utf8_polish_ci

Hello, I'm using MySQL 4.1.2 and it should be available utf8_polish_ci collation. But, it seems that it is not. # Query: # SHOW COLLATION LIKE 'utf%' # 'Collation''Charset','Id','Default','Compiled','Sortlen' 'utf8_general_ci','utf8','33','Yes','Yes','1' 'utf8_bin','utf8','83','','Yes','1' The sa

Re: time on tenth of secounds

"Matthias Eireiner" <[EMAIL PROTECTED]> wrote: > problem is, that I want to save the time with the fraction of seconds. > as far as I know MySQL is fine with something like "D HH:MM:SS.fraction", > but doesn't store the fraction. Is there anything that could fix that > problem? > I thought about a

Re: mysql client connectivity and "orphaned" connections

Jim <[EMAIL PROTECTED]> wrote: > I'm just wondering if anyone can tell me exactly what happens when one > is using the mysql client on a remote server and the connection to that > server (in this case over ssh) gets dropped. if your ssh session suddenly closes, the only thing that happens is th

Re: Server Startup

"David Scott" <[EMAIL PROTECTED]> wrote: > Then get a copy of mySQL CC > http://dev.mysql.com/downloads/mysqlcc.html Also take a look at MySQL Administrator http://dev.mysql.com/downloads/administrator/index.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita T

select, = and like

Hi, im running mysql-4.0.18-2, all tables are innodb tables. I found the following which i dont understand: one of my tables is named 'PARAMSET_EXT': mysql> explain PARAMSET_EXT; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra

Re: Using REGEXP

On 30 Jun 2004 17:45:06 +0200, wrote: >In article <[EMAIL PROTECTED]>, >SGreen writes: > >> SELECT t1.* >> FROM ytbl_development t1 >> INNER JOIN tmpShortCodes sc >> ON INSTR(t1.txtDevPostCode, sc.short_code) =1 > >This is the same as > > SELECT t1.* > FROM ytbl_development t1 > INNER JOIN tmp