mysql

Hello!
Help to understand what to do. I optimizes views

The first boot - everything is bad ((
Executed 350 queries in 823.4 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 1367.98 ms.

Buenas,

tengo un cliente con un hosting que tiene un plan ilimitado de base de datos MySQL. El tema es que es, todas las bases de datos que tu quieras con 1GB de limite. Y la web en cuestión ya ha llegado a ese limite, y se bloquea con el accesslog y whatchdog enviando "Additional uncaught exception thrown while handling exception."

It comes with me when I am setting database configuration in installation of OpenScholar.

Warning: in DatabaseConnection->__construct() (line 304 of C:\BitNami\wampstack-5.3.23-0\apps\drupal\htdocs\includes\database\database.inc). Warning: htmlspecialchars(): Invalid multibyte sequence in argument in check_plain() (line 1572 of C:\BitNami\wampstack-5.3.23-0\apps\drupal\htdocs\includes\bootstrap.inc).

And, I cannot log in the server by using "root" and the password I set previously.

How can I solve it?

Although I am sure this is a perennial topic in this group, I would like to start (yet another) discussion on optimization of my.cnf. I really don't understand mysql at all, and I have found even the slightest change to the my.cnf settings has a massive impact on my server performance.

I could really use some advice on settings from the group. Hopefully this threat can grow and be useful to others in the future.

My setup:

Why?

The first idea that came to my mind when I first ran cache clear that lasted a minute or so, was "I want it run quicker!". If you are those unhappy guys who don't have an SSD, but do have a bit of RAM - you may find this discussion interesting and useful.

I am currently looking for project opportunities, senior web developer for 8 years, Drupal developer for three years, module development and everything drupal.

Visit my resume website at http://www.ralphfrancois.com or my freelancing website at http://www.studgate.com.

If you are looking for help, I am the guy so email me at ralph@studgate.com

I am wondering what tuning and configuration do you do to make your environment faster?

Here is my experience:

1. Got more memory utilization from installing PAE on 32 bit Linux.
2. Installed APC, tuned MySQL and got about 50-100% performance boost. See my blog post for more details: http://vmirgorod.name/blog/boosted-lamp-drupal-devs
3. Realized that new NetBeans 7.1.2 is working much faster then Komodo IDE, Zend Studio or Eclipse. People says that 7.2 RC are even more faster. Checkout here http://www.netbeans.com/downloads/index.html

Hello!

Having a pretty old laptop as my primary development workstation, I'm very concerned about development speed. Under development process I mean the most frequent operations you do when making a website, like:

• installing and configuring modules
• creating and configuring entities (nodes, products) and fields
• theme development

After several hours of uncertainty it seems that I have managed to migrate a MySQL Drupal to a PostgreSQL. So I want to share my experience with this group where I think could be useful.

There are several problemas to solve: table structure translation, autoincrement values / sequences, serialized data, etc.

I've tried several ways, but always I came up against some problem.

Database schema

MySQL and PostgreSQL use different data types for its columns, they define its tables in its own way, you can't use MySQl definitions.

Hello,

First please excuse me if the answer was easily reachable but I've looked at the group first 5 preview pages and did a search on schema which yielded the same preview as default so I assumed it this was the default behavior when keywords failed to bring results.