Re: null data in table question

Hi, don't forget to apply the correct changes to your queries. Having NULLs or not, let you write for example : select ... from ... where midinials is NULL; And be aware about NULL indexation in some storages. Those values are not indexed for example in oracle. I'm not sure about innodb, but

mysql 4.0 to 4.1 migration and charset problems

Hi, I have mysql 4.0 db with configuration: set-variable = default-character-set=latin2 set-variable = character-set=latin2 now I'm trying to migrate to mysql 4.1.12 My current config is: character-set-server=latin2 collation-server=latin2_general_ci The problem is

Re: mysql repl

Hello. Could you examine slave relay log and master binary log to find which statement causes duplicated entry with mysqlbinlog utility. Which versions of MySQL do you use on your master and slave? See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html

Misconfigured master - server id was not set

Hi, I have slave-master-setup that is special in two ways: 1) The slave connects through an stunnel 2) The slave replicates only one db As soon as I start the slave process, the server connects but fails with the following log messages: Jul 6 14:58:11 ijssel1 mysqld[11755]: 050706 14:58:11

Re: Network drive

I think I haven't understood your question. I guess that in case of a network failure you can have the same behavior as a power shutdown. About the networked drives? Anyone? --- Martijn Tonies [EMAIL PROTECTED] wrote: Hi Ruben, I would like to make a short, quick and simple question.

Mac OS X Table Corruption

