Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Joerg Bruehe wrote: Yes, it does announce. I wrote "any external event ... that Windows *would* monitor" (emphasis added): Does the Windows ServiceManager really know which file to monitor for which entry to announce the service as "running" ? see below. in practice we find the service co

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Joerg Bruehe wrote: I assume Windows reports the status as "running" when the process(es) got started, but that doesn't necessary imply they have passed their own initialization / startup phase. I doubt there is any external event (say, a file creation or some such) that Windows would monit

Re: mysqld-nt Windows service: delay btwn svc running and accepting conx

Sebastian Mendel wrote: did you take a look add the MySQL log? there you can see what MySQL is doing, with times perhaps i wasn't clear earlier. we checked the logs, and we see that Innodb is started and accepting connections sometimes 1-6 seconds AFTER we see the Windows ServiceManager repo

mysqld-nt Windows service: delay btwn svc running and accepting conx

the point, what determines the time delay between SERVICE_RUNNING and " ... mysqld-nt.exe: ready for connections " and is there a tried and true way to detect "ready for connections" without simply making a connection attempt??? thanks Les Schaffer -- MySQL General M

Re: innodb to be removed? and...

Jim Winstead wrote: > No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, "how far into the future does MySQL see?" do you have a number in mind, like 1 year, 3 years, 3 months, 3 days? Les Schaff

Re: innodb CHECKSUM TABLE

... we are using file-per-table. also, it occurred to me after sending my first email: perhaps innodb is already doing something under the hood to make sure the tables are in the same state on startup as they were left on shutdown Les -- MySQL General Mailing List For list archives: http:/

innodb CHECKSUM TABLE

we are doing a checksum on our Innodb tables before we shut the server down (Windows) so that when we restart, we can compare the before and after. the reason for this is we are encrypting files in between data collection sessions, and we are making double sure we haven't munged our data. however,

weird drop database error

we did simply execute the query 'DROP DATABASE BCS' which i THINK is passed straight through to the MySQL engine. query: does "drop database XXX" delete tables regardless of foreign key constraints? we are using innodb. but i thought "drop database xxx" deletes tables

protecting sensitive info in data directory

MySQL files ANYWHERE that i should be aware of? Does MySQL ever write anything to the Windows temp directories? (Windows only app) yes, i am aware of MySQL encryption on a per field basis. we were asked to encrypt the whole table. many thanks les schaffer -- MySQL General Mailing List For list

mysql's mysql db in one place, other db's in another???

and, BTW, we are starting the service with --innodb-file-per-table in case this matters, les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql's mysql db in one place, other db's in another???

th all three of these options, whether all the data dirs have to be in one place? thnx les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

copying rows from one MySQL server to another

since other laptops will be checking in data too into the same tables. thanks les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: View onto tables w/ identical key names

am i typing close to 1000 field names into the query browser ;-) thanks les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

View onto tables w/ identical key names

ine choice for now) must be < 1000 columns. we are good there and also we are < 8000 bytes per record in each table. can a VIEW be wider than 8000 bytes? many thanks les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: CREATE TABLE and specifying DEFAULT

fast help. i am new to the mysql list and i can see it "works". les schaffer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE and specifying DEFAULT

Gordon Bruce wrote: I just ran the creates on 4.0.20 on LINUX and 5.0.6 on Windows i was running 5.0.4 on Windows: mysql> \s -- mysql Ver 14.9 Distrib 5.0.4-beta, for Win32 (ia32) switching to 5.0.6 now. anyone wanna make a bet ;-) les schaffer -- MySQL General Mail

CREATE TABLE and specifying DEFAULT

| | | ID_province_hosp| char(2) | YES | | NULL| | | ID_postal_code_hosp | char(7) | YES | | NULL| | | ID_phone_number_hosp| char(12) | YES | | NULL| | | ID_work_number_hosp | char(20) | YES | | NULL| | | ID_cell_number_hos