Member Avatar for RicardoE

Hello,

I have a problem, I'm interfacing C# with MySQL
it seems to be that a lot of connections are left open even when the close() function and the dispose() functions are called.

Also I've notice that the server only resists like 80 queryes at the time, then it halts due to connections timeouts, and everything crashes :(.

Si if someone please have some tool to tune up MySQL for windows, let me know, or any sugestions are welcome.

P.S: I have tried set wait_timeout = 30; it does it but at certain time it returns to its default :(

Thanks.

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Momerath
Member Avatar for Momerath

You don't say how you are connecting to the MySQL database. Are you using OleDB or one of the many MySql to .Net libraries? Have you tried a different method?

Post your DB code (probably the C# forum would be a better place) and maybe we can point out something you are doing.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.