Mysql 4.0.13 with Linuxthreads problem in FreeBSD 5.1-beta - SOLVED!

Hi, I had a problem running MySQL-4.0.13 with Linuxthreads in FreeBSD 5.0. Before I compiled mysql-4.0.13 with WITH_CHARSET=win1251 WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes options. It was compiled and installed properly. However when I try to connect to mysql server it says:

web app ideas

Hello all, This is my first post here so I'll make it worth it. I'm a programming student and am wanting to make a simple PHP and MySQL web based address book simply for a resume topic. It's going to be just simple enough to add contacs, remove them, and look them up. I'm curious as to exactly

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ?

RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)

Is your server daemon running? -Original Message- From: Pratchaya Chatuphian [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:25 AM To: [EMAIL PROTECTED] Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR 2002: Can't

RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)

You should be able to find a file in your data directory titled hostname.err. What is the content of that file? If the server is having problems running, you'll more than likely find information in that .err file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED]

Re: Mysql 4.0.13 with Linuxthreads problem in FreeBSD 5.1-beta - SOLVED!

On Mon, Jun 09, 2003 at 04:14:05PM +0900, Ganbold wrote: Hi, I had a problem running MySQL-4.0.13 with Linuxthreads in FreeBSD 5.0. Before I compiled mysql-4.0.13 with WITH_CHARSET=win1251 WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes options. It was compiled and installed

Re: index failure, cannot generate.

I'm guessing blob data? ~1500MB / 400rows = ~3.75MB /row Perfect guess. Two columns: Filename (char len 20) and Text ~ 3.75MB/row. -- Herbert Michael Kunzmann Binary Chaos Magician signature.asc Description: This is a digitally signed message part

is it possible to get around 4 billion row limit

Hi, I want to create a table with a lot (8 billion) small fixed-length records. I thought setting MAX_ROWS in the create table would do this for me, but it looks like it quietly ignores values over 4.2 billion. Is this a hard-limit in MySQL ? Does MySQL 4.0.x have the same limitation ?

Re: detailed FULLTEXT index and search help needed

Hi Herbert, I was reading both your threats once more carefully (the original post and the repost). 1) I assume you are using the MyISAM table format. You wrote that you have 400 text documents with each ~3.75 MB size. 2) How is the data access trend to such documents ? Do you update them all

Delphi 7 and MySQL 4.1.0 alpha

Hello, I'm trying to get connection on MySQL 4.1.0 alpha edition by using the SQLCOnnection (dbExpress) object. I am having the error 'Unable to load libmysql.dll'. I placed this file into the winnt\system32 folder... still didn't work. I put the whole path into the VendorLib... still didn't

How to empty the cache?

Hi. I'm doing some testings and I want to know how to empty the cache in mysql (versions 3.23 and 4.0) between the differents tests. Iago Sineiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to empty the cache?

On Mon, Jun 09, 2003 at 12:30:23PM +0200, Iago Sineiro wrote: Hi. I'm doing some testings and I want to know how to empty the cache in mysql (versions 3.23 and 4.0) between the differents tests. What cache? The query only exists in MySQL 4.0. If you want an empty key buffer, I'd suggest

Re: Delphi 7 and MySQL 4.1.0 alpha

Did you try to put this dll into your application directory? The common way to use this dll is to hold it together with executable. [EMAIL PROTECTED] wrote: Hello, I'm trying to get connection on MySQL 4.1.0 alpha edition by using the SQLCOnnection (dbExpress) object. I am having the error

Re: How to empty the cache?

Hi Iago, I am unsure if I understand your question correctly, MySQL has a t least 5 different chaches (to name only the most important ones). key_cache table_cache thread_cache hostname_cache evt. disc cache (memory) or do you mean buffer variables ? sort_buffer record_buffer

problem with DBI connection interaction with sub-process

Hi, Maybe this is a DBI question rather than MySQL, but here goes... I have a perl script which forks in order to work around a memory leak in XML::Parser. The child parses the data and the parent reads the results back from the child to populate some temporary tables in the database. What

Re: Can't send Register ID

