mysql server has gone away

If I fire a lot of querries, I get an error "mysql server has gone away/lost connection with the server" . I tried to use "mysql_ping()" to reconnect, but tht also fails... So shud i call real_connect again? I mean will it be gud practice tht way? I looked for such an error to have occured. I fou

Re: Question in ORACLE

In the last episode (Jan 16), Prem said: > I have a question in ORACLE indexing What is the difference > between B-Tree index and Bitmap index? A MySQL list isn't the right place to ask Oracle questions :) Oracle has excellent documentation and explains what Bitmap and B-tree indexes are, and

Question in ORACLE

Hello All, I have a question in ORACLE indexing What is the difference between B-Tree index and Bitmap index? Thanks in Advance, Prem

Strange InnoDB Deadlock Behavior

Hi Juan, Could the update log purging lagging behind due to a high UPDATE load cause this behavior? I was reading up here: http://dev.mysql.com/doc/refman/5.0/en/innodb-multi-versioning.html If so, would using innodb_max_purge_lag help? Thank you again so much. Best Regards, Jason -- MySQL Gen

RE: Extracting data from MySQL into Access

You can set up an ODBC connection to the MySQL data base, and then use Access directly on your data base. Does that come near what you want? (You can set it up read-only.) Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674

RE: Ms access front end and mysql back end

You didn't give us much information. If you open the Data Sources configuration, what happens when you test the connection? Did this ever work? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Mes

Re: MyISAM issues for UTF-8?

Read here: http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html have fun ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

Re: Index and Order By

It's possible mysql optimizes queries incorrectly. I've had to "correct it" on a few occasions. If you look at the results of the explain for Q1, you'll notice that in both queries the key_len is 1. Meaning Mysql thinks it only needs to look at the first "character" of the index. Based on that "o

Re: Index and Order By

Hi Kelvin, all! Kelvin Wu wrote: I am looking for help and suggestion. Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686) The table structure: [[...]] I created multiple parts of Index for this table: [[...]] And here are the questions: Q1: the query is supposed to use index bynone but ...

Re: Date format question

Assign all dates to have a day of 01 Store in a date field, use DATE_FORMAT to just extract the MM and . As you don't have the real day information it doesn't matter what day is used, so long as it present in all months. Hope this helps Robert Gehrig Webmaster at www.gdbarri.com e-mail: [

Re: Date format question

Olaf Stein wrote: Thanks... My issue is not storage, it is confidentiality. I am not allowed to store the day of birth as it is considered identifying information (in medical records). I do not even have the day, I want to pass a date in format (-MM) to a date field if possible. Pass the

Re: Date format question

Thanks... My issue is not storage, it is confidentiality. I am not allowed to store the day of birth as it is considered identifying information (in medical records). I do not even have the day, I want to pass a date in format (-MM) to a date field if possible. On 1/15/07 11:37 AM, "Chris Wh

Re: Insert ... Select troubles

When you said "multiple field unique key", I assumed those two field were your primary key. The way I described in the easiest way to implement it. Especially since you can do future insert/select without having to worry about figureing out sequence numbers for each group. You may want to think i

Re: Date format question

Is it possible in mysql to create a date field that stores year and month only (-MM) without having to zero out the day or use varchar type fields Best here is to just use a DATE field, then use DATE_FORMAT when you want to pull up the customized date. It will get stored as a timestamp (i

Re: Reading large(600k-1000k) number of records.

At 12:13 PM 1/13/2007, Nurullah Akkaya wrote: i have the following table in my database i am trying select postings based on wordId whole table has around 200 million records. DROP TABLE IF EXISTS `postingList`; CREATE TABLE `postingList` ( `wordId` MEDIUMINT UNSIGNED NOT NULL, `docId` INT U

Date format question

Hi All Is it possible in mysql to create a date field that stores year and month only (-MM) without having to zero out the day or use varchar type fields Thanks Olaf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Strange InnoDB Deadlock Behavior

Hello All, I have an issue that is seemingly hard to troubleshoot. Every so often transactions/queries on InnoDB tables will stack up such that all the queries appear to be waiting for others to execute. The problem is that the others never finish executing. If you try to kill the "Updating" thre

Re: Ms access front end and mysql back end

Do the following in 'mysql' client: select * from mysql.user\G Does you user have all necessary privileges maked as Y ? You may need to update your user's host field to '%' to allow you to connect from any host other than localhost. Don't forget run 'flush privileges;' afterwards. Give it a try

Re: Extracting data from MySQL into Access

Shortly, if you have MySQL ODBC driver installed, you can create ODBC data source and connect to this data source from Access, Excel, Open Office, Dusan Dewald Troskie napsal(a): Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in

Re: MyISAM issues for UTF-8?

On 15/01/07, Gabriel PREDA <[EMAIL PROTECTED]> wrote: Why is MyISAM problematic... MyISAM is a storage engine with some features... InnoDB is another storage engine with other features... and so on... As far as I know MyISAM is default storage engine... unless you specify by hand another storage

Extracting data from MySQL into Access

Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie

Ms access front end and mysql back end

I am failing to connect to my server. I am using ms access as front end and mysql as back end. What is the solution Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now. -- MySQL Gen

Re: MyISAM issues for UTF-8?

Why is MyISAM problematic... MyISAM is a storage engine with some features... InnoDB is another storage engine with other features... and so on... As far as I know MyISAM is default storage engine... unless you specify by hand another storage engine: CREATE TABLE xyz (colX INT NULL) ENGINE=_STORA