Re: How can I keep character_set_client value after MyODBC auto reconnect?

Thanks a lot. I needs SET AUTOCOMMIT=0, SET NAMES utf8 and SET TRANSACTION ISOLATION LEVEL READ COMMITTED after a new connection. Further more, MyODBC3.51.10 reconnects automatically when connection lost but MyODBC3.51.12 doesn't. I think automatic reconnection is not bad when it can keep variabl

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Francesco Riosa wrote: > And another one is (in inverse order for laziness): > > select > (8 & 1) AS `0` > , (8 & 2 > 1) AS `1` > , (8 & 4 > 1) AS `2` > , (8 & 8 > 1) AS `3` > , (8 & 16 > 1) AS `4` > , (8 & 32 > 1) AS `5` > , (8 & 64 > 1) AS `6` > , (8 & 128 > 1) AS `7` > ; > but this one look

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

And another one is (in inverse order for laziness): select (8 & 1) AS `0` , (8 & 2 > 1) AS `1` , (8 & 4 > 1) AS `2` , (8 & 8 > 1) AS `3` , (8 & 16 > 1) AS `4` , (8 & 32 > 1) AS `5` , (8 & 64 > 1) AS `6` , (8 & 128 > 1) AS `7` ; Ed Reed wrote: > Well I solved the problem by using LPAD but it wo

RE: mysql 5 - disk bound ?

RE: mysql 5 - disk bound ?Replying to my own message. Both of these tables have several indexes. As mentioned before, My myisam_sort_buffer_size is fairly large : myisam_sort_buffer_size | 134217728 alter table xxx disable keys (But this table is INNODB) I tried alter table xx disa

Re: InnoDB per-table table spaces

At 23:44 + 1/10/06, Marvin Wright wrote: Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So

InnoDB per-table table spaces

Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So 6Meg free, I assumed this was 6Meg free in the

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Well I solved the problem by using LPAD but it would be nice if there was a more elegant way of handling this problem. Thanks for the help. >>> "Ed Reed" <[EMAIL PROTECTED]> 1/10/06 2:52 PM >>> Thanks Gordon and Bill but this has one big problem If my decimal number is 8 the result ends up, R

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Thanks Gordon and Bill but this has one big problem If my decimal number is 8 the result ends up, Results: +---+---+---+---+---+---+---+---+ | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | +---+---+---+---+---+---+---+---+ | 1 | 0 | 0 | 0 | | | | | +---+---+---+---+---+---+---+---+ when what i reall

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Actually CONV converts from any base to any base so if it is base 10 then just replace the 16's with 10's. Too much time looking at dump's. -Original Message- From: Bill Dodson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 3:09 PM To: Gordon Bruce Cc: Ed Reed; mysql@lists.my

localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'

OK here goes I've had a problem for a few days that I can't resolve. At the OS level If I ping the name localhost I get a good return and if I ping 127.0.0.1 I also get a good return as noted below. [EMAIL PROTECTED]:~# ping localhost -c 2 PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes

Re: Converting decimal to binary

If you really do mean decimal (base 10) you could use Gordon's solution like this: SELECT MID(CONV(HEX(245),16,2),1,1) AS `7`, MID(CONV(HEX(245),16,2),2,1) AS `6`, MID(CONV(HEX(245),16,2),3,1) AS `5`, MID(CONV(HEX(245),16,2),4,1) AS `4`, MID(CONV(HEX(245),16,2),5,1) AS `3`, MID(CONV(HEX(245),16,

RE: Converting decimal to binary