Thank you so much ;-) - Original Message - From: Fred van Engen [EMAIL PROTECTED] To: Robson Oliveira [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 08, 2003 2:30 PM Subject: Re: Can't send Register ID Hi, On Sun, Jun 08, 2003 at 01:53:24PM -0300, Robson Oliveira wrote: I'm

Do all mysql versions from 4.1 support sub selects?

Hi Mysql List, Will all mysql versions (std, max and debug) from 4.1 support sub selects or will this only be included f.e in the max version ? Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For

Problems with odbc

Hi all... I have a problem connecting an ODBC to my mysql database I give my Ip username and password but it returns me the address... Access deny . I ma sure that username and password are correct.. Someone can give me suggests please? [EMAIL PROTECTED] http://www.motormaniaci.com il

RE: problem with DBI connection interaction with sub-process

You could try forking before making a connection to the database. A forked program will share the same resources (I think), and the DBI could be getting the child signal and closing connection. However, any resources you create after the fork will be your own. Hope it helps (bit of a guess

Certification study quide from Dubois, Hinz and Pedersen

Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, hello Mysql List, I was wondering if you guys would let me know about the release schedule of the MySQL Certification Study Guide which is about to be released - as announced on the UC 2 months ago. Any information much appreciated - no info

RE: problem with DBI connection interaction with sub-process

Hi Robin, This sounds bang-on. Many thanks. regards, Martin On Mon, 2003-06-09 at 13:34, Robin Keech wrote: You could try forking before making a connection to the database. A forked program will share the same resources (I think), and the DBI could be getting the child signal and

Re: Problems with odbc

If you are using Windows 9x or any Microsoft Operating System ... please check if you have setup the User DSN (Control Panel - ODBC Data Source Administrator )correctly.. If you do, I think it will work fine. - Original Message - From: Sbandy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: Problems with odbc

I solve my problem due to a missconfiguration of my server on table grant. Thanks a lot to all and sorry for the disturb At 19.48 09/06/2003 +0700, Edwin Tanaga wrote: If you are using Windows 9x or any Microsoft Operating System ... please check if you have setup the User DSN (Control Panel -

Re: How to get meta data info in MySQL

My database editor uses: describe name; Karen Chu wrote: I want to be able to get all table names in a database and all the column names and associated data type from a particular table. I wonder how to do that in MySQl. I understand I can use show tables to see the table info, but I want to be

Re: Linux install problem

Steve Mansfield wrote: Having run MySQL successfully for a while in a WAMP environment, I'm trying to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1 version that came as an RPM with SuSE 8.2. The problem is - it doesn't work. Here's where the various elements have

Help! How to generate a list of consecutive numbers with a SELECT?

I've tried to find a way to generate a list of consecutive numbers with a SELECT statement. I would like something like Select ... that would result the numbers between 1 and 20 on separate rows. So far, the only solution I have found is to have a table with consecutive numbers from 1 to 1000,

Re: How to get meta data info in MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karen Chu wrote: Thanks for the reply! Yes, I understand I can do show tables to show all table names in a database and I can do describe table_name to get all column information for a table. But in the application programming, I want to be able

Re: MYSQL privileges System

At 12:24 -0700 6/8/03, Mike Walth wrote: Hello: I was wondering if anyone had any advice to a couple questions. 1) Can I add additional columns to the user and db tables of mysql. These would be for administrative purposes only. You can, but doing so is unsupported, and the server won't do

RE: How to empty the cache?

Sorry for the ambiguity. I'm testing the useful of adding indexes to one table for one type of query. When I execute the same query for the second time it executes faster beacuse it's using the cache (the key_cache or the query cache if it is enabled). Is it possible to empty the key_cache

Re: need help

i'm not an expert by any means :) but, you do need indexes on both the primary key and the foreign key. you've got one on foo_id, but you also need on on foo_value. check the lists for more information. there's been plenty of discussion lately ... good luck Sibananda Sahoo wrote: Dear Sir

RE: Batch Deletes...

You may find that it is the index that is slowing you down. Have you tried disabling the index(s) on your table before the delete and re-enabling them after? Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Todd Gruben [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003

Re: How to empty the cache?

In the last episode (Jun 09), Iago Sineiro said: Sorry for the ambiguity. I'm testing the useful of adding indexes to one table for one type of query. When I execute the same query for the second time it executes faster beacuse it's using the cache (the key_cache or the query cache if it is

RE: How to get meta data info in MySQL

I wish to have something like 'select name from all_tables' in oracle or 'select name from sysobjects' in Sybase. Oracle has 'show tables' or 'describe table' too, but actual meta data is *stored* in systems tables. I wonder if MySQL also stores these in system tables or files or somewhere else.

Re: How to get meta data info in MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karen Chu wrote: I wish to have something like 'select name from all_tables' in oracle or 'select name from sysobjects' in Sybase. Oracle has 'show tables' or 'describe table' too, but actual meta data is *stored* in systems tables. I wonder if

RE: How to empty the cache?

Thanks. I will try it. Iago Sineiro. -Mensaje original- De: Dan Nelson [mailto:[EMAIL PROTECTED] Enviado el: lunes, 09 de junio de 2003 16:54 Para: Iago Sineiro CC: MySql Mail List Asunto: Re: How to empty the cache? In the last episode (Jun 09), Iago Sineiro said: Sorry for the

Re: My SQL ERROR 2002

skjois [EMAIL PROTECTED] wrote: I get this error ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) how can i get rid of this? Easily. Start MySQL and get rid of the message. :-) -- For technical support contracts, goto

Re: Help! How to generate a list of consecutive numbers with a SELECT?

Martin Szabo [EMAIL PROTECTED] wrote: I've tried to find a way to generate a list of consecutive numbers with a SELECT statement. I would like something like Select ... that would result the numbers between 1 and 20 on separate rows. So far, the only solution I have found is to have a

Re: Do all mysql versions from 4.1 support sub selects?

Nils Valentin [EMAIL PROTECTED] wrote: Will all mysql versions (std, max and debug) from 4.1 support sub selects or will this only be included f.e in the max version ? In all. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: Loading database information from a text file.

from a command prompt mysqldump -opt database dumpfile Curtis On Sunday 08 June 2003 02:59, JeRRy wrote: Okay thanks. One last thing. From the mysql prompt how can I generate a database backup? (So I can see the database setup in notepad so I can backup and transfer easily online.)

RE: array/pointer question

Hi, MySQL, like other relational databases, does not support arrays or pointers. Arrays and pointers do not fit within the relational model. It would take quite a bit of text to describe what the relational model is and how to use SQL to manipulate data. I suggest that you read a good text on

Re: Batch Deletes...

At 9:01 -0500 6/9/03, Todd Gruben wrote: In an effort to speed up large batch deletes i devised this script. LOCK TABLES t1 WRITE; SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date=2003-06-09; TRUNCATE TABLE t1; LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1; UNLOCK TABLES; this script

Re: Certification study quide from Dubois, Hinz and Pedersen

offlist Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a german version ? If yes , when ? I am not asking to pin you down really I am asking so that I

Re: array/pointer question

Arrays are coming from version 5.0 as far as I know the plans. Best regards Nils Valentin 2003 6 9 23:49Ioana : Hello, I have just recently started learning mysql, and was wondering if it supports arrays/pointers(for linked lists) of any types, and if so, what is the syntax... could not

Re: Batch Deletes...

At 11:01 -0500 6/9/03, Todd Gruben wrote: in the TRUNCATE TABLE t1 This is the documented behavior: http://www.mysql.com/doc/en/TRUNCATE.html You cannot use TRUNCATE on tables for which you hold locks. On Monday 09 June 2003 10:57 am, you wrote: At 9:01 -0500 6/9/03, Todd Gruben wrote: In an

Re: Certification study quide from Dubois, Hinz and Pedersen

Hi Paul, 2003 6 10 01:26Paul DuBois : At 1:08 +0900 6/10/03, Nils Valentin wrote: offlist Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a

RE: How to get meta data info in MySQL

Thanks for the reply! Please see my pseudo code below. @@@ mark is the place where my questions come from. I wonder if it is doable in MySQL. I wish to have code like this: (@@@ is where my questions come from) // connect to the DB // list all table names in the dtabase print trtd

Fw: 2 questions about indexing and testing speed

Hi, I'm learning MySQL and I got two question: 1) As I know, MySQL has a buffer to keep the last records which have been retreived. So if I run a query two times, the second time will be faster. How can I temporarly stop this service? because I want to run different queries and compare their

Re: How to get meta data info in MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karen Chu wrote: Thanks for the reply! Please see my pseudo code below. @@@ mark is the place where my questions come from. I wonder if it is doable in MySQL. I wish to have code like this: (@@@ is where my questions come from) // connect to

RE: How to get meta data info in MySQL

At 10:11 -0700 6/9/03, Karen Chu wrote: Thanks for the reply! Please see my pseudo code below. @@@ mark is the place where my questions come from. I wonder if it is doable in MySQL. I'm not sure why you wonder that. You've received several replies so far that indicate you cannot use SELECT for

arrangement of fields in a table

Hi, I need to define for example 100 fields in a table. 8 of them are more important and many queries just need these fields. Should I define them before the other fields in the table or it doesn't matter? Is accessing the the beginning fields faster than the other fields? thanks -- MySQL

ADD CONSTRAINT on InnoDB tables

Hi all, I've just installed mysql 4.0.1 on my pc and I'm trying to migrate a set of old MyISAM table to InnoDB type table, to introduce referential integrity on my data. I found this problem. I create an index for each key in the references and the sql command ALTER TABLE utenti ADD

subselects in 4.1 and indexes

Im have a problem / misunderstanding with the 4.1 release. Im having issues with indexes related to 'IN' vs '=' in subselects. assume the subselect returns 1 value select SQL_NO_CACHE user_id from table_a where user_id in (select SQL_NO_CACHE user_id from table_b where ... blah) 9.5 seconds...

Re: arrangement of fields in a table

On Mon, Jun 09, 2003 at 01:40:47PM -0400, Mojtaba Faridzad wrote: Hi, I need to define for example 100 fields in a table. 8 of them are more important and many queries just need these fields. Should I define them before the other fields in the table or it doesn't matter? Is accessing the

Re: subselects in 4.1 and indexes

On Mon, Jun 09, 2003 at 12:46:32PM -0500, Christopher Knight wrote: Im have a problem / misunderstanding with the 4.1 release. Im having issues with indexes related to 'IN' vs '=' in subselects. assume the subselect returns 1 value select SQL_NO_CACHE user_id from table_a where user_id in

Re: array/pointer question

Some intros on the web are listed at http://www.artfulsoftware.com/dbresources.html - Original Message - From: John Griffin To: Ioana ; [EMAIL PROTECTED] Sent: Monday, June 09, 2003 10:38 AM Subject: RE: array/pointer question Hi, MySQL, like other relational databases,

Re: array/pointer question

Peter Brawley wrote: MySQL, like other relational databases, does not support arrays or pointers. Of course, relational databases don't allow duplicate rows in table, either... g I have yet to find a relational database with that feature! Bruce Feist -- MySQL General Mailing List For

Re: array/pointer question

Peter Brawley wrote: MySQL, like other relational databases, does not support arrays or pointers. I didn't write that. PB

fastest way to get last row

Hi Does anyone have tips on the fastest way to get the last row in a table. What I have is an int as the the primary key, using auto inc. I currently do a select max(id), then run another query retrieving a row based on the the max(id). Its two queries. Would I be able to get it all into

RE: fastest way to get last row

SELECT * FROM table ORDER BY id DESC LIMIT 1; Regards, Miek Hillyer www.vbmysql.com -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 12:23 PM To: MySQL List Subject: fastest way to get last row Hi Does anyone have tips on the fastest way

Re: fastest way to get last row

On Mon, Jun 09, 2003 at 02:22:56PM -0400, Chris Edwards wrote: Hi Does anyone have tips on the fastest way to get the last row in a table. What I have is an int as the the primary key, using auto inc. I currently do a select max(id), then run another query retrieving a row based on the

Re: Hi CPU on FreeBSD

We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're running that queries the database (Request Tracker 3), we still get

Re: array/pointer question

Peter Brawley wrote: Peter Brawley wrote: MySQL, like other relational databases, does not support arrays or pointers. I didn't write that. My apologies -- it was written by John Griffin, not Peter Brawley. I edited carelessly. Oops. Bruce Feist -- MySQL General Mailing

Re: fastest way to get last row

Couldn't something like this work? SELECT id,foo,bar FROM tbl ORDER BY id DESC LIMIT 1 Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \

diff between 7.2 and 8.0 rights?

Hi I have 2 servers both with 3.23.56-1 installed via rpm's proteus2 which is running RedHat 7.2 on 1 cpu and has been in use for over 1 year works as expected. [EMAIL PROTECTED] [/var/lib/mysql]# mysqladmin status Uptime: 515357 Threads: 1 Questions: 2412696 Slow queries: 782 Opens: 19654

**field type for large amount of text***

What is the best field type to use for a field that will be used to display a large amount of text (and possibly numbers) IE a field that will display the main text for a web page. Thanks -Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: **field type for large amount of text***

Well, that would be TEXT, MEDIUMTEXT, or LARGETEXT, they hold 65535, 16777215, and 4294967295 characters accordingly. I personally would stick to TEXT, maybe MEDIUMTEXT. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent:

Duplicates, but different

Good Afternoon! I have a table like this; id (unique, auto-increment) foo char(6) bar char(10) foo may be duplicated from row to row, bar may be duplicated from row to row i.e. foo bar 949433 IRVINE 949514 NEWPORTBCH 949514 NEWPORTBCH 949533 IRVINE 949533 IRVINE 949633 SADLBK VLY It

Re: fastest way to get last row

Hi Thanks! Looks like everyone knew the exact answer. I guess I posted too soon, as I figured it out also. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: Ryan Yagatich

money field

Hi, Which type do you usually use to keep money values? Decimal (12,2) or Float? to keep the first one, system takes 12 bytes but for the second one, 8 bytes. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Hi CPU on FreeBSD

On Mon, Jun 09, 2003 at 11:26:36AM -0700, Lalo Castro wrote: We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. Great. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're

Turning off column and value reconciliation

I'm getting the error message:- http://forums.devshed.com/t49723/s.htmlGeneral error: Column count doesn't match value count I know what it means, but I need MySQL to turn off this checking. I'm loading legacy data into a new database that has some extra columns and I just want to fill the old

Joining unrelated data

I have three tables, to model a purchasing system: transaction number client date purchased_product transaction product price payed_amount transaction date amount This model allows me to have a transaction with multiple products and also record several payments on the

RE: Turning off column and value reconciliation

Why not just specify what columns you are inserting into? This check has to be in place, because in the case of a mismatch MySQL would not know which value goes into which column. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL

Re: Turning off column and value reconciliation

On 9 Jun 2003 at 12:13, Campbell D. McCausland wrote: http://forums.devshed.com/t49723/s.htmlGeneral error: Column count doesn't match value count I know what it means, but I need MySQL to turn off this checking. I'm loading legacy data into a new database that has some extra columns and I

RE: money field

I would use Decimal (12,2). A Float may be smaller, but only because it rounds off the last several digits of large values. A single-precision float uses 23 bits for storing digits, meaning that for values over 8,388,607 you are loosing pennies. When storing a value around 100 Million you would

Re: money field

A Float may be smaller, but only because it rounds off the last several digits of large values. ... Not big losses, but when dealing with financial accounting it is generally an unacceptable inaccuracy. More to the point, if the DB rounds oddly, your attempts to access the data might fail.

Re: money field

I use Decimal, because I like my money calculations to be correct. Mojtaba Faridzad wrote: Hi, Which type do you usually use to keep money values? Decimal (12,2) or Float? to keep the first one, system takes 12 bytes but for the second one, 8 bytes. Thanks -- MySQL General Mailing List

SSL and Windows

Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package but there isn't one for Windows. Help! Thanks in advance!! Robin E. Kopetzky Black Mesa Computers/Internet Services

Re: ADD CONSTRAINT on InnoDB tables

Marco, - Original Message - From: Marco B [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, June 09, 2003 8:45 PM Subject: ADD CONSTRAINT on InnoDB tables Hi all,=0D=0A=0D=0AI've just installed mysql 4.0.1 on my pc and I'm tryin= g to migrate a set of old MyISAM

RE: SSL and Windows

Are you looking to encrypt fields or the entire session between client and server? SSL is used for the latter, for the former you could look at the ENCODE and DECODE functions. (See http://www.mysql.com/doc/en/Miscellaneous_functions.html) I can use them without openssl being installed. Regards,

Re: SSL and Windows

http://www.google.com/search?q=openssl+windowsie=UTF-8oe=UTF-8 On Monday, June 9, 2003, at 01:43 PM, Sparky Kopetzky wrote: Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package but

Re: Turning off column and value reconciliation

Mike, Keith, Thank you for your responses. Unfortunately, the sql I'm loading is output from another tool, so I don't get to vote on the format of the insert statements. If it's not possible to just turn the check off, then I guess I'll have to consider writing a perl script or something to add

RE: Turning off column and value reconciliation

There is no way to turn it off (well, no practical way, with open source nothing is impossible). Can you add dummy columns to the mysql table to the insert statements match up? Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL

Re: Turning off column and value reconciliation

On 9 Jun 2003 at 13:16, Campbell D. McCausland wrote: Thank you for your responses. Unfortunately, the sql I'm loading is output from another tool, so I don't get to vote on the format of the insert statements. If it's not possible to just turn the check off, then I guess I'll have to

RE: Turning off column and value reconciliation

Thanks for the suggestion Mike, but I have more columns than data values already 8o) At 02:17 PM 6/9/2003 -0600, Mike Hillyer wrote: There is no way to turn it off (well, no practical way, with open source nothing is impossible). Can you add dummy columns to the mysql table to the insert

Re: Turning off column and value reconciliation

Thanks for the suggestion, but its a tossup between that and the perl 8o( I'll need to give it some thought about how much I want to port. MySQL is sure easier to install and also faster (I'm told anyway, without getting my data in I can't be sure). best, Campbell At 04:22 PM 6/9/2003 -0400,

Re: Hi CPU on FreeBSD

the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: set-variable = key_buffer_size=100MB set-variable = read_buffer_size=5M set-variable = table_cache=500 set-variable = max_delayed_threads=0 set-variable =

Re: Hi CPU on FreeBSD

On Mon, Jun 09, 2003 at 01:41:00PM +, Gustavo A. Baratto wrote: the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: What about actual CPU usage? Did is increase similarly? The load average isn't

alter table blocks other tables!

I have a mysql server containing multiple databases, one of the databases is very important that it is not slowed down by other databases. This database is used for a real time game server (card games), and any stalls causes all players to stall, they hate that. I've mostly solved this problem

Re: Hi CPU on FreeBSD

CPU usage improved a lot as well... It's always above 90% free and before it was 70-75% idle... here is a snapshot: last pid: 58730; load averages: 0.09, 0.11, 0.08 up 9+20:59:57 17:11:24 216 processes: 1 running, 215 sleeping CPU states: 0.0% user,

Re: alter table blocks other tables!

On Mon, Jun 09, 2003 at 01:05:43PM -0700, Dan Edwards wrote: I have a mysql server containing multiple databases, one of the databases is very important that it is not slowed down by other databases. This database is used for a real time game server (card games), and any stalls causes all

Re: alter table blocks other tables!

You say you are using replication. In this situation, if you make an update to the master (using ALTER...) that takes a long time, this will get serialized into the binary log as normal and block all subsequent queries from executing on the slave until it has completed. One of the issues with

INNODB Transactions

Hi : I would like to know what happen if I start a transaction using BEGIN command I do some insert or update statements, and just before executing a ROLLBACK or COMMIT command I get disconnected and I can't execute those commands. For how long does the table remain locked, or in other words

Default Datetime?

Hello I have a table for messages, and when a new message is inserted I want the current date and time to be inserted into the MessageDated and MessageTimed fields. I'm using MySQL 3.23.56 (?), with Chilisoft ASP, and using the MySQL Control Center interface. The problem is that no matter what

Re: Default Datetime?

On Mon, 2003-06-09 at 16:23, Trevor Sather wrote: How can I get the default value to be now()? The only way I've succeeded is by setting the type of field to VARCHAR, but that's not ideal. Trevor, take a look at the TIMESTAMP type: http://www.mysql.com/doc/en/DATETIME.html or, if you would

Re: arrangement of fields in a table

Hi Mohitaba, Sounds to me that it makes sense to put the important 8 fields at least in a separate table to speed up any SELECT requests. You may even consider putting a copy of the small table containing only the 8 fields into the memory as a heap table ( if they are not containing any blobs

Newbie Installation Question

When executing from the COMMAND PROMPT, the following is returned:C:\cd mysql C:\mysqlcd bin C:\mysql\binmysqlshow -u Administrator --password=1234567890 mysqlDatabase: mysql+--+| Tables |+--+| columns_priv || db || func || host || tables_priv || user

Insert Image content via command line

Hi, I am trying to insert an image directly from command line into mysql table. My table looks like == Create table ImageTab (id int, content longblob); === I login to localhost. I have an image at /tmp. Then i issue this query insert

Re: alter table blocks other tables!

Can you grab the output of 'vmstat' or iostat or something that'll measure disk I/O next time this happens? I'm going to try real hard not to do that again until it is upgraded or another solution is found. What'd help more is adding more disks not a single faster one--unless the SCSI disk is an

Re: Default Datetime?

You can't use a default value of NOW(), to the best of my knowledge. However, if your INSERT statement is properly formatted, you should have no problem getting it to do as you please. Personally, rather than having two hidden form fields, I'd just setup my INSERT statement as follows (using PHP

  1   2   >