I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. I previously had a MySQL install on 10.2 Client under 3.x and never had an issue or any major problems at all. I upgraded to MySQL 4.x and have subsequently installed MySQL 4.x (from the supplied pkg's) on my

Re: Network drive

Ruben Carvalho [EMAIL PROTECTED] wrote on 07/06/2005 11:06:10 AM: I think I haven't understood your question. I guess that in case of a network failure you can have the same behavior as a power shutdown. About the networked drives? Anyone? --- Martijn Tonies [EMAIL PROTECTED] wrote:

Re: Mac OS X Table Corruption

I had someone on the mac-osx server admin list point this out to me: http://docs.info.apple.com/article.html?artnum=107852#sql which is regarding a byte-ordering issue resolved in an upgrade from OS X 10.3.2 to 10.3.3. Now in my case I could have upgraded with out performing this

Re: Mac OS X Table Corruption

Dan Tappin [EMAIL PROTECTED] wrote on 07/06/2005 11:26:13 AM: I am running into repeatable table corruption with MySQL 4.x on Mac OS X 10.x. I previously had a MySQL install on 10.2 Client under 3.x and never had an issue or any major problems at all. I upgraded to MySQL 4.x and have

Re: Network drive

Well, thank you very much for your explanation. My problem is I would like to have the data files being saved in a machine behind a proxy but the server running in a machine outside the proxy (the clients don't have access to the machine behind the proxy). Any ideas? Thank you --- [EMAIL

Re: innodb crashes during heavy usage with exceeded memory error

Thank a lot for your quick reply. SInce we are not using myisam tables ( except for the system tables), I deallocated memory from myisam and allocated to innodb. When I allocated close to 1.7G to innodb buffer size, mysql used to crash more often. So I decreased innodb_buffer_size to 1G.

Re: Network drive

Ruben Carvalho [EMAIL PROTECTED] wrote on 07/06/2005 12:54:24 PM: Well, thank you very much for your explanation. My problem is I would like to have the data files being saved in a machine behind a proxy but the server running in a machine outside the proxy (the clients don't have access

Re: Network drive

Ruben Carvalho wrote: Well, thank you very much for your explanation. My problem is I would like to have the data files being saved in a machine behind a proxy but the server running in a machine outside the proxy (the clients don't have access to the machine behind the proxy). Any ideas?

Re: Network drive

I don't have a web server, I mean, I have a standalone java application running in my clients and the application calls the database. Is there any way of having something listening to my application calls in my open machine (outside the proxy) and this something would then call the database

RE: Network drive

something = ODBC is the first thing that comes to mind. You can set specific permissions on the ODBC and you don't have to open up but 1 port (3306 or whatever you choose) in your proxy / firewall. Whenever your app calls the ODBC, the connection is made and everything is happy. Just my $.02

Re: innodb crashes during heavy usage with exceeded memory error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kasthuri Ilankamban wrote: [snip] The table that's it's complaining about is a session table which stores web session information. Basically the data in that table is a throw away data and gets deleted when the user logs out. The session

RE: Network drive

He doesn't need ODBC to make a connection, his Java app is doing that already... I agree with J.R., you should move your database server behind your firewall and just open the one port (3306). If you would prefer, you can designate your database server to use a different port (42000 for

Finding all Childless Parent Records v. 3.32

Hi all, I have a table: id, name, parent_id I need to find all records that have no children. I know how to do it using a sub select, but I need to do this in version MySQL 3.32 and I am not sure how. Thanks, Charles -- RightCode, Inc. 900 Briggs Road #130 Mount Laurel, NJ 08054 P:

Data type DOUBLE and DATETIME

I want to store a date of this format mmddhhmmss.ss Should I use DOUBLE as the data type? Yes I do need all the .sss's. Or should I use DATETIME and then have another column to store the fraction of seconds? -- MySQL General Mailing List For list archives:

Re: Mac OS X Table Corruption

On Jul 6, 2005, at 10:26 AM, [EMAIL PROTECTED] wrote: I'm not a Mac guru but what you describe sounds like file system corruption. Can you do a diagnostic scan of your hard drives looking for bad sectors? You can move your data to another portion of the disk if you run an ALTER TABLE to

Re: Finding all Childless Parent Records v. 3.32

Charles Kline [EMAIL PROTECTED] wrote on 07/06/2005 02:25:12 PM: Hi all, I have a table: id, name, parent_id I need to find all records that have no children. I know how to do it using a sub select, but I need to do this in version MySQL 3.32 and I am not sure how. Thanks,

Re: innodb crashes during heavy usage with exceeded memory error

A big part of your problem seems to be that 32bit OS's can not allocate more than 2G memory to a single process, and with each client connection needing so much buffer space, you quickly exceed that limit. Short of moving to a 64bit OS, the only solution I have come across that allows mysql to

Re: MAX on UNSIGNED INT Column

Jacob S. Barrett wrote: I have a column of type UNSIGNED INT which holds a 32bit counter. When the value of the field exceeds 2147483647 (signed max) the value of MAX on the column returns a negative number. Possibly this bug, fixed in 4.1.12? http://bugs.mysql.com/bug.php?id=9298 -- Keith

Re: Data type DOUBLE and DATETIME

Haisam K. Ido [EMAIL PROTECTED] wrote on 07/06/2005 02:35:54 PM: I want to store a date of this format mmddhhmmss.ss Should I use DOUBLE as the data type? Yes I do need all the .sss's. Or should I use DATETIME and then have another column to store the fraction of

Re: MAX on UNSIGNED INT Column

On Wednesday 06 July 2005 11:42 am, Keith Ivey [EMAIL PROTECTED] wrote: Jacob S. Barrett wrote: I have a column of type UNSIGNED INT which holds a 32bit counter. When the value of the field exceeds 2147483647 (signed max) the value of MAX on the column returns a negative number. Possibly

Re: innodb crashes during heavy usage with exceeded memory error

Matthew has already responded. But I will also add, you must rethink how your application is coded. I can not possibly imagine a situation where a user session needs 200meg insert. No matter what database you use you will have a terrible time trying to scale this application. If you give more

Help - need to quickly optimize a record count!

I am cross-posting this to the PHP and the MySQL lists because I'm not sure in which technology my solution will lie. I have a pretty busy PHP/MySQL site that executes the following query a lot: select count(*) as `count` from terms; My MySQL account was disabled by my ISP because this

UDF failure

Hello, I'm trying to build a UDF for MySQL 4.1.12. I'm running on Linux (FedoraFC1). My UDF function seemed to blow up the server so I went to the source and tried to build udf_example.cc. Using the precompiled binaries for Linux and using the source distribution for the same version

Re: Help - need to quickly optimize a record count!

Brian Dunning [EMAIL PROTECTED] wrote on 07/06/2005 04:43:11 PM: I am cross-posting this to the PHP and the MySQL lists because I'm not sure in which technology my solution will lie. I have a pretty busy PHP/MySQL site that executes the following query a lot: select count(*) as `count`

Re: Help - need to quickly optimize a record count!

Or even make .txt file with the cron and just include that txt file in your php ? include_once('figures.txt'); ? Then in backgrond with perl(php) and cron you will udate that .txt file :-) So it will be 1 quesry per 15 minutes :-) Peter [EMAIL PROTECTED] wrote: Brian Dunning [EMAIL

Re: UDF failure

Hello. When attempting to load a new function with the mysql cli client the client complains that the server has gone away and reconnects with connection Check MySQL error log, server could die while loading the UDF. Stored procedures appeared only in 5 version. This works fine for me

Re: Help - need to quickly optimize a record count!

Hello. What engine do you use? 'SELECT COUNT(*) FROM TABLE_NAME' is very optimized, however only for MyISAM tables. Have you thought about a dedicated table for such a purposes, or adding auto_increment column to the table? Brian Dunning [EMAIL PROTECTED] wrote: I am cross-posting

Re: why are these two queries deadlocking?

Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/innodb-locks-set.html In my opinion, the deadlock could appear in your case, according to that page. Because both REPLACE and INSERT could put next-key locks. And DELETE generally set record locks on every index record that is

Re: Misconfigured master - server id was not set

Hello. Setting master to 127.0.0.1 could produce a problem. MASTER_HOST and MASTER_PORT are the hostname (or IP address) of the master host and its TCP/IP port. Note that if MASTER_HOST is equal to localhost, then, like in other parts of MySQL, the port may be ignored (if Unix socket

noob : advice on design?

Dear Group, I have just completed the Sams MySQL in 24 hours and feel like I now have a reasonable understanding of creatinf queries, etc. However, the one area that seemed sadly lacking was that of database design. I recently purchased a book named Database design for mere mortals, which seems

mysql user name length

Hi all, Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may cause... Thanks, Tim. -- MySQL General Mailing

Re: mysql user name length

On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote: Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may

Re: UDF failure

Looks like you're confusing Prepared Statements with Functions/Stored Procedures. You don't compile a function, and you're using 4.1, you need Mysql 5. (specifically 5.0.3 I think, you'd have to look that up, but you would want 5.0.7 anyway. Maybe I have that confused with triggers, cant

Datediff

I am using 4.0.18-standard So I do not have `DATEDIFF`, but I need to ability to do so, anyone know some other simple trick to get days between two dates? -- - Scott HanedaTel: 415.898.2602

Re: Datediff

Scott Haneda wrote: I am using 4.0.18-standard So I do not have `DATEDIFF`, but I need to ability to do so, anyone know some other simple trick to get days between two dates? to_days(SomeDate) - to_days(SomeOtherDate) will give you the number of days between the 2. -- Daniel Kasak IT

Re: noob : advice on design?

fast and dirty - http://www.geekgirls.com/menu_databases.htm Do the design from scratch on the right side. Monty Harris wrote: Dear Group, I have just completed the Sams MySQL in 24 hours and feel like I now have a reasonable understanding of creatinf queries, etc. However, the one area

Re: mysql 4.0 to 4.1 migration and charset problems

Hello. For a pity, I could give explanations only for your query about selecting @@global.xxx variables. I think server returns correct results, because you're selecting global variables, while character_set_client, character_set_connection, character_set_results are session variables.