If by Decimal you mesn HEXIDECIMAL you can use CONV where the 1st arg is the HEX value, 2nd arg is From Base and 3rd arg is To Base. You will have to suround the aliases with "`'s" if you really want the names to be numeric. mysql> select MID(CONV('A5',16,2),1,1) AS `7`, ->MID(C

Converting decimal to binary

Can anyone tell me if it's possible, in 4.1.11, to convert a decimal number to binary and have the result be returned as a separate field for each bit? For example, what I'd like to do is, Select ConvertToBin(245); And have a result that looked like this +---+---+---+---+---+---+---+---+ | 7 |

mysql 5 - disk bound ?

Hi All, I have a question for you all. Working with 2 innodb tables. One is a table of cdrs (call detail records) with 33 columns and 7 million + rows. Second table is a clone of the first, meant as a "work" table. >From the mysql command line client, I gave the query : insert into table2 sele

Re: Geogrphic Advise

Jigal, Thanks, I'll give this a go... Ben Jigal van Hemert wrote: Ben Clewett wrote: But the index does not seem nearly as fast as liner (normal) indexes. Hence using a less effective liner index may be better... After this method I still need select a radius within these data points, mor

Re: checking for corruption?

Hi , Alternate solution : Do show table status on that database . In comment field you can find info about corrupted table . This will be faster than check table . Thanks Praj - Original Message - From: "N.J. Thomas" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 10, 2006 9:00 PM S

Re: temporary table issue

Ben Clewett wrote: But the index does not seem nearly as fast as liner (normal) indexes. Hence using a less effective liner index may be better... After this method I still need select a radius within these data points, more effort. This could be an excellent case for using HAVING The WHER

RE: Geographical advice

Sorry, subject corruption, my last email should have had this subject, not 'temporary table issue'... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: temporary table issue

Thanks for the excellent advise. In the mean while a friend Googled me an article suggesting that this can be done using the POINT and SPATIAL INDEX. But I prefer your ideas. I'll show what I found because I want to see if anybody has an opinion on problems with either method: Here I Store

checking for corruption?

After a power outage, we had a large table (~2GiB, 23e6 records) get corrupted. Only a few rows were actually affected, so nobody noticed for a few weeks though. A repair fixed the problem. We are now considering running the "check table" command regularly (every 15 minutes?) and plugging that int

Stored procedure work badly with binlog

I found a problem using stored procedure and bin-log enabled. Suppose I stored procedure like this: == DELIMITER $$; DROP PROCEDURE IF EXISTS `pmv_manager`.`pAggiornaStatusNotificaPMV`$$ CREATE PROCEDURE `pAggiornaStatusNotificaPMV`( ipAddrPMV var

Thank you for your email support request

Thank you for your email support request. Our support team will respond with the recommended solution in the quickest time possible, but may be delayed due to the complexity of the problem or volume of requests for support". Once we have replied to your initial question, please be sure to use yo

Re: too many connections crashing MySQL?

I would have provided a resolved stack trace if there was one referred to in the mysqld.err. I believe it's what Alex said: innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB uses more memory than I have. To t

Re: temporary table issue

Hi, Jigal Thanks a lot. It works. > Xiaobo Chen wrote: >> Hi, all >> >> I am trying to use this with error: >> >> drop temporary tabel temp_a if exists 'temp_a'; >> >> it said syntax error. > > Try: > > DROP TEMPORARY TABLE IF EXISTS `temp_a`; > > ('table' instead of 'tabel'; table name only once

Re: temporary table issue

DROP TEMPORARY TABLE IF EXISTS `temp_a`; Xiaobo Chen wrote: Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Could anybody tell me the right syntax? I didn't find the answer after googling a while. Thanks in advance. Xiaob

Re: temporary table issue

Xiaobo Chen wrote: Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Try: DROP TEMPORARY TABLE IF EXISTS `temp_a`; ('table' instead of 'tabel'; table name only once; backticks around table name instead of quotes) http://dev

RE: Geographical advice

James is right. I use this method on a table with a combined index on 50 million rows and it's almost instantaneous. Performance was vastly improved after I did an "alter table order by x" Andy > -Original Message- > From: James Harvard [mailto:[EMAIL PROTECTED] > Sent: 10 January 2006

temporary table issue

Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Could anybody tell me the right syntax? I didn't find the answer after googling a while. Thanks in advance. Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, No

Re: Geographical advice

If you visualise your search area as a circle around your 'target' coordinates, then you can eliminate many of the irrelevant rows by search for coordinates that fall within a square surrounding that circle. So, imagine a simple grid with target coordinates of 6,8 and a search radius of 3. Ther

Re: How to update record obtained from a query result?

Hi, Thanks for your help. Regards, Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

missing table

In a new setup I had the users table in MySQL. A few hours later I went to setup a new account and found out that the user table is missing. Is there a way to get it back? I can still login as root and myself. I wanted to add another user to the database. Thanks -- MySQL General Mailing Lis

Re: How to define utf8 function

Hello. This is still a bug. See: http://bugs.mysql.com/bug.php?id=16330 Hirofumi Fujiwara wrote: > Hi, > > >>Hello. >> >>This should be fixed in 5.0.18. See: >> http://bugs.mysql.com/bug.php?id=13909 > > > 17.2.1. CREATE PROCEDURE and CREATE FUNCTION > http://dev.mysql.com/

Re: too many connections crashing MySQL?

Hello. Please, could you provide a resolved stack trace. I know sometimes, it is difficult in a heavy loaded production environment, but check if the problem still exists on the official binaries of the latest release. Have a look here as well: http://bugs.mysql.com/bug.php?id=15868 s

Re: cannot connect to mysql

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html ghislain groulx wrote: > im quite new to mysql and here is the problem. I simply cannot connect > to mysql through phpmyadmin or anything else. Lets say i enter the url > to connect (localhost/phpmyadmin/ind

Re: DATE problem

Hello. MySQL doesn't support this syntax. See: http://dev.mysql.com/doc/refman/5.0/en/create-table.html If you want to automatically extract the year (month, day) part from the inserted value, you may want to use TRIGGERS, however, in my opinion, it is better to redesign your table struc

Re: R: how use sql_slave_skip_counter to restore slave replication

Hello. > I already tried the option --slave-skip-errors, but i didn't work as > expected. > When this option is enabled, the slave didn't report the error message, but > the slave is stopped due the error. May be server dies due an error message which was not included in the slave-skip-e

Geographical advice

Hi, I have a need to locate (x,y) coordinates from mysql where they are close to another coordinate. For instance, all pizza bars near my car. Example: Searching for points closer than z to (i,j) using Pythagoras: SET i = 10; SET j = 10; SET z = 30; SELECT x, y FROM coordinates WHERE PO

Re: How can I keep character_set_client value after MyODBC auto reconnect?

Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: "古雷" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep character_set_client value after My

R: how use sql_slave_skip_counter to restore slave replication

I already tried the option --slave-skip-errors, but i didn't work as expected. When this option is enabled, the slave didn't report the error message, but the slave is stopped due the error. The target I need to reech is to get two server A e B, each of them have its own db server and a set of ap

DATE problem

Hy all I would like to get date in my web page. There are three different fields. YEAR MONTH and DAY I thought in SQL possible create table like this /*from my book*/ create table dates ( input_year DATETIME YEAR TO YEAR, input_month DATETIME MONTH